https://bugs.documentfoundation.org/show_bug.cgi?id=125137
Xisco Faulí <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
Ever confirmed|0 |1
Status|UNCONFIRMED |NEEDINFO
--- Comment #6 from Xisco Faulí <[email protected]> ---
(In reply to Buovjaga from comment #5)
> 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
Hello [email protected],
Does it fulfill your expectations ?
--
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
