Created attachment 125048 [details]
I use windows 10 64 bits LO 18.104.22.168 (x64):
With reference to bug 86575 i have the problem make small.
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 22.214.171.124 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()
Version: 126.96.36.199 (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
> Related information:
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()"
"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 188.8.131.52 and open the version Version: 184.108.40.206.0+
Build ID: 33fe9e6da9241aacac6816cbb5211f4d5fa7fba1
> The change is:
> "afronden.beneden()" in "_xlfn.FLOOR.MATH()"
> "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 220.127.116.11 the change are:
FLOOR() -> FLOOR.MATH()
CELING() -> CEILING.MATH()
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:
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.