[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

Laurent BP <jumbo4444 at yahoo.fr> changed:

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

--- Comment #6 from Laurent BP <jumbo4444 at yahoo.fr> ---
Tests with Excel 2010
(In reply to Eike Rathke from comment #5)
> For example, output for these is ...?
> =TEXT(0;"")
returns empty string
> =TEXT(12.3456;"")
returns empty string
> =TEXT(1E23;"")
returns empty string
> =TEXT("lala";"")
returns "lala"

if argument is numeric (date, time, percent, scientific...) => empty string
if argument is text => string with same text
/!\ if text can be converted as a value, empty string is returned:
=TEXT( "5:3" ; "" ) or =TEXT( "5e3" ; "" )
returns empty string

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