https://bugs.documentfoundation.org/show_bug.cgi?id=92779
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW Hardware|Other |All Ever confirmed|0 |1 Severity|normal |enhancement --- Comment #3 from Eike Rathke <[email protected]> --- (In reply to Óvári from comment #0) > Example E (bug appears) > 1. Open LibreOffice (LO) Calc > 2. In cell A2 enter: =SUM(B1:B1048575) > 3. Right click on row heading 4 > 4. Select 'Insert Rows Above' > 5. Cell A2 incorrectly shows: =SUM(B1:B1048576) > Cell A2 should show: =SUM(B:B) {As shown in Example A, step 5} Note that this is different, example A has both absolute row references. References that result from inserting/deleting/shifting/moving and have not both anchors absolute are not displayed as entire col/row references. For user convenience, only when entering an expression and both anchors are relative it is taken as entire col/row reference, because that is what you also get when selecting a range with Shift+Ctrl+Down for example. > 6. Repeat steps 3-5 and LO Calc correctly shows formula in A2 as: > =SUM(B1:B#REF!) > Example F (bug appears) > 1. Open LibreOffice (LO) Calc > 2. In cell A2 enter: =SUM(B1:B$1048575) > 3. Right click on row heading 4 > 4. Select 'Insert Rows Above' > 5. Cell A2 incorrectly shows: =SUM(B1:B$1048576) > Cell A2 should show: =SUM(B:B) {As shown in Example A, step 5} Mixed anchors, one relative one absolute. This will never yield an entire col/row reference. On purpose, because when copy&paste such reference the absolute part is sticky and the relative parts gets adjusted relatively to the new position. > 6. Repeat steps 3-5 and LO Calc correctly shows formula in A2 as: > =SUM(B1:B$#REF!) > > Example G (bug appears) > 1. Open LibreOffice (LO) Calc > 2. In cell A2 enter: =SUM(B$1:B1048575) > 3. Right click on row heading 4 > 4. Select 'Insert Rows Above' > 5. Cell A2 incorrectly shows: =SUM(B$1:B1048576) > Cell A2 should show: =SUM(B:B) {As shown in Example A, step 5} Again the same, mixed anchors. > 6. Repeat steps 3-5 and LO Calc correctly shows formula in A2 as: > =SUM(B$1:B#REF!) It is debatable what actually should happen with references that were not entire col/row but only become when inserting rows/cols. Excel is a bit more lax there and if both anchors are either absolute or relative, the reference is displayed as entire col/row reference. Not with mixed anchors. Also if inserting rows results in an entire column that the reference wasn't before, even if not displayed as A:A/1:1 because of mixed anchors, the reference anchors become sticky, regardless of relative or absolute addressing, and are not shifted when deleting rows or when inserting further rows. However, copy&paste =SUM(B$1:B1048576) one row further down still results in #REF! Maybe we could implement similar behaviour. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
