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

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=130509

Julien Nabet <serval2412 at yahoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |serval2412 at yahoo.fr

--- Comment #2 from Julien Nabet <serval2412 at yahoo.fr> ---
On pc Debian x86-64 with master sources updated today, I could reproduce this.

However, when unzipping the xlsx, it contains the function in lowercase in
xl/worksheets/sheet1.xml
ifs(isblank(A1),"A1 is blank",istext(B1),"A1 is not blank and
B1...
Specs of XLSX show functions in uppercase (see
https://docs.microsoft.com/en-us/openspecs/office_standards/ms-xlsx/3d025add-118d-4413-9856-ab65712ec1b0)

Perhaps on Windows it'll be ok because OS is case unsensitive but on Linux it
will fail.

IMHO, I think Google Docs is wrong here and would put "NOTOURBUG" but I may be
wrong since I'm not an expert so I'll let other speak.

-- 
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/ade0877e/attachment.htm>