Created attachment 64123 [details]
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.