https://bugs.documentfoundation.org/show_bug.cgi?id=101691

--- Comment #5 from Eric <[email protected]> ---
Hi raal

attached you will find 2 test-files (saved with LO 4.3.7.2):
- ZE 2016 MOM.ods with detailed project working times for each month of a year
- PP JT 2016.ods importing and aggregating the former monthly details to a bill
for each project customer

The second file uses external links to the first file in the formulas, e.g.
['file:///C:/Users/Jive/Arbeit/Projekte/Projektmanagement/4LO/ZE 2016
MOM.ods']Aug!$I4

Settings in both LO versions:
Extras.Options.LibreOffice Calc.Formula.Formel-Syntax="Excel A1"
Extras.Options.LibreOffice Calc.Formula.Detailed setup for
computation="Defaults/Vorgaben/First option" activated

In LO 4.3.7.2 sheet "P1" in file "PP JT 2016.ods" is correctly filled with
values in the rows 3-9, 11-17 and 19-23, e.g. column B having all cells set to
"2,00" and cells in column C set to "MA".

In LO 5.1.5.2 the whole sheet is empty (with exception to the "x" in A23). This
is wrong. Playing around with Extras.Options.LibreOffice Calc.Formula.Detailed
setup for computation=OpenCL-option and its modal window does not change
results.

I just installed LO5 without changing any of the setup.

Thanks for your review.

Regards Eric

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to