LisaCalc: Management Techniques

There are some techniques for managing the size of a spreadsheet:

1. Plan Ahead. You can enter the information more easily and, since making
changes tends to increase the size of the sheet, planned entries will save
you memory.

2. Structure the information to make the row and column lengths fairly even;
avoid stretching your spreadsheet too oblong either way. LisaCalc keeps
track of all the cells in the grid. Incidentally, this accounts for the
printing of blank pages on occasion; since Lisa prints every cell in the
grid, even you haven't used them, the blank cells force a page feed.

3. Use Paste Adjusted formulas; unlike regular pasted or entered formulas,
they don't take up as much accounting space on a pointer table. However,
there are a few things to keep in mind when using Paste Adjust. First, it
works best on long formulas pasted into large ranges; Paste Adjusting a
small formula to a few cells won't save you any space. Second, LisaCalc,
in the process of readjusting formulas, replaces the pointers in the
spreadsheet with real formulas. Bigger than the pointer they replace,
these Paste Adjusted formulas increase the size of your sheet once you
start copying, cutting, pasting, and inserting rows or columns. The
reason for this is that the adjusted cells contain a pointer to the
original formula with an increment. Plan ahead!
Published Date: Feb 18, 2012