https://bugs.documentfoundation.org/show_bug.cgi?id=125137
Buovjaga <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |needsDevAdvice
CC| |[email protected]
Summary|Language of Calc |Concatenating formatted
|Spreadsheet |numbers should respect the
| |language formatting and not
| |change it to user default
--- Comment #5 from Buovjaga <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
