Am 13.12.2015 um 17:12 schrieb Dennis E. Hamilton: > The TL;DR: For full row and column selections in formulas, the trick is to > arrange to accept something like A:A and to recognize the explicit OO.o idiom > (i.e., A$1:A$1048576) and show it as A:A. The trick is to always write, in > the OpenFormula, A$1:A$1048576, regardless of the form it was read/input, and > always display as A:A in the presented formula. That is, always write the > idiom but recognize both it and the general form (and all variations of > course) as the general form. >
There is a difference between A:A and A$1:A$1048576 in Excel and Gnumeric: When you delete rows, A:A remains A:A whereas A$1:A$1048576 shrinks. Any reference to the last cell A$1048576 moves up but any A:A reference remains the same regardless how many and how often you delete cells. In the age of spreadsheet databases this may be a problem when you count on this behaviour. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
