[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 #4 from Gatoso Oso <gatoso at grrlz.net> ---
«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»

I think the point is not Excel exactly, the point is that when someone exceed
the limitation and save the document with a .xls format, the calculation of the
function is not saved, all of this is made in LibreOffice Calc, not in Excel. I
think the actual warning is fine:

«This document may contain formatting or content that cannot be saved in the
currently selected file format “Microsoft Word 2007-2013 XML”.

Use the default ODF file format to be sure that the document is saved
correctly»

this describes what is the problem with precision, but it is useless in a
practical way. I was making a homework of university and due to that the warn
above mentioned was not related exactly with the problem of saving functions in
.xls format, I did not note the issue until I finished the homework, closed the
program, and reopened the file to verify all was right. Then, when I noticed
the limitation I had to make the whole work again but, this time, splitting the
average —by summing certain amount of values, getting some sums (less than 31)
and by dividing the whole sum by the amount of variables— for avoiding the
limitation. This took time and I was against the time.

I know I could use the .odt format, the problem is that my professors, at the
university, do not use LibreOffice but MS Office, and thus, they expect to
receive the homeworks in a .xls file.

I am not a developer, obviously, but I can give my vision as a user of
LibreOffice Calc that uses the program to process huge amounts of data, not to
calculate a fews variables.

Thanks a lot

-- 
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/20171215/a723764c/attachment.html>