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.
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
denis, Can you attach a sample spreadsheet with this issue? Did you try Cor's suggestion?
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.