[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [office-collab] CT and Spreadsheet tables
Michael Brauer <michael.brauer@oracle.com> 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
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]