Types in programming

The purpose of a type system is to help validate the source code for a program. Without a type system (or some proxy for one) there is nothing to stop a programmer writing nonsense code such as adding apples and oranges. There’s nothing in Javascript or Excel to prevent these mistakes but there is in any statically typed language.

Relevant to the use of types in Excel are the following ideas from general programming:

  • Reference types
  • Object
  • Composition
  • Namespaces
  • Scopes
  • Assetions

These ideas are reviewed in this article. If you program using a language that uses a type system, you’ll already know the content covered in this article and can skip the rest.

Copyright Lyquidity Solutions © 2021 · All Rights Reserved · Strongly typed spreadsheets · Strong Typing