Bug 77151

Summary:	calc 4.2.2.1: row() value is not updated if row is inserted before
Product:	LibreOffice	Reporter:	Liselore Vermeulen <liselorev+freedesktop>
Component:	LibreOffice	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	olivier.desmares
Priority:	medium
Version:	4.2.2.1 release
Hardware:	Other
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

Description Liselore Vermeulen 2014-04-07 18:05:54 UTC

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).

Comment 1 Dominique Boutry 2014-04-08 08:04:07 UTC

Reproduced (same LibO version on Win7). Set to NEW

Due to some excessive caching policy?

Comment 2 ign_christian 2014-09-15 17:00:41 UTC

Not reproducible with LO 4.2.6.3 under Ubuntu 12.04 x86. Seems to be fixed