Bug 141436

Summary: EDITING: transposed formula object has "size zero" and is in wrong cell
Product: LibreOffice Reporter: Roland Kurmann <info>
Component: CalcAssignee: Regina Henschel <rb.henschel>
Status: VERIFIED FIXED    
Severity: normal CC: buzea.bogdan, info, rb.henschel
Priority: medium    
Version: 7.0.4.2 release   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=107348
https://bugs.documentfoundation.org/show_bug.cgi?id=141437
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108479    
Attachments: transpose_formula_object.ods

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