[Libreoffice-bugs] [Bug 130509] New: Google Sheets export to XLSX gives lowercase formula "ifs()"

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: thor.rustad at gmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200207/11a41b6d/attachment.htm>