Bug 168498 - Pasting an array formula range as Image may result in an image that contains errors
Summary: Pasting an array formula range as Image may result in an image that contains ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.8.1.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, regression
Depends on:
Blocks: Paste
  Show dependency tree / graph
 
Reported: 2025-09-21 08:53 UTC by nobu
Modified: 2025-11-25 15:52 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 nobu 2025-09-21 08:53:05 UTC 
Description:
Pasting an array formula range as Image may result in an image that contains errors.

Steps to Reproduce:
1. Open a new Calc.
2. Insert 1 and 2 into Cell [A1] and [A2].
3. Insert array formula "{=A1:A2}" into Cell Range [C1:C2]
4. Select Cell Range [B1:C2], and Copy the Range.
5. Select other Cell.
6. Paste Image in GDI-Meta or PNG or BMP using Paste-Dropdown-Icon.

Actual Results:
7. The part corresponding to [C2] of the image will be "#REF!" error.

Expected Results:
7. The part of the image corresponding to [C2] is "2" (same as the value of [A2]).


Reproducible: Always


User Profile Reset: No

Additional Info:

If you select the cell range A1:C2 and paste it as an image, it works well.

Not Reproduced with
Version: 25.2.6.2 (X86_64) / LibreOffice Community
Build ID: 729c5bfe710f5eb71ed3bbde9e06a6065e9c6c5d
CPU threads: 4; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win
Locale: en-US (ja_JP); UI: en-US
Calc: CL threaded

Not Reproduced with
Version: 25.2.5.2 (X86_64) / LibreOffice Community
Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022
CPU threads: 2; OS: Linux 6.1; UI render: default; VCL: gtk3
Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP
Calc: threaded

===

Reproducible with
Version: 25.8.1.1 (X86_64)
Build ID: 54047653041915e595ad4e45cccea684809c77b5
CPU threads: 4; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win
Locale: en-US (ja_JP); UI: en-US
Calc: CL threaded

Reproducible with
Version: 25.8.1.1 (X86_64)
Build ID: 54047653041915e595ad4e45cccea684809c77b5
CPU threads: 2; OS: Linux 6.1; UI render: default; VCL: gtk3
Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP
Calc: threaded

Reproducible with
[2025-09-19]
Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: ed45cdaef3d2807d0b9d6a4c08da375fc72024a6
CPU threads: 2; OS: Linux 6.1; UI render: default; VCL: gtk3
Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP
Calc: threaded
Comment 1 m_a_riosv 2025-09-21 14:13:01 UTC 
Reproducible
Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 9ee57c6ac279cf3ea25f1598de6deab6e2d6735a
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
Comment 2 Saburo 2025-10-10 04:01:50 UTC 
adding CC: Xisco Fauli
please, take a look?

GDI-meta pasting error maybe from ooo
This commit seems to be the first to result in an error value when pasting a PNG.
commit eb99e28a92517cac9534a6a52b9266777f735ce5
author	Xisco Fauli <xiscofauli@libreoffice.org>	Fri Aug 08 13:34:54 2025 +0200
committer	Xisco Fauli <xiscofauli@libreoffice.org>	Fri Aug 08 16:27:45 2025 +0200
tree c87dab908048366a457504e3f4034e41b5db5bff
parent 4862b5efbd6724d01e04b0951188f2a18c9362e8 [diff]

tdf#167075: init doc shell before pasting as png/bmp

***
works fine b4460d983401e0b5962f71159016209e2d74d095
clipboard error d8ab8992bd35aedfc1d2b0debebab0d623aa8d09..1f17dd388d8f66200ca85513e161eb403f6f8667
png white 63597069fbb3209db1b4acd3c3e85b512b5d717c..4862b5efbd6724d01e04b0951188f2a18c9362e8