Download it now!
Bug 116780 - TEXT function is failing -- every now and again. It gets the <format> and <number> confused.
Summary: TEXT function is failing -- every now and again. It gets the <format> and <nu...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.1.1 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-04-03 19:53 UTC by Christopher Hartsough
Modified: 2018-04-03 22:42 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
The offending TEXT example column T -W workes fine in J-O ??? (18.50 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-04-03 19:53 UTC, Christopher Hartsough
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Christopher Hartsough 2018-04-03 19:53:12 UTC
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.
Comment 1 m.a.riosv 2018-04-03 22:42:19 UTC
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/