https://bugs.documentfoundation.org/show_bug.cgi?id=125137
Ross Johnson <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |WONTFIX --- Comment #14 from Ross Johnson <[email protected]> --- (In reply to Jean-Baptiste Faure from comment #12) > 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. > I agree. This solution appears quite easy and natural to me. Using intermediate conversions is a common technique for changing between formats not just in spreadsheets. Generating intermediate/partial results for consumption in cells elsewhere is standard spreadsheet practice. I'm going to change status to RESOLVED/WONTFIX. -- You are receiving this mail because: You are the assignee for the bug.
