Bug 86009

Summary:	Pressing Ctrl+Z doesn’t trigger formula update
Product:	LibreOffice	Reporter:	nokotoa
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	high	CC:	acdrferreira, esigra, fitojb
Version:	4.3.2.2 release
Hardware:	All
OS:	All
See Also:	https://bugs.freedesktop.org/show_bug.cgi?id=86708
Whiteboard:
i915 platform:		i915 features:
Attachments:	file with bug, is not recalculated with F9

Description nokotoa 2014-11-07 15:41:38 UTC

Bad Recalculation


If you do the following

in cell b2 insert a 1
in cell c2 insert a 2
in cell d2 insert a 3
in cell e5 insert formula =SUM(B2:D2)
cell e5 shows a 6 (That is OK)

Then:
 move to cell c2
 delete cell

cell e5 shows a 4 (That is OK)

Then: 
 undo

cell e5 keeps showing a 4 (IT IS A BUG, e5 should be showing a 6)

Comment 1 nokotoa 2014-11-07 15:43:51 UTC

Version is Version: 4.3.3.2
Build ID: 9bb7eadab57b6755b1265afa86e04bf45fbfc644

Comment 2 Alberto Ferreira 2014-11-07 16:04:35 UTC

Helo,

I have tried to simulate the Bad Recalculation with Libreoffice 4.3.3.2 on Windows and all calculation are correct.

Check again.

Comment 3 Adolfo Jayme 2014-11-08 15:57:01 UTC

I can confirm this behavior if I trigger Undo by pressing Ctrl+Z.
If I click the Undo toolbar item instead, the bug is not reproducible.

Tested with LibreOffice Calc 4.3.3.2 under Ubuntu.

Comment 4 Renato Ferreira 2014-12-01 00:33:08 UTC

I cannot reproduce the bug in master build 4.5.0.0.alpha0+.
Maybe it is already fixed?

Comment 5 Adolfo Jayme 2014-12-01 11:56:09 UTC

(In reply to Renato Ferreira from comment #4)
> I cannot reproduce the bug in master build 4.5.0.0.alpha0+.
> Maybe it is already fixed?

Perhaps this was fixed by http://cgit.freedesktop.org/libreoffice/core/commit/?id=5cec4ea827570a5bb0a368025f3733b841107d07, which will be in 4.2.8, 4.3.6 and 4.4.

Comment 6 sirocco 2014-12-15 05:06:20 UTC

Created attachment 110841 [details]
file with bug, is not recalculated with F9

Comment 7 sirocco 2014-12-15 05:07:38 UTC

Comment on attachment 110841 [details]
file with bug, is not recalculated with F9

tested with Libreoffice 4.2.8.2

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.