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: 2022-04-10 20:02 UTC (History)
2 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. ***