[Libreoffice-bugs] [Bug 114375] FILESAVE: LibreOffice Calc won' t save AVERAGE when it contains 31 cells or data (.xls file)

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from raal <raal at post.cz> ---
(In reply to Gatoso Oso from comment #2)
> Thank you so much. Perhaps, LibreOffice could notify or warn when someone
> tries to exceed such limitation. Although, I think this should be reported
> as a new feature.

Answer from developer:
IMHO it is not possible to give an explicit warning to the user on export to
OOXML that a function call may not work properly in Excel. (A general warning
is already being given to the user when choosing for OOXML file format.)
The problem is that to count the number of arguments, the function must be
interpreted as if calculating the function. That does not happen on saving (and
can be quite time consuming).
The function arguments can be given as separate values and/or references to
(ranges of) discrete values and/or results of other functions. E.g. with a
named range AVERAGE(a) can have one to many arguments, depending on the range
of a.
Also, not all Excel versions are the same, some some functions will be handled
correctly in Excel2016, but not in Excel2010. When saving to OOXML format, we
don't know what (version of) application will be used to open it, so the
warning may be more annoying than helpful.

-- 
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/20171214/dc03bb4f/attachment.html>