Bug 84540

Summary:	EDITING: adding/removing/sorting out rows will not update formulas in Calc spreadsheet
Product:	LibreOffice	Reporter:	denisgermain
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	cno, gustavo.lima
Priority:	medium
Version:	4.3.1.2 release
Hardware:	x86-64 (AMD64)
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	File with the spreadsheet error

Description denisgermain 2014-10-01 03:27:19 UTC

Occurring since this spring (can't remember version, so entering latest I have on the mac)

Occurred this spring on Fedora 19 too, I have not tested lately. The bug is on OS X 10.6.8 for months too.

When I add or remove rows for adding values, or sort out rows, in a simple spreadsheet with only a few sums after, the formulas don't update to the new subsequent cell names, generating wrong sums or errors.

Occurs with formulas like =sum(A:B) =sum(A;B)
Sums using =A+B+… seem to be immune though I can't be definitive.
(letters are cells ID)

Work around for now : never adding rows in the middle of others, always at the end of the ones with data, and never sort rows.

Comment 1 Cor Nouws 2014-10-01 08:21:35 UTC

Hi Dennis,


Thanks for your report. However it works for me: There is a setting for this.. Tools > Options > Calc > General .. Extend references when columns/rows are added (or something similar)

So for now I close as WORKSFORME. Might there turn out to be a problem in some specific details, then pls reopen with those details. 

Kind regards
Cor

Comment 2 Luke 2014-10-08 05:19:23 UTC

denis,
Can you attach a sample spreadsheet with this issue? Did you try Cor's suggestion?

Comment 3 Gustavo Perdigão Meneses Lima 2014-10-20 19:36:46 UTC

Created attachment 108131 [details]
File with the spreadsheet error

This file does exactly the problem described at the original report. If you add or remove cells the value at B16 changes 17,000 that is a value used in an old row removed from the first version of the spreadsheet.