[Libreoffice-bugs] [Bug 129460] concat function ignores decimal point display
https://bugs.documentfoundation.org/show_bug.cgi?id=129460 gyrlgith changed: What|Removed |Added Resolution|NOTABUG |--- Assignee|libreoffice-b...@lists.free |gyrlg...@protonmail.com |desktop.org | Status|RESOLVED|UNCONFIRMED --- Comment #6 from gyrlgith --- Created attachment 156779 --> https://bugs.documentfoundation.org/attachment.cgi?id=156779=edit 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? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 129460] concat function ignores decimal point display
https://bugs.documentfoundation.org/show_bug.cgi?id=129460 --- Comment #5 from m.a.riosv --- Created attachment 156733 --> https://bugs.documentfoundation.org/attachment.cgi?id=156733=edit Sample file with TEXT() function in. See your file with the TEXT() function in. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 129460] concat function ignores decimal point display
https://bugs.documentfoundation.org/show_bug.cgi?id=129460 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #4 from m.a.riosv --- (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?=CALC=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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 129460] concat function ignores decimal point display
https://bugs.documentfoundation.org/show_bug.cgi?id=129460 gyrlgith changed: What|Removed |Added Status|RESOLVED|UNCONFIRMED Resolution|NOTABUG |--- --- Comment #3 from gyrlgith --- 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 129460] concat function ignores decimal point display
https://bugs.documentfoundation.org/show_bug.cgi?id=129460 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG CC||miguelangelrv@libreoffice.o ||rg --- Comment #2 from m.a.riosv --- 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" -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 129460] concat function ignores decimal point display
https://bugs.documentfoundation.org/show_bug.cgi?id=129460 --- Comment #1 from gyrlgith --- Created attachment 156640 --> https://bugs.documentfoundation.org/attachment.cgi?id=156640=edit decimate point no change -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs