> -----Original Message----- > From: Andreas Säger [mailto:saege...@t-online.de] > Sent: Sunday, December 13, 2015 13:15 > To: dev@openoffice.apache.org > Subject: Re: Calc Selections of Entire Rows and Columns > > 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. [orcmid] Thanks Andreas,
Do you recommend the A:A unchanging behavior or the A$1:A$1048576 shrinking behavior? Do folks depend on the shrinking behavior of the idiom? Won't the unchanging A:A type of behavior be more complicated to achieve? It means having true full column and full row recognized and displayed, including input of the idiom form files, but using the idiom on output of ODF 1.2 open formulas to preserve interoperability with older implementations. PS: I notice if I insert rows, the range doesn't change. Only if I delete rows does the range shrink. So if I add rows and then take them out, the range decreases. Not exactly marvelous. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org > For additional commands, e-mail: dev-h...@openoffice.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
