https://bugs.documentfoundation.org/show_bug.cgi?id=99842
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG
--- Comment #10 from Eike Rathke <[email protected]> ---
For the relevant changes see
https://wiki.documentfoundation.org/ReleaseNotes/5.0#Formula_engine "New
spreadsheet functions".
I guess if you use Excel2007 to open .xlsx you're out of luck in this case
because Excel2007 doesn't implement FLOOR.MATH() and CEILING.MATH(). If you
need compatibility with such old versions then use FLOOR.XCL() and
CEILING.XCL() that require 2 parameters, which the others don't, and gets saved
as FLOOR() and CEILING() for Excel.
--
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
