https://bugs.documentfoundation.org/show_bug.cgi?id=130509
Bug ID: 130509
Summary: Google Sheets export to XLSX gives lowercase formula
"ifs()"
Product: LibreOffice
Version: 6.0.7.3 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 157731
--> https://bugs.documentfoundation.org/attachment.cgi?id=157731&action=edit
Image shows error in formula exported from Google Docs to XLSX format
I made a rather simple formula in Google Sheets and sent the sheet as email
attachment, then I opened the resulting .XLSX document in Libreoffice Calc. In
Calc, the formula "IFS" is lowercase "ifs", which causes the formula to fail.
Other formulae in the same cell are uppercase.
The spreadsheet is simple. In the first cell (A1) and the second one (B1) I add
either text or number (like A and 32)
In the third column (C1), I add the following:
=ifs(isblank(A1);"A1 is blank";istext(B1);"A1 is not blank and B1 contains
text";isnumber(B1);"A1 is not blank and B1 is a number")
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
