| Summary: | concat function ignores decimal point display | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | gyrlgith <gyrlgith> |
| Component: | Calc | Assignee: | gyrlgith <gyrlgith> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | miguelangelrv |
| Priority: | medium | ||
| Version: | 6.4.0.0.beta1+ | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Linux (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
decimate point no change
Sample file with TEXT() function in. Text function "0" sets referrer number to 0 |
||
|
Description
gyrlgith
2019-12-18 01:31:04 UTC
Created attachment 156640 [details]
decimate point no change
Cell format doesn't change ceel value, so references to the cell retrieve the true value not the formatted value. Use a formula like =CONCAT(TEXT(I10;"0")). BTW you can use the operator '&' to concatenate texts ="a"&"b" Thanks for telling me &. Probably faster than using concat, probably. And the text function doesn't fix this. That would make all the numbers "0" and have no meaningful result. (In reply to gyrlgith from comment #3) > Thanks for telling me &. > Probably faster than using concat, probably. > And the text function doesn't fix this. > That would make all the numbers "0" and have no meaningful result. Have you tested? TEXT(I10;"0"), gives a text with zero decimals no matter how many it has. The function can use the same formats than a cell uses. https://help.libreoffice.org/6.3/en-US/text/scalc/01/04060110.html?DbPAR=CALC#bm_id3147132 https://help.libreoffice.org/6.3/en-US/text/shared/01/05020301.html?&DbPAR=CALC&System=WIN Please take a quick review of calc documentation https://documentation.libreoffice.org/en/english-documentation/ it helps a lot to know what can be done and how. Created attachment 156733 [details]
Sample file with TEXT() function in.
See your file with the TEXT() function in.
Created attachment 156779 [details]
Text function "0" sets referrer number to 0
We could reproduce the bug.
Take a look at sheet 2 with the attached file. The number that should be 23 will be 0 by the text function
This happens when the referrer uses concat or sum. Some combinations do not occur, but it is unclear why they do.
Of course I updated to 6.2.3.8 and deleted the configuration file before checking.
Older versions would be wrong to report bugs.
But even the latest version had bugs. What do you think?
Does this not happen in beta version etc?
(In reply to m.a.riosv from comment #4) > Have you tested? TEXT(I10;"0"), gives a text with zero decimals no matter > how many it has. Yeah, I tested and saved it and closed the file that day thinking I was able to hide the decimal point. However, the next day, when I opened the file, the number was 0. I've been working on creating a bug reproduction file in the last few days. The bug has been reproduced! (In reply to gyrlgith from comment #6) > Created attachment 156779 [details] > Text function "0" sets referrer number to 0 No spreadseet file attached. (In reply to gyrlgith from comment #6) As @m.a.riosv told you, your attachment 156779 [details] is likely the wrong one: it's neither a spreadsheet, nor even a screenshot: it's just a plain text "Text function "0" sets referrer number to 0", which is plain wrong statement: function TEXT is used to format value into string (see first link in comment 4), not change its value; and its second argument is just a format string, not a value. I suppose you have made a mistake using the function. On the other side, the original question here is not a bug; as mentioned in comment 2, the behaviour that cell formatting is not taken into account when you concatenate cell's value into a string is expected and correct. Resolving NOTABUG; for questions regarding "how to use Calc correctly", please ask a question on https://ask.libreoffice.org. |