<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Concatenating formatted numbers should respect the language formatting and not change it to user default" href="https://bugs.documentfoundation.org/show_bug.cgi?id=125137#c7">Comment # 7</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Concatenating formatted numbers should respect the language formatting and not change it to user default" href="https://bugs.documentfoundation.org/show_bug.cgi?id=125137">bug 125137</a> from <a class="email" href="mailto:csongor@halmai.hu" title="csongor@halmai.hu">csongor@halmai.hu</a> <pre>(In reply to Xisco Faulí from <a href="show_bug.cgi?id=125137#c6">comment #6</a>) > > Example > > > > =TEXT(12.34567;"###.##") returns the text 12.35 > > > > =TEXT(12.34567;"000.00") returns the text 012.35 > > Hello <a href="mailto:csongor@halmai.hu">csongor@halmai.hu</a>, > Does it fulfill your expectations ? My answer has two parts. Part #1. No, it doesn't work this way. The following formula produces 3,14, not 3.14 ("SZÖVEG" means "TEXT" in Hungarian): =SZÖVEG(PI();"###.##") More precisely, it works... weird... I attach a new file pi_text.ods. Both A1 and A2 have the same formula: =SZÖVEG(PI();"###.##") but in A1 there is 3,14 displayed (with comma) while in A2 there is 3.14 (with decimal point). I cannot see any difference between the two cells, even the formatting seems to be the same. If I am right and there is no difference between the cells then it seems to be a bug in my LO which is: Verzió: 6.3.3.2 (x64) Build az.: a64200df03143b798afd1ec74a12ab50359878ed 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. The following solutions would be better: a) There was a document-wide setting how the numbers should be converted to string. If the ODS file contains that the original author used English (USA) then I can decide if I want to use their setting or use my own default. b) The cells that contain concatenation (like D5), should respect the formatting setting. For example, if I format the cell this way: in the Format -> Cells -> Cells dialog - Category = Number - Format = General - Language = English (USA) then the concatenation should display the numbers with English formatting, not Hungarian. It should be "<circle cx='4.5'...>", not "<circle cx='4,5'...>"</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>