Difference between revisions of "Talk:Calc/Features/Numbers import for plain text files"
From Apache OpenOffice Wiki
| Line 4: | Line 4: | ||
Does that answer your question? --[[User:Kohei|Kohei]] 00:01, 7 August 2009 (UTC) | Does that answer your question? --[[User:Kohei|Kohei]] 00:01, 7 August 2009 (UTC) | ||
| + | |||
| + | : The spec is clear now. Although it's a pity that scientific numbers are not detected as "normal" numbers. This requires an additional step in the spreadsheet to convert them back to numbers. But in contrast to the number->date error, this conversion is possible. So it's only inconvenient but no loss of data. Apart from that, the new feature is a good idea and I encourage you to implement it. [[User:Regina|Regina]] 08:56, 7 August 2009 (UTC) | ||
Revision as of 08:56, 7 August 2009
Please specify how numbers in scientific notation are treated. (and remove this comment then) Regina 22:43, 6 August 2009 (UTC)
How scientific notations are parsed will not change by this enhancement. Rather, the purpose of introducing the "Detect special numbers" option is precisely to disable special number detection, mostly because of user's complaints about Calc's CSV import filter incorrectly converting cell values to dates. So, I will not cover how scientific notations are parsed in this spec, since I really don't know. ;-)
Does that answer your question? --Kohei 00:01, 7 August 2009 (UTC)
- The spec is clear now. Although it's a pity that scientific numbers are not detected as "normal" numbers. This requires an additional step in the spreadsheet to convert them back to numbers. But in contrast to the number->date error, this conversion is possible. So it's only inconvenient but no loss of data. Apart from that, the new feature is a good idea and I encourage you to implement it. Regina 08:56, 7 August 2009 (UTC)
