https://bugs.freedesktop.org/show_bug.cgi?id=86125
--- Comment #7 from jacques <[email protected]> --- I got it again. And I know now how to reproduce it (or how to bypass the bug). Below is : 1. Somethong strange 2. How to reproduce it 3. Related problem 1. I have a spreadsheet that I used since the beginning of 2014. When modifying it with LO 4.2.7.2 I lost the sheet number in the formulas refering to a cell in an other sheet. But if I open it with LO 4.2.6.3 on another computer, either sharing the disk or after a copy, the formulas are messed up but most of the value displayed are good as if the formulas are good. Very strange ! 2. The bug appear when you move a row inside a sheet, or a cell inside a sheet. To reproduce it let's create a new spreadsheet with 2 sheets, - in sheet1 in cell A1 type : A in cell A2 type : =Sheet2.A1 in cell A3 type Y in cell A4 type Z - in sheet2 in cell A1 type : B in cell A2 type : =Sheet1.A1 - and save it. First case : - open this spreadsheet - in sheet 1 move row 3 after row 4 (select row 3 and drag it after row 4 while pressing ALT key) The sheet references in cell A2 of sheet1 and in cell A2 of sheet2 disapeared ! - quit without saving. Second case : - open again this spreadsheet in sheet 2 move the content of cell A2 to cell A3 The sheet references in cell A2 of sheet1 and in cell A3 of sheet 2 also disapeared ! I suggest to modify the title to : libreOffice calc formulas are loosing references when moving row or cell. 3. Related problem ? On a slow computer when I move one or several rows in a more complex sheet (even with LO 4.2.6.3) it is very long and I can see the processor use go up to 89% or more during several seconds. Much more than a normal re-calculating when I modify cell content referred by formulas. I hope all this can help to solve the problem. Let me know quickly if you need additional informations from me since I will fall back soon to the previous LO version. I saw a new entry for the same problem I will mark it duplicate of this one. -- 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
