https://bugs.freedesktop.org/show_bug.cgi?id=85431
Bug ID: 85431
Summary: Matrix computation made by a libreoffice-basic
function returning an array generates erratic errors
522
Product: LibreOffice
Version: 4.3.2.2 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Libreoffice
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: descout_oliv...@yahoo.fr
Created attachment 108388
--> https://bugs.freedesktop.org/attachment.cgi?id=108388&action=edit
A calc sheet reproducing the matrix computation issue
Problem description:
When recomputing matrix values computed by a libreoffice-basic function, which
returns an array, CALC shows erratic errors 522, even though there are no
circular references in the spreadsheet and the called BASIC function works
perfectly fine under the debugger.
How to reproduce the issue:
- Open the attached Calc document. This document contains zero macro and 1
BASIC function (named "LOESS1") implementing a "Local regression fitting"
(a.k.a. LOESS) algorithm (which has been successfully tested elsewhere). This
function returns an array of Double and is called in the formula of a cell
matrix (located in column C)
- Say "yes" to the "activate macros" question. The document gets open with no
error in column C.
- Type a different number value in B3 (e.g. "76.8"). The column C gets
recomputed, ending up with cells containing "Err:522".
Note that if you save the Calc document with that cell change, then close it
and reopen it, the column C gets recomputed with no "Err:522"... until you
change again a cell from column B.
Expected result:
No cell of the matrix should contain "Err:522" as there are no circular
reference in the recomputed cell formulas and the called function does not
generate any computation error.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
