[Libreoffice-bugs] [Bug 129460] concat function ignores decimal point display

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=129460

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #4 from m.a.riosv <miguelangelrv at libreoffice.org> ---
(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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191222/7fbf6d32/attachment.htm>