[Libreoffice-bugs] [Bug 131536] FILEOPEN XLSX TEXT formula gives different result than in Excel

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO

--- Comment #5 from Eike Rathke <erack at redhat.com> ---
An empty format string makes no sense as it would return an empty string for
any input value. If that is actually desired the proper format string would be
";;;" (i.e. all empty sub formats).

However, if Excel allows such in TEXT() we could as well. ODFF puts no
constraints on TextFormatCode. BUT, what does Excel actually do there?
Apparently it does not return an empty string? Does it return a formatted
string according to the 'General' format? Something else? Can someone please
check?

For example, output for these is ...?
=TEXT(0;"")
=TEXT(12.3456;"")
=TEXT(1E23;"")
=TEXT("lala";"")

-- 
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/20200505/81c2d2d9/attachment.htm>