|Title||Visual checking of spreadsheets|
|Authors||Chen Ying & Hock Chuan Chan|
The difference between surface and deep structures of a spreadsheet is a major cause of difficulty in checking spreadsheets.
After a brief survey of current methods of checking (or debugging) spreadsheets, new visual methods of showing the deep structures are presented.
Illustrations are given on how these visual methods can be employed in various interactive local and global debugging strategies.
The main difficulty that users have in understanding spreadsheets is the difficulty of establishing cell connections - how each cell depends on other cells. These connections form a structure. The usual tabular layouts for texts and numbers do not show the actual connections. They may even suggest a wrong structure.
The two types of cell structure are:
It is difficult to understand a spreadsheet when the two structures in the spreadsheet are very inconsistent.