Structuring Spreadsheets with the “Lish” Data Model

摘要: A spreadsheet is remarkably flexible in representing various forms of structured data, but the individual cells have no knowledge larger structures which they may form a part. This can hamper comprehension and increase formula replication, increasing risk error on both scores. We explore novel data model (called “lish”) that could an alternative to traditional grid spreadsheet-like environment. Its aim capture some these higher while preserving simplicity makes so attractive. It based organised into nested lists, each user optionally employ template prototype repeating structures. These elements be likened marginal “cells” borders worksheet, are proper members sheet themselves contain internal structure. small demonstration application shows “lish” operation.