sc/source/core/tool/interpr4.cxx | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 94c64c0c999eeaa91ebdc335186289046eacdc4f
Author: Eike Rathke <er...@redhat.com>
AuthorDate: Thu Nov 3 19:10:00 2022 +0100
Commit: Eike Rathke <er...@redhat.com>
CommitDate: Fri Nov 4 01:02:34 2022 +0100
Related: tdf#151863 Set #REF! error if reference list is not convertible
i.e. to array/matrix that a function or operator may expect.
That indicates the actual problem better than #VALUE! and also
seems to be what Excel does.
Change-Id: I9c3857613e330f9a93d4a0595e740106addc6e67
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/142250
Reviewed-by: Eike Rathke <er...@redhat.com>
Tested-by: Jenkins
diff --git a/sc/source/core/tool/interpr4.cxx b/sc/source/core/tool/interpr4.cxx
index 90b02b1e7f47..b122a836d654 100644
--- a/sc/source/core/tool/interpr4.cxx
+++ b/sc/source/core/tool/interpr4.cxx
@@ -1581,7 +1581,7 @@ bool ScInterpreter::ConvertMatrixParameters()
eType != formula::ParamClass::ForceArray)
{
// can't convert to matrix
- SetError( FormulaError::NoValue);
+ SetError( FormulaError::NoRef);
}
// else: the consuming function has to decide if and how to
// handle a reference list argument in array context.
