[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

Jean-Baptiste Faure <jbfaure at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jbfaure at libreoffice.org

--- Comment #12 from Jean-Baptiste Faure <jbfaure at libreoffice.org> ---
(In reply to csongor from comment #7)
> Part #2:
> 
> Even if it would work as expected, the sample spreadsheet should be changed
> a lot. For example, instead of 
> 
> ="<circle cx='"&A5&"' cy='"&B5&"' r='"&C5&"' stroke='black' stroke-width='3'
> fill='red' />"
> 
> in D4, the following formula should be used:
> 
> ="<circle cx='"&TEXT(A5;"###.##")&"' cy='"&TEXT(B5;"###.##")&"'
> r='"&TEXT(C5;"###.##")&"' stroke='black' stroke-width='3' fill='red' />"
> 
> I am not saying it is an impossible change but it requires a deep
> understanding about the calculations in the spread sheet and also requires a
> lot of cells to modify.

I disagree. An easy way to change your spreadsheet is to add 3 intermediate
columns formatted in English corresponding to columns A, B and C in which you
compute the corresponding text value. Then in column D you have only to change
to columns.

For example, if you use columns AA, AB and AC:
AA5=text(A5;"0.00")
AB5=text(B5;"0.00")
AC5=text(C5;"0.00")
D5=="<circle cx='"&AA5&"' cy='"&AB5&"' r='"&AC5&"' stroke='black'
stroke-width='3' fill='red' />"
Work to do:
1/ create the formula in AA5
2/ propagate it to AC5, then to AC24
3/ change the formula in D5
4/ propagate it to D24.

It works for me in French where the decimal separator is the comma too.

> 
> The following solutions would be better:

Changing the software is far more complex than changing your spreadsheet.
On the contrary, modifying your spreadsheet is much faster and easier and does
not depend on someone else's good will.

I propose to close this enhancement request as WontFix.

Best regards. JBF

-- 
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/20210813/e18fc310/attachment-0001.htm>