Apache OpenOffice (AOO) Bugzilla – Issue 128566
cell displacement problem
Last modified: 2023-04-11 09:14:32 UTC
Created attachment 87176 [details] Example of bug Good morning, I allow myself to write to report what I think is a bug on OpenOffice Calc V4.1.14 observed on March 14, 2023. (sorry, I don't know which item to choose in the "component" section) I believe there is an issue regarding "moving cell(s)" and dynamic tracking of related formulas. On the simple example attached, we can notice that the sum in B1 is no longer exact if: - we move B1 - we move the group A1:A10 Works well with V4.1.13 Best regards, Olivier D
Please provide more info. By "move", do you mean cut and paste? Where do you move B1? Where do you move A1:A10?
Example Cell A1 with value 1 Cell B1 with formula =A1 Select A1 and drag it somewhere e.g. to A4 Result: - in 4.1.13 cell B1 show 1 (formula changed to =A4) - in 4.1.14 cell B1 shows 0 (formula =A1) I presume a similar problem was raised on the English forum. topic "OpenOffice 4.1.14: Drag & Drop fails to preserve formulas" https://forum.openoffice.org/en/forum/viewtopic.php?p=535842&sid=4997e66fa1c6787808007a6b09285670#p535842
(In reply to damjan from comment #1) > Please provide more info. > > By "move", do you mean cut and paste? > -(ctrl Maj and move) or (multiple selection cells) > Where do you move B1? - B5, for example > > Where do you move A1:A10? - D1:D10 for example
(In reply to Czesław Wolański from comment #2) > Example > > Cell A1 with value 1 > Cell B1 with formula =A1 > > Select A1 and drag it somewhere e.g. to A4 > > Result: > - in 4.1.13 cell B1 show 1 (formula changed to =A4) > - in 4.1.14 cell B1 shows 0 (formula =A1) > > I presume a similar problem was raised on the English forum. > topic "OpenOffice 4.1.14: Drag & Drop fails to preserve formulas" > > https://forum.openoffice.org/en/forum/viewtopic. > php?p=535842&sid=4997e66fa1c6787808007a6b09285670#p535842 Hello, yes, it's exactly this problem Olivier D
Confirming and marking as a regression. This could be a result of the fix for bug 118023, where cutting and pasting between different documents updates cell references on the wrong document. I never tested drag-moving when fixing that bug. Maybe drag-moving cells supplies different document references, so references do not get updated even though they should be, resulting in this bug?
I think we have to allow: pCBFCP->pClipDoc->GetClipParam().getSourceDocID() == 0 instead of only: pCBFCP->pClipDoc->GetClipParam().getSourceDocID() == GetDocumentID() presumably because when you drag cells, the clipboard source document isn't set. With that change, dragged cells do preserve formulas, while bug 112023 does not recur. Issue is thus fixed with commit 3accd9b1ca87d0b4656a691efa455d8f0a24bdc9. Resolving fixed.
Cherry-picked for AOO41X with: https://github.com/apache/openoffice/commit/90c740b5bc3772cd09423718c8d572588e4187c2
Cherry-picked for AOO42X with: https://github.com/apache/openoffice/commit/da1c051b9b2cdc4ed9487c3658fa0f9c052ccabb