https://bugs.freedesktop.org/show_bug.cgi?id=77151
Priority: medium
Bug ID: 77151
Assignee: [email protected]
Summary: calc 4.2.2.1: row() value is not updated if row is
inserted before
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.2.2.1 release
Component: Libreoffice
Product: LibreOffice
Reproduce:
open new calc project,
A2=row($B2)
copy A2 to A3..A10
insert row between row 1 and 2 by right-clicking on line 2 and choosing "insert
rows above"
Result:
cell A2 becomes A3, having (correctly) formula row($B3) and correct value 3
but new cell A4..A11 now have correct formula (row($B4)..row($B11) however
their value remains the same value as before the insertion.
Recalculate (using F9/Tools-Cell Contents-Recalculate) won't produce correct
result
F2 (to edit), nothing changing and [Enter] won't help.
Editing the formula (F2 + removing and adding last parenthesis again + [Enter])
causes a correct recalculation.
This was no problem in "some" previous version (might have been 4.0 or 4.1,
don't remember, I upgraded to 4.2.2 d.d. 2014-03-24).
--
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
