[Libreoffice-bugs] [Bug 116780] TEXT function is failing -- every now and again. It gets the <format> and <number> confused.

[bugzilla-daemon at bugs.documentfoundation.org]

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

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |miguelangelrv at libreoffice.o
                   |                            |rg
         Resolution|---                         |NOTABUG

--- Comment #1 from m.a.riosv <miguelangelrv at libreoffice.org> ---
Help of the TEXT function:
https://help.libreoffice.org/6.0/en-US/text/scalc/01/04060110.html?System=WIN&DbPAR=CALC#bm_id3156426

TEXT
Converts a number into text according to a given format.
Syntax
TEXT(Number; Format)
Number is the numerical value to be converted.
Format is the text which defines the format. Use decimal and thousands
separators according to the language set in the cell format.
Example
=TEXT(12.34567;"###.##") returns the text 12.35
=TEXT(12.34567;"000.00") returns the text 012.35

you are giving numbers as second argument, so such number is taken as a string
by the function to format.

Being ROUND(T3,0) = 10, ROUND(T9,0) = 60, 10 or 60 as string used to format 4
doesn't make difference.

Help about format codes:
https://help.libreoffice.org/6.0/en-US/text/shared/01/05020301.html?&DbPAR=CALC&System=WIN

I don't know what you want achieve, but I can't see a bug.

Please to get help you can go
https://www.libreoffice.org/get-help/community-support/

-- 
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/20180403/fef68bf6/attachment-0001.html>