Michael Brauer <> wrote on 04/08/2011 01:54:33
AM:
>
> If you insert a row or column into a speadsheet, office applications
> update the formulas in the cells so that they still refer to the
> original ones. For instance, if you have a formula referencing B1
> and insert a column as first column, then that reference becomes C1
> because columns B becomes column C. In the worst case, all formulas
> are adapted.
>
> But maybe this could also be resolved by omitting the formulas in
> the recalculated cells.
>
Another solution would be for ODF to allow the use of R1C1 cell address
notation. That is out of scope for this SC, but if the TC adopted R1C1
notation, then insertions like this would leave most cell addresses
unchanged.
See: http://smurfonspreadsheets.wordpress.com/2007/11/12/r1c1-notation/
This might be a general topic for ODF 1.3 -- are there things we can do to
enable more efficient storage of large tables, especially now that we see
million-row spreadsheet documents.
-Rob
