[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

Xisco Faulí <xiscofauli at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |xiscofauli at libreoffice.org
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEEDINFO

--- Comment #6 from Xisco Faulí <xiscofauli at libreoffice.org> ---
(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 csongor at halmai.hu,
Does it fulfill your expectations ?

-- 
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/20200717/9e3ce9c8/attachment-0001.htm>