https://bugs.documentfoundation.org/show_bug.cgi?id=125137
Jean-Baptiste Faure <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #12 from Jean-Baptiste Faure <[email protected]> --- (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.
