https://bz.apache.org/ooo/show_bug.cgi?id=82687
orcmid <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #4 from orcmid <[email protected]> --- What CSV formats allow is not the same aa what happens when a field is marked as currency and the input editor or the cell formatting attaches additional symbols and text when the data is entered manually into a cell. The CSV is not meant to be an input format as much as a means of saving and restoring. It just doesn't carry formatting. We need to be careful and not get these all snarled up. For example, if you look in the ODS, you'll see that numerics are just numerics even though the presentation format may have different text. CSV simply doesn't carry all of that. It is from a simpler time. I think it is best to look at what OpenOffice *saves* into CSV for different kinds of Numeric cells and Text cells and ensure those values are restored on input. If people want the formatted interpretation to be carried, that is what the ODS (and counterparts in Microsoft Office) are for. Also keep in mind that anything more exotic needs to be documented in an understandable way, and then we need to figure out how that all works in interchange between different "CSV-supporting" products. I am surprised that the extraction of the numerical part didn't happen though. Was the option to treat quoted material as text checked? -- You are receiving this mail because: You are on the CC list for the issue.
