https://bugs.freedesktop.org/show_bug.cgi?id=69072
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW Severity|minor |normal Summary|FILEOPEN: .xlsm FLOOR() |FILEOPEN: .xlsx FLOOR() |adds ,1 on every load |adds ,1 on every load Version|4.0.5.2 release |Inherited From OOo Ever confirmed|0 |1 --- Comment #1 from Mike Kaganski <[email protected]> --- Reproducible with 3.3.0.4 - 4.1.2.1, and also with AOO 4.0 under Win7x64. When LO opens an OOXML file (not only .xlsm) with FLOOR or CEILING, they both are supplied with an extra parameter ";1". The fact that this happens upon opening may be seen from the OOXML source: LO shows one more argument than there is in the xml source (xl\worksheets\sheetN.xml). It seems that xlsx doesn't accept FLOOR with three (or more) arguments (unlike xls, that accepts 3-argument FLOOR). Upon opening such file with 3+ arguments in FLOOR/CEILING, MS Excel complains about errors in file, and suggest repairing the file. When repaired, all such formulas are removed and the last computation result is left in the cells. AOO cannot save xlsx, but it adds extra parameter when opens it, too. Probably, the problem is somehow related to the fact that LO adds third parameter to FLOOR/CEILING when dealing with xls? But there only three parameters result, never 4 or more, and three parameters are OK in xls. As it impairs interoperability, I raise severity back to normal. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
