https://bugs.freedesktop.org/show_bug.cgi?id=83901
Priority: medium
Bug ID: 83901
Assignee: [email protected]
Summary: ROW() value is not updated if row is inserted after
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.3.1.2 release
Component: Spreadsheet
Product: LibreOffice
This bug is not a duplicate of 77151 although it may be related in some way.
To reproduce:
- Open a new spreadsheet
- A2 = ROW(A3)
- Insert a row between rows 2 and 3 by right-clicking on row 3 and choosing
"insert rows above".
- Result: cell A2 still shows "3" as its value, although it should show "4".
Note however that the formula inside A2 is correct (it has become "=ROW(A4)").
Also, if you insert a row above row 2, the visual value is the right one.
The issue appears only when inserting a row BELOW the cell containing the
formula.
The issue doesn't appear at all when =COLUMN() is used.
Reproduced at least on: 4.2.5, 4.2.6, 4.3.0, 4.3.1
Not present in 4.1.x (works as expected)
--
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
