Page 1 of 1
[Issue] OpenOffice 4.1.14: Drag & Drop fails to preserve formulas
Posted: Fri Mar 10, 2023 8:07 pm
by tom526
Been using OpenOffice Calc for years.
And as far as I can remember, when you drag and drop to move cells, it preserves the formulas.
I just upgraded to 4.1.14 and now the formulas change. The cell coordinates change relative to how much you moved it.
Example:
Original:
1
2
=A2+A1
=A2*A1
If I move ONLY the formula cells with drag & drop:
1
2
=A3+A2
=A3*A2
It never used to do this.
Is this a bug? Or is there a setting?
To compare, this is what happens with Cut & Paste:
1
2
=A2+A1
=A2*A1
Would appreciate any assistance. This is vital component to my workflow.
Re: Drag & Drop Cells
Posted: Fri Mar 10, 2023 8:42 pm
by MrProgrammer
tom526 wrote: ↑Fri Mar 10, 2023 8:07 pm
And as far as I can remember, when you drag and drop to move cells, it preserves the formulas. I just upgraded to 4.1.14 and now the formulas change. The cell coordinates change relative to how much you moved it.
[Tutorial] Formula Adjustments during Copy and Move
You should specify your operating system
and precisely what steps you take when you "drag and drop". On MacOS, I can get both behaviours, depending on how I do the operation.
Re: Drag & Drop Cells
Posted: Fri Mar 10, 2023 9:17 pm
by tom526
I'm on Windows 10(Version 10.0.19045 Build 19045)
BTW, I downgraded to 4.1.13 and it's functioning as I expect.
Basically, I highlight the cells I want to move. Click and hold left mouse button. Move the highlighted cells to where I want them. Release left mouse button.
Re: Drag & Drop Cells
Posted: Sat Mar 11, 2023 12:41 am
by Hagar Delest
You should add a signature to your profile:
How to update your software information signature.
You can report it:
[Tutorial] Reporting bugs or suggestions.
Else, you can try LibreOffice, it may not have this kind of regression (works fine with 7.4.2.3).
Re: Drag & Drop fails to preserve formulas in cells
Posted: Sat Mar 11, 2023 3:41 am
by MrProgrammer
tom526 wrote: ↑Fri Mar 10, 2023 9:17 pm
I'm on Windows 10(Version 10.0.19045 Build 19045)
I've updated your forum signature for you.
tom526 wrote: ↑Fri Mar 10, 2023 9:17 pm
Basically, I highlight the cells I want to move. Click and hold left mouse button. Move the highlighted cells to where I want them. Release left mouse button.
Set A1 to 5. Set A2 to 7.
Set A3 to
=A1+A2. Set A4 to
=A1*A2.
Set B3 to
=A3. Set B4 to
=A4.
Select A3 and A4. Drag to A7 and A8. Drop.
On MacOS, I find these results:
• AOO 4.1.13:
A3 and A4 are empty. The behavior is like
Cut and Paste.
B3 is
=A7. B4 is
=A8. The behavior is like
Cut and Paste.
A7 is
=A1+A2. A8 is
=A1*A2. The behavior is like
Cut and Paste.
• AOO 4.1.14:
A3 and A4 are empty. The behavior is like
Cut and Paste.
B3 is
=A7. B4 is
=A8. The behavior is like
Cut and Paste.
A7 is
=A5+A6. A8 is
=A5*A6. The behavior is like
Copy and Paste. Oops!
Surely the behavior in 4.1.14 is not what is intended. This seems to be a defect
only in version 4.1.14. As far as I can tell, this issue has not been reported in
Bugzilla. The problem seems to affect both MacOS and Windows, thus perhaps Linux too.
Workarounds:
• Use
Cut and Paste instead of Drag and Drop until a fix for 4.1.14 is available
•
Download and install 4.1.13

- AOO4.1.13.gif (33.52 KiB) Viewed 2218 times
Set A1 to 5. Set A2 to 7.
Set A3 to
=A1+A2. Set A4 to
=A1*A2.
Set B3 to
=A3. Set B4 to
=A4.
Select A3 and A4. Drag to A7 and A8.
Drop
while holding the ⌥key (marked
option) works as expected in 4.1.14 if the intent is to perform a copy instead of a move. The ⌥ key on a Mac is similar to the Alt key on other platforms.
On MacOS, I find these results:
• AOO 4.1.13:
A3 is
=A1+A2. A4 is
=A1*A2. The behavior is like
Copy and Paste.
B3 is
=A3. B4 is
=A4. The behavior is like
Copy and Paste.
A7 is
=A5+A6. A8 is
=A5*A6. The behavior is like
Copy and Paste.
• AOO 4.1.14:
A3 is
=A1+A2. A4 is
=A1*A2. The behavior is like
Copy and Paste.
B3 is
=A3. B4 is
=A4. The behavior is like
Copy and Paste.
A7 is
=A5+A6. A8 is
=A5*A6. The behavior is like
Copy and Paste.
All are as expected.
Re: OpenOffice 4.1.14: Drag & Drop fails to preserve formulas
Posted: Sun Mar 12, 2023 3:52 pm
by tom526
Thank you!
Looks like I will have to wait for the next version and hope it’s fixed.
I’ll stay on 4.1.13 for now.
Re: OpenOffice 4.1.14: Drag & Drop fails to preserve formulas
Posted: Sun Mar 12, 2023 9:18 pm
by Villeroy
Re: OpenOffice 4.1.14: Drag & Drop fails to preserve formulas
Posted: Tue Mar 14, 2023 6:36 pm
by dacha
This has been reported in Bugzilla now:
https://bz.apache.org/ooo/show_bug.cgi?id=128566
I will investigate and hope to have a fix soon.
Re: OpenOffice 4.1.14: Drag & Drop fails to preserve formulas
Posted: Tue Mar 14, 2023 6:42 pm
by tom526
Re: [Issue] OpenOffice 4.1.14: Drag & Drop fails to preserve formulas
Posted: Tue Apr 11, 2023 6:32 pm
by cwolan
For those interested:
A build of OpenOffice that should resolve the issue is available at the following address.
http://home.apache.org/~mseidel/AOO-bui ... tallation/
For English [US] or en-US, please download
this file and check for yourself.
Don't forget
the build is for testing purposes only.
Edit:
updated link for en-US file |
Re: [Issue] OpenOffice 4.1.14: Drag & Drop fails to preserve formulas
Posted: Tue Apr 11, 2023 8:46 pm
by tom526
Thanks! I can wait for the official release.