Bug 164461 - The paste icon drop-down does not work when Top-Left Cell in the copy range is an array formula
Summary: The paste icon drop-down does not work when Top-Left Cell in the copy range i...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-12-26 00:25 UTC by nobu
Modified: 2025-05-01 08:37 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description nobu 2024-12-26 00:25:47 UTC
Description:
The paste icon drop-down does not work when the first cell in the copy range is an array formula.

Steps to Reproduce:
1. Open new Calc.
2. Insert array formula "=ROW(1:3) * COLUMN(A:B)" in Cell [B2],
   and Key [ Ctrl + Shift + Enter ].
3. Select Range [ B2:C4 ], and Copy [ Ctrl + c ].
   The important thing here is that the upper-left cell of the range is [ B2 ],
   and you want to copy the range that is equal to or larger than the size of the matrix.
4. Move the cursor somewhere.
5. Paste using PasteDropdownIcon.
   For example, to paste it as an image

Actual Results:
6. downward triangle Nothing happens when you press [▼].
   Normal pasting can be done by pressing the icon part, but special pasting cannot be done.

Expected Results:
6. A drop-down will appear, allowing you to do various pastes.


Reproducible: Always


User Profile Reset: No

Additional Info:
If you copy ranges such as [A2:C4] or [B1:C4], they work correctly.

---
Reproducible with
Version: 7.3.7.2 (x64) / LibreOffice Community
Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: threaded

Reproducible with
Version: 24.2.3.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 2; OS: Linux 6.8; UI render: default; VCL: qt5 (cairo+xcb)
Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP
Ubuntu package version: 4:24.2.3-0ubuntu0.24.04.2
Calc: threaded

Reproducible with
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 141f3fd15633803afa720837405a0bacbc2726cb
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Vulkan; VCL: win
Locale: en-US (ja_JP); UI: en-US
Calc: CL threaded
Comment 1 Charles Williams 2024-12-26 12:35:41 UTC
Bug does not manifest on macOS using this LO version:

Version: 24.8.4.2 (AARCH64) / LibreOffice Community
Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002
CPU threads: 8; OS: macOS 15.2; UI render: default; VCL: osx
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded

(Need to replace 'ctl' with 'cmd' when copying, of course.)
Comment 2 BogdanB 2025-01-08 05:59:11 UTC
Nobu, please don't create bugs with New status, someone else has to confirm before getting a New status.
Comment 3 nobu 2025-01-11 06:52:08 UTC
Reproducible with

Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: c9ae567c791bcffdc3fff9e3fb11b46275a13d2b
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: CL threaded
Comment 4 nobu 2025-02-16 00:38:39 UTC
Reproducible with

Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: b4059c4b9ae2230d9c6d722d457dca2216ddd581
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: CL threaded
Comment 5 nobu 2025-04-24 10:16:21 UTC
Reproducible with

Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 722073473b6d8e8553f501ff1d4a68d4dc21f866
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: CL threaded
Comment 6 Mateusz Wlazłowski 2025-04-30 19:54:52 UTC
I did not understand step 5
Comment 7 nobu 2025-04-30 23:47:22 UTC
(In reply to Mateusz Wlazłowski from comment #6)
> I did not understand step 5

5. Paste using Drop-down to the right of the paste icon in the toolbar
   For example, to paste it as an image

Japanese
ツールバー内の貼り付けアイコンの右にあるドロップダウン

Automatic translation ( by TexTra )
Drop-down to the right of the paste icon in the toolbar

---
The report below is from the same button as this time.

Pasting Selected Range to Sheet as BMP or PNG Image, Size is larger
https://bugs.documentfoundation.org/show_bug.cgi?id=163907

Pasting Array formula used ROW or COLUMN function as GDI-Image results in an error-displayed image
https://bugs.documentfoundation.org/show_bug.cgi?id=160023

Pasting Selected Range to Sheet as GDI Image, Chart image is incorrect.
https://bugs.documentfoundation.org/show_bug.cgi?id=153706
Comment 8 nobu 2025-04-30 23:49:39 UTC
I will correct it a little.

5. Paste using Drop-down to the right of the paste icon in the toolbar.
   For example, to paste it as an image.
Comment 9 Mateusz Wlazłowski 2025-05-01 08:37:26 UTC
Confirm on both Linux and Windows


Here are my steps :
1- open a new calc
2- 2. Insert array formula "=ROW(1:3) * COLUMN(A:B)" in Cell [B2] in the input line, and press [ Ctrl + Shift + Enter ]. A matrix should appear
3- Click on cell B6. Notice the arrow next to the Paste icon is no longer present 
4- Input "d" in B6. Enter. The arrow will reappear 
5- Select Range [ B2:C4 ], and Copy [ Ctrl + c ].
6- Click on E7
7- Click on the arrow next to the paste icon in the toolbar. Nothing happens


Version: 7.2.0.1 / LibreOffice Community
Build ID: 32efc3b7f3a71cfa6a7fa3f6c208333df48656cc
CPU threads: 8; OS: Linux 6.11; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

Version: 25.2.2.2 (X86_64) / LibreOffice Community
Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac
CPU threads: 2; OS: Windows 11 X86_64 (10.0 build 22621); UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded