Apache OpenOffice Community Forum

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.

Edit: Changed subject, was Drag & Drop Cells  Make your post understandable by others  -- MrProgrammer, forum moderator

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.

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.

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).

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
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.

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.

There is a much bigger upgrade availlable: https://www.libreoffice.org/discover/li ... penoffice/

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.

dacha wrote: ↑Tue Mar 14, 2023 6:36 pm 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.

THANK YOU!

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

cwolan wrote: ↑Tue Apr 11, 2023 6:32 pm 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.

Thanks! I can wait for the official release.