Bug 166791 - Unable to copy part of array formula result (only full/whole range is possible) (eg. TOCOL())
Summary: Unable to copy part of array formula result (only full/whole range is possibl...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.8.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL: https://help.libreoffice.org/latest/e...
Whiteboard:
Keywords:
Depends on: 127808
Blocks:
  Show dependency tree / graph
 
Reported: 2025-05-30 11:22 UTC by Piotr Osada
Modified: 2025-05-30 16:40 UTC (History)
3 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 Piotr Osada 2025-05-30 11:22:41 UTC 
E.g. values in A1:B3

a1    b1
a2    b2
a3    b3

1) E1=TOCOL(A1:B3)
2) Enter (TOCOL() RESULT IS IN E1:E6)
3) Select part of TOCOL() result: e.g. E1:E4


Result:
Context menu is incomplete.
Among other things, the copy function is missing.


Reset profile: yes

Is the same in safe mode: yes



Version: 25.8.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 17e8dbead42e2d4b55815b1b7b2846b03d62a15d
CPU threads: 8; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win
Locale: pl-PL (pl_PL); UI: en-US
Calc: CL threaded

https://dev-builds.libreoffice.org/daily/master/Win-x86_64@tb77-TDF/2025-05-29_03.57.09/
Comment 1 Xisco Faulí 2025-05-30 12:27:03 UTC 
This is not specific to the TOCOL function but to all array functions.
At the moment copying part of the array is disabled and only the whole array can be copied.
I guess this should be fixed once dynamic arrays are supported
Comment 2 m_a_riosv 2025-05-30 16:40:15 UTC 
tdf#164461

But at the moment looks more as an enhancement than a bug.