May
19
0

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.

This article will review relevant ideas from general programming that should also apply to a type system for Excel. If you program using a language that uses a type system, you’ll probably have a good idea of the likely topics.

May
19
0

Types in Excel

A type system for Excel needs to emulate some of the features found in languages which support a robust code validation system. The obvious differences between Excel and a formal programming language mean these validation features need to be adapted to work in Excel. For example, in a language based on a list of statements in a text file scopes are defined by the use of start/end delimiter pairs such as ‘{‘ and ‘}’ while Excel is grid of values with no natural scope. A scope might be a column or row of cells but it might be a collection of one or more cell ranges. This article will review the required features and how they can be used in Excel.

May
19
0

What is a Rule?

This article reviews the purpose of a Rule

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