https://bugs.documentfoundation.org/show_bug.cgi?id=170840
Bug ID: 170840
Summary: Crash of a macro with as parameter a sum of two
matrices comprising non-numerical values
Product: LibreOffice
Version: 7.0.6.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
If we launch a Macro in "Matrix" mode with the sum of two matrices as
parameter.
If non-numeric values are present in the matrices, their sum is impossible: the
macro should not be launched, and the message #VALUE! displayed, to indicate a
parameter error.
I notice that the Macro is launched, with a matrix with incorrect values, and
can crash. The IsNumeric() test does not detect these incorrect values...
Steps to Reproduce:
1.Create a macro designed to process a numeric matrix
For example, a macro that adds numeric values and ignores non-numeric ones :
Function Som( Liste() ) As Double
2.Use this macro in "Matrix" mode, with the sum of 2 numerical matrices as
parameter :
{=Som( A5:A10 + B5:B10 )} with numericals values in A5:A10 and B5:B10
3.Place a non-numeric value in one of the 2 matrix, to generate a parameter
error
Actual Results:
The macro is launched with a result matrix containing incorrect values, and may
crash, BEFORE the #VALUE! message is displayed
Expected Results:
The macro should not be lanched ; the #VALUE! message indicates a parameter
error
Reproducible: Always
User Profile Reset: No
Additional Info:
In the Macro, the IsNumeric() test does not detect the incorrect values of the
matrix received as parameter.
--
You are receiving this mail because:
You are the assignee for the bug.
