[Libreoffice-bugs] [Bug 51990] New: A Calc macro with file refs. fails but works in OOO v3.2

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=51990

             Bug #: 51990
           Summary: A Calc macro with file refs. fails but works in OOO
                    v3.2
    Classification: Unclassified
           Product: LibreOffice
           Version: 3.5.4 release
          Platform: x86 (IA32)
        OS/Version: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: joehope52 at gmail.com


Created attachment 64123
  --> https://bugs.freedesktop.org/attachment.cgi?id=64123
Files for reproducing the error.

Overview:
A macro in Calc operating on numerical values in a matrix works well in
OpenOffice v3.2.0 (Ubuntu 10.04) and OpenOffice v3.2.1 (Win XP SP3). (The macro
is developed in this version).

The macro fails in LibreOffice when its parameters refer to other files. 
(The macro also fails in OpenOffice v3.3 for some cases but with a different
error - wrong lookup).

The function of the macro is to interpolate linearly between columns in a
matrix.

Three types of matrix filling has been provided in the attached examples: 
A normally filled matrix, a matrix with interleaved rows (only data on every
second line), and matrices with empty areas (positions where no data has been
entered).


Steps to reproduce:
First of all we are talking about Danish versions of LibreOffice in all cases.

1.
Start-up LibreOffice Calc v 3.5.4 (Danish)

2.
Copy the macro code from the attached file "Macro_source_code.txt" to the
Standard library.

3.
Allow macros

4.
Open the attached file "Data.ods" and allow macros.
Now the result should look as in attached file "Data.ods_v3.5.4.bmp".
Below each matrix 3 interpolations between column 1 and 2 has been done in 3
different rows, and the results nicely shows 3, 13 and 23 as expected.

5.
Open the attached file "Data_a.ods" and allow macros.

Now the result should look as in attached file "Data_a.ods_v3.5.4.bmp".
Here the same interpolations have been done for each matrix but with the
macroparameters now referring to the file "Data.ods".
Now the interpolation fails in all cases with error 504.

6.
Open the attached file "Data_b.ods" and allow macros.
Now the result should look as in attached file "Data_b.ods_v3.5.4.bmp".
This is a simple cell-to-cell reference to check the referencing to external
files. These answers are correct.



Subconclusion:
It seems not to be the referencing to external files itself that creates the
error.

The error is observed using WIN XP SP3 and Ubuntu 11,04. Seems independent of
OS.


Additional information:
The Fejl_LO.zip file has been attached with the following files:
3 data files:
Data.ods
Data_a.ods
Data_b.ods
3 screen dumps:
Data.ods_v3.5.4.bmp
Data_a.ods_v3.5.4.bmp
Data_b.ods_v3.5.4.bmp
2 text files:
Macro_source_code.txt      (Macro source code - use this for test)
Macre_source_code_eng_comm.txt     (Same as above but with english comments)

The macro was developed in OpenOffice v3.2. When upgrading to OOO v3.3 the
macro failed in some of the cases when referring to other files by delivering
wrong results. LibreOffice v3.3 and on fails for all cases when referring to
other files with error 504. I can send detailed step-by-step descriptions and
files for the OOO case, if it would be at any help.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.