Created attachment 141067 [details]
The offending TEXT example column T -W workes fine in J-O ???
The TEXT function is occasionally very sick. It gets the <format> and <number> fields confused. Not always; it appears to get sick arround T-W columns.
The errors are hightleted.
I am attaching the spreedsheet.
Help of the TEXT function: https://help.libreoffice.org/6.0/en-US/text/scalc/01/04060110.html?System=WIN&DbPAR=CALC#bm_id3156426
Converts a number into text according to a given 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.
=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/