Bug 167917 - TOCOL/TOROW functions replicate values when there is only one
Summary: TOCOL/TOROW functions replicate values when there is only one
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
26.2.0.0 alpha0+ master
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on: 127808
Blocks: Calc-Function
  Show dependency tree / graph
 
Reported: 2025-08-12 11:00 UTC by Xisco Faulí
Modified: 2025-08-12 18:48 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Attachments
sample file (8.97 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-08-12 11:00 UTC, Xisco Faulí 		Details
View All 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 Xisco Faulí 2025-08-12 11:00:39 UTC 
Created attachment 202297 [details]
sample file

Steps to reproduce:
1. Open attached document
2. Remove B2

-> All cells in TOROW and TOCOL arrays are filled with 1

Reproduced in

Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: a0ae1b0cf2661e7be9ea042e5357530f5fb412f5
CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: gtk3
Locale: es-ES (es_ES.UTF-8); UI: en-US
Calc: threaded
Comment 1 m_a_riosv 2025-08-12 13:43:04 UTC 
Reproducible
Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 7f4868348c14b305fcd75744e1e3544d0d3a5d61
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
Comment 2 Regina Henschel 2025-08-12 14:09:36 UTC 
These functions are designed to be compatible with Excel. Save the document as xlsx, open the xlsx file in Excel. Now delete content of B1 in Excel. The output cell range is filled with 1 in Excel as well. 

Thus for me it is a "wontfix".
Comment 3 Xisco Faulí 2025-08-12 14:53:42 UTC 
(In reply to Regina Henschel from comment #2)
> These functions are designed to be compatible with Excel. Save the document
> as xlsx, open the xlsx file in Excel. Now delete content of B1 in Excel. The
> output cell range is filled with 1 in Excel as well. 
> 
> Thus for me it is a "wontfix".

Yes, that's true, because LibreOffice exports the formulas as array formulas. However, it can't be reproduced in Excel if you insert the formula manually.
I believe the root cause is the lack of support for dynamic arrays at the moment