https://bugs.documentfoundation.org/show_bug.cgi?id=164741
--- Comment #2 from Dione Maddern <[email protected]> --- (In reply to Mike Kaganski from comment #1) > Changing cell formatting *never ever* changes the data type. Changing data > type is inherently destructive process; e.g., when you have a *text* like "0 > 123 456,789", it is a sequence of 13 characters, with a zero, spaces serving > as thousand separators, exactly three decimals. If you convert this to a > number, this will be stored internally as a number exactly equal to > 123456.789000000004307366907596588134765625 - so: the information about > leading zero is lost; information about thousand separators is lost; > information about exact value is lost ... > > Thus, only explicit actions for data conversions - like Text to Columns - > really can convert the data type. Would it be more correct to talk about the number being "formatted as text", rather than "converted to text"? Perhaps with a note explaining that the data type is not affected by the formatting change? Please bear with me. I'm not a software developer, so I have a limited understanding of how Calc works. -- You are receiving this mail because: You are the assignee for the bug.
