https://bugs.documentfoundation.org/show_bug.cgi?id=166216
BogdanB <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] Resolution|WORKSFORME |FIXED --- Comment #2 from BogdanB <[email protected]> --- Fixed by commit ba2b98774c6b5c23eb8747bb1919d3f034ab3896 Author: Ujjawal Kumar <[email protected]> Date: Tue Apr 7 00:10:31 2026 +0530 sc: trim full-column refs to data area in ConvertMatrixParameters Bug document: forum-mso-en4-134670.xlsx Formulas like SUM(SIGN(FREQUENCY(IFERROR(IF($A:$A=val, MATCH($B:$B,$B:$B,0)))))) with full-column references create matrices with 1M+ elements when evaluated in forced-array context. This produces a JumpMatrix with 1M positions, causing thousands of MATCH evaluations and making the document effectively unable to load. The existing AnnotateTrimOnDoubleRefs optimization only trims full-column refs for simple SUM(IF(...)) patterns and does not recognize intermediate functions like SIGN, FREQUENCY, IFERROR between SUM and IF. Shrink the range end of full-column and full-row DoubleRef references to the sheet's data area in ConvertMatrixParameters, before they are converted to matrices. The start position is preserved for correct index semantics. Only Value parameters are trimmed to avoid changing the size of ForceArray/Array parameters used by paired-array functions like CORREL across different sheets. Change-Id: I005d4cea8038ea27748d2573ba9b02a39c880bdc Reviewed-on: https://gerrit.collaboraoffice.com/c/core/+/551 Tested-by: Jenkins CPCI <[email protected]> Reviewed-by: Noel Grandin <[email protected]> (cherry picked from commit dffe1eaddf701d053bd247a1af217a3282e86b00) Reviewed-on: https://gerrit.libreoffice.org/c/core/+/204675 Tested-by: Jenkins Reviewed-by: Xisco Fauli <[email protected]> -- You are receiving this mail because: You are the assignee for the bug.
