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
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
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
Reproduced in windows bibisect repos from [win64-25.8] down to [win64-4.3]. I was not able to test earlier versions due to storage constraints, so the earliest version I could confirm as affected is 4.3. This means the issue is possibly in the older versions. I could not identify a proper older build to bibisect. Do want to note the behavior I noticed. It seems the "#REF!" error appears only when pasting with GDI, the other two options were fine for me and displayed the "2". The pasting issue with GDI is still present in Version: 26.8.0.0.alpha0+ (X86_64) Build ID: 8a9e4e8631f8b80d9d7013dbcd7e4fe3693bb2f6 CPU threads: 24; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Vulkan; VCL: win Locale: de-DE (en_US); UI: en-US Calc: CL threaded Repro in bibisect-win64-4.3: Version: 4.3.0.0.beta1+ Build ID: 754160755adb071f432898978c487aec9c87177d