Bug 146972 - Paste values only & transpose fails when values come from an array formula EDITING
Summary: Paste values only & transpose fails when values come from an array formula ED...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.5.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 148500 (view as bug list)
Depends on:
Blocks:
 
Reported: 2022-01-24 17:30 UTC by David Lynch
Modified: 2025-03-06 12:50 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
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 David Lynch 2022-01-24 17:30:46 UTC 
Description:
Paste values only & transpose fails when values come from an array formula

Steps to Reproduce:
1. enter an array formula in A1 eg ={ROW(A1:A4)}
2. Select A1:A4
3. Copy
4. Select C1
5. [insert] then click Transpose and click Values only then [OK]


Actual Results:
C1=1
C2=2
C3=3
C4=4

Expected Results:
C1=1
D1=2
E1=3
F1=4


Reproducible: Always


User Profile Reset: Yes



Additional Info:

Version: 7.2.5.2 (x64) / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded
Comment 1 m_a_riosv 2022-01-25 15:36:59 UTC 
As I know you cannot do it with part of an array, it happens also with a simple copy-paste. When trying to copy part of an array, nothing is copied.
Comment 2 m_a_riosv 2022-04-10 20:02:39 UTC 
*** Bug 148500 has been marked as a duplicate of this bug. ***
Comment 3 Xisco Faulí 2025-03-04 11:28:04 UTC 
Hello,
It's been a while since this issue was reported.
Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Comment 4 Colin 2025-03-04 12:16:47 UTC 
Version: 7.5.9.2 (x86) / LibreOffice Community
Build ID: cdeefe45c17511d326101eed8008ac4092f278a9
CPU threads: 12; OS: Windows 10.0 Build 26100; UI render: Skia/Vulkan; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded

Can't test with anything beyond this because everything subsequent breaks my files.

I await a resolution to bug145995 & bug160018
Before anything meaningful can be undertaken
Comment 5 David Lynch 2025-03-06 12:50:38 UTC 
Confirm bug still exists, behaviour as above.

Version: 25.2.0.3 (X86_64) / LibreOffice Community
Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069
CPU threads: 12; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: CL threaded