https://bugs.documentfoundation.org/show_bug.cgi?id=131536
Eike Rathke <er...@redhat.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #5 from Eike Rathke <er...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
