[Libreoffice-bugs] [Bug 122545] FILEOPEN: Error on creating script provider for Python script from location=document

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #9 from spinnau at gmail.com ---
Good catch! With the "Recalculate on File Load | ODF spreadsheet" option set to
"Never recalculate" the test document works fine with the older versions
5.4.7.2, 6.0.7.3 and 6.1.3.2. Changing this option to "Always recalculate"
triggers the error message (Error creating provider from factory!) at opening
of the test file on all these versions. All the tests were done with Linux
AppImages.

Thus, I think the recalculation of the cells will be done too early before the
Python scripts from loaction=document were available.

But at testing I have also found another problem. If the "Always recalculate"
option is set in version 6.1.4.2 then at opening the test file the error
message dialog appears twice. I think in this case the recalculation will be
done twice, once through the "Always recalculate" option and once for
determining the optimal cell heights. This assumption can be verified by
changing the height for cell "B3" in the test file from optimal to a fixed
height. In that case at opening the test file the error message appears only
once with "Always recalculate" option, and no error message is shown with
"Never recalculate".

Independent of this bug, a recalculation of the cells shouldn't happen twice
when a document is opened. Maybe another bug report should be opened for this.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190109/cf4e285f/attachment.html>