https://bz.apache.org/ooo/show_bug.cgi?id=126656
--- Comment #2 from orcmid <[email protected]> --- (In reply to orcmid from comment #1) > ="2.2"*2 doesn't work either. It is a challenge when "2.2" is definitely text, as in A1 = "2.2" B1 = A1*2 Having this work in interchange when the decimal separator is different depending on the locale where the spreadsheet is problematic. =VALUE("2.2")*2 works where "." is the decimal separator. I suspect that =VALUE("2,2")*2 works where "," is the decimal separator. -- You are receiving this mail because: You are the assignee for the issue.
