Created attachment 125048 [details] destroy formula I use windows 10 64 bits LO 5.1.3.2 (x64): With reference to bug 86575 i have the problem make small. Reproduce bug: 1) open attachment "afronden.ods" 2) save as *.xlsx 3) the formula in A2, A3, A4, A5 and B2, B3, B4, B5 are destroyed I have test in LO 3.5 to 4.4.7 and there was it oke. In LO 5.1.0.1 there was the first where the bug are precent. I didn't have LO 5.0.0 and 5.1.0 and didnt have test here.
I have test in LO 5.0.6 and there is also the bug precent.
Please what do you mean by destroyed? What I see is FLOOR() changed by FLOOR.MATH() and CEILING() changed by CEILING.MATH() Related information: https://wiki.documentfoundation.org/ReleaseNotes/5.0#New_spreadsheet_functions
Win10x64 Version: 5.1.3.2 (x64) Build ID: 644e4637d1d8544fd9f56425bd6cec110e49301b CPU Threads: 4; OS Version: Windows 6.19; UI Render: default;
(In reply to m.a.riosv from comment #2) > Please what do you mean by destroyed? > > What I see is FLOOR() changed by FLOOR.MATH() and CEILING() changed by > CEILING.MATH() > > Related information: > https://wiki.documentfoundation.org/ReleaseNotes/5. > 0#New_spreadsheet_functions I have a Dutch version of LO. There is also change the formula from NL to EN, i didn't know about change in release note. The change is: "afronden.beneden()" in "_xlfn.FLOOR.MATH()" and "afronden.bboven()" in "_xlfn.CEILING.MATH()" This shos a error in the result in #name?.
(In reply to vlb from comment #4) > (In reply to m.a.riosv from comment #2) > > Please what do you mean by destroyed? > > In version LO 4.4.7 is the formula disappeared in cel A2, A3 and B2, B3. Here is a celname used. In LO 4.4.2 isn't the formula disappeared.
When i used the formula "afronden()" in the dutch version LO 5.1.3.2 and open the version Version: 5.1.4.0.0+ Build ID: 33fe9e6da9241aacac6816cbb5211f4d5fa7fba1 LO crashed
> The change is: > "afronden.beneden()" in "_xlfn.FLOOR.MATH()" > and > "afronden.bboven()" in "_xlfn.CEILING.MATH()" > This shos a error in the result in #name?. This happens when i save the file in *.xlsx and open in excel 2007. When i open the *.xlsx file in LO 5.1.3.2 the change are: LO English FLOOR() -> FLOOR.MATH() CELING() -> CEILING.MATH() LO Dutch afronden.beneden() -> ONDERGRENS.MATH() afronden.boven() -> BOVENGRENS.WISKUNDIG()
(In reply to vlb from comment #7) > > The change is: > LO Dutch > afronden.beneden() -> ONDERGRENS.MATH() > afronden.boven() -> BOVENGRENS.WISKUNDIG() In Excel 2016 is change in, when open *.xlsx: LO Dutch afronden.beneden() -> afronden.beneden.wisk() with error mention afronden.boven() -> afronden.boven.wisk() with error mention
Can we please try to limit bug reports to one issue and provide one descriptive set of steps how to reproduce the error. For this bug report anything happening before 5.0 is irrelevant as the code around FLOOR import/export changed a lot.
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.