[Libreoffice-bugs] [Bug 99842] EDITING: when i use a formula in calc and save in xlsx, the formula is destroyed
https://bugs.documentfoundation.org/show_bug.cgi?id=99842 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 99842] EDITING: when i use a formula in calc and save in xlsx, the formula is destroyed
https://bugs.documentfoundation.org/show_bug.cgi?id=99842 Eike Rathke changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #10 from Eike Rathke --- 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 Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 99842] EDITING: when i use a formula in calc and save in xlsx, the formula is destroyed
https://bugs.documentfoundation.org/show_bug.cgi?id=99842 steve -_- changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=86 ||575 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 99842] EDITING: when i use a formula in calc and save in xlsx, the formula is destroyed
https://bugs.documentfoundation.org/show_bug.cgi?id=99842 --- Comment #9 from Markus Mohrhard --- 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 99842] EDITING: when i use a formula in calc and save in xlsx, the formula is destroyed
https://bugs.documentfoundation.org/show_bug.cgi?id=99842 Buovjaga changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 99842] EDITING: when i use a formula in calc and save in xlsx, the formula is destroyed
https://bugs.documentfoundation.org/show_bug.cgi?id=99842 --- Comment #8 from vlb --- (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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 99842] EDITING: when i use a formula in calc and save in xlsx, the formula is destroyed
https://bugs.documentfoundation.org/show_bug.cgi?id=99842 --- Comment #7 from vlb --- > 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() -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 99842] EDITING: when i use a formula in calc and save in xlsx, the formula is destroyed
https://bugs.documentfoundation.org/show_bug.cgi?id=99842 --- Comment #6 from vlb --- 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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 99842] EDITING: when i use a formula in calc and save in xlsx, the formula is destroyed
https://bugs.documentfoundation.org/show_bug.cgi?id=99842 --- Comment #5 from vlb --- (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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 99842] EDITING: when i use a formula in calc and save in xlsx, the formula is destroyed
https://bugs.documentfoundation.org/show_bug.cgi?id=99842 --- Comment #4 from vlb --- (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?. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 99842] EDITING: when i use a formula in calc and save in xlsx, the formula is destroyed
https://bugs.documentfoundation.org/show_bug.cgi?id=99842 --- Comment #3 from m.a.riosv --- Win10x64 Version: 5.1.3.2 (x64) Build ID: 644e4637d1d8544fd9f56425bd6cec110e49301b CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 99842] EDITING: when i use a formula in calc and save in xlsx, the formula is destroyed
https://bugs.documentfoundation.org/show_bug.cgi?id=99842 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||miguelangelrv@libreoffice.o ||rg Ever confirmed|0 |1 --- Comment #2 from m.a.riosv --- 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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 99842] EDITING: when i use a formula in calc and save in xlsx, the formula is destroyed
https://bugs.documentfoundation.org/show_bug.cgi?id=99842 vlb changed: What|Removed |Added Version|5.1.0.1 rc |5.0.6.2 release --- Comment #1 from vlb --- I have test in LO 5.0.6 and there is also the bug precent. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 99842] EDITING: when i use a formula in calc and save in xlsx, the formula is destroyed
https://bugs.documentfoundation.org/show_bug.cgi?id=99842 vlb changed: What|Removed |Added Version|unspecified |5.1.0.1 rc -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 99842] EDITING: when i use a formula in calc and save in xlsx, the formula is destroyed
https://bugs.documentfoundation.org/show_bug.cgi?id=99842 vlb changed: What|Removed |Added Keywords||regression -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs