This is an automated email from the ASF dual-hosted git repository. jimjag pushed a commit to branch openformula in repository https://gitbox.apache.org/repos/asf/openoffice.git
commit 85d609f1a08ea1cfd7f3965c9b9eb755df06723e Author: Jim Jagielski <[email protected]> AuthorDate: Fri Nov 13 09:40:30 2026 -0500 odf_docs: note that IFNA now handles array arguments --- odf_docs/openformula-milestone-b-report.md | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/odf_docs/openformula-milestone-b-report.md b/odf_docs/openformula-milestone-b-report.md index 992929cce9..f5ab05643e 100644 --- a/odf_docs/openformula-milestone-b-report.md +++ b/odf_docs/openformula-milestone-b-report.md @@ -167,6 +167,11 @@ At runtime, `ScInterpreter::ScIfna()` (`interpr1.cxx:324`): ### Documented limitation: matrix handling +**Update:** a matrix argument is now substituted per element through a jump matrix, so +`{=IFNA(A1:A3;0)}` and `{=SUM(IFNA(A1:A3;0))}` work. A plain range outside an array +formula, e.g. `SUMPRODUCT(IFNA(A1:A3;0))`, still takes the first cell. The text below is the +original limitation. + IFNA is not an array-forcing function in OpenFormula 1.4. When `value` is a matrix, the current implementation returns the matrix as-is without per-element #N/A substitution. Implementing full element-wise IFNA would
