[Libreoffice-bugs] [Bug 125137] Concatenating formatted numbers should respect the language formatting and not change it to user default

[bugzilla-daemon at bugs.documentfoundation.org]

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

Buovjaga <todventtu at suomi24.fi> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |needsDevAdvice
                 CC|                            |todventtu at suomi24.fi
            Summary|Language of Calc            |Concatenating formatted
                   |Spreadsheet                 |numbers should respect the
                   |                            |language formatting and not
                   |                            |change it to user default

--- Comment #5 from Buovjaga <todventtu at suomi24.fi> ---
The request might be valid, but I would like some developer input before
accepting it.

(In reply to csongor from comment #2)
> In order to get decimal points in my green and red cells, I would need to
> apply explicit formatting formulas which 
> - is cumbersome to add them one by one
> - would make the whole spreadsheet calculation slower
> - does not work if the file is write protected

It is not so cumbersome. You can add the formatting to the source formulas like
so:
=TEXT((ROUND(RAND()*(G$4-2*C5)+C5;2));"###.##")

>From help:

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 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/20190818/ae49b2e4/attachment.html>