https://bugs.documentfoundation.org/show_bug.cgi?id=116780
m.a.riosv <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
CC| |[email protected]
| |rg
Resolution|--- |NOTABUG
--- Comment #1 from m.a.riosv <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
