This function increases interoperability with Microsoft Excel, which has had an equivalent FLOOR.MATH function since Excel 2013. When Calc opens an Excel file or saves a spreadsheet to Excel format, it does not need to convert references to FLOOR.MATH to some other function.
This page was last edited 06:10:10, 2020-09-25 by The Document Foundation Wiki user FuzzyBot.
Please note that all contributions to The Document Foundation Wiki are considered to be released under the Creative Commons Attribution-ShareAlike 3.0 Unported License, unless otherwise specified. This does not include the source code of LibreOffice, which is licensed under the GNU Lesser General Public License (LGPLv3). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy (see Project:Copyrights for details). LibreOffice was based on OpenOffice.org. If you do not want your writing to be edited mercilessly and redistributed at will, then do not submit it here.