Bug 141436 - EDITING: transposed formula object has "size zero" and is in wrong cell
Summary: EDITING: transposed formula object has "size zero" and is in wrong cell
Status: VERIFIED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.4.2 release
Hardware: All All
: medium normal
Assignee: Regina Henschel
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Paste-Special
  Show dependency tree / graph
 
Reported: 2021-04-01 19:39 UTC by Roland Kurmann
Modified: 2023-05-08 11:59 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
transpose_formula_object.ods (10.44 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-04-01 19:41 UTC, Roland Kurmann 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Roland Kurmann 2021-04-01 19:39:17 UTC 
Description:
A formula object in a cell is not correctly transposed.

Steps to Reproduce:
1. Open attached sheet "transpose_formula_object.ods".
2. Select cells A1 to A3.
3. Copy cells
4. Go to cell A5
5. Menu Edit > Paste Special > Paste Special
6. Click on the Tranpose button.

Actual Results:
It is in the wrong cell, i.e. A5.
The formula object is not recognizable. It seems to have "size zero".


Expected Results:
The formula object is in cell B5 and is a formula object showing "+4".


Reproducible: Always


User Profile Reset: No



Additional Info:
It seems formula objects are not transposed at all.

I've discovered this bug while fixing and testing bug 107348.

Version: 7.0.4.2
Build ID: 00(Build:2)
CPU threads: 4; OS: Linux 5.3; UI render: GL; VCL: kf5
Locale: de-CH (en_US.UTF-8); UI: de-DE
Calc: threaded

Version: 7.2.0.0.alpha0+ / LibreOffice Community
Build ID: 4f7bc49bce261f1cf206d25f0299fd080a9f5d28
CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: x11
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 1 Roland Kurmann 2021-04-01 19:41:41 UTC 
Created attachment 170905 [details]
transpose_formula_object.ods
Comment 2 BogdanB 2021-05-21 18:10:30 UTC 
Confirm with
Version: 7.2.0.0.alpha1+ / LibreOffice Community
Build ID: b238522ca121ca8f863fe4d3394ade088a65ad01
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: en-US (ro_RO.UTF-8); UI: en-US
Calc: threaded
Comment 3 Regina Henschel 2023-05-05 14:07:45 UTC 
I'm working in that area for bug 139083, see https://gerrit.libreoffice.org/c/core/+/150161
The patch contains a larger change in the way objects which are included in a cell range are pasted. It should fix this problem here too.
Comment 4 BogdanB 2023-05-08 05:36:56 UTC 
Regina, you can mark this bug as Resolved also here.
The formula is not distorted anymore.

Verified in
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 4f93995f2262cde0b16bacc83f4ba3c6161ada7f
CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded

Bad in
Version: 7.5.3.2 (X86_64) / LibreOffice Community
Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3
CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded
Comment 5 BogdanB 2023-05-08 11:59:08 UTC 
Verified in
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 4f93995f2262cde0b16bacc83f4ba3c6161ada7f
CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded