https://bugs.documentfoundation.org/show_bug.cgi?id=161470
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.documentfounda | |tion.org/show_bug.cgi?id=12 | |7808 --- Comment #16 from Eike Rathke <[email protected]> --- (In reply to Óvári from comment #12) > =FORMULATEXT() from Excel converts to FORMULA() in Calc (hopefully it > converts back if required Yes it does (saved as _xlfn.FORMULATEXT(...)). You could easily try by saving the loaded document to a new .xlsx file and either inspect its (zip) xl/worksheets/sheet*.xml streams, or loading it in Excel. > LibreOffice seems to silently remove the `@` character. As I mentioned in comment 5 there is no @ character stored in the formula thus Calc does not remove it. If it was present in the formula then the result would be a #NAME? error or similar. The cell saved in the .xlsx xl/worksheets/sheet3.xml stream is literally <c r="B3" s="14"> <f>VLOOKUP(A:A,D:E,2,FALSE)</f> <v>15</v> </c> It's all an Excel UI feature depending on whether it has dynamic arrays enabled or not. See also https://bugs.documentfoundation.org/show_bug.cgi?id=127808#c2 of bug 127808 that Regina pointed to in comment 7. -- You are receiving this mail because: You are the assignee for the bug.
