https://bugs.documentfoundation.org/show_bug.cgi?id=42593
Szczepan Hołyszewski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|NOTABUG |--- --- Comment #3 from Szczepan Hołyszewski <[email protected]> --- As of 7.5.0.3, it is NOT TRUE that checking "Detect special numbers" allows scientific notation to be recognized as numbers. It JustDoesn'tWork™, plain and simple. Steps to reproduce: 1. launch localc 2. Copy the following text into clipboard: ``` 95 1.124388e+012 6912 96 1.606269E+012 7168 97 1.686582e012 7200 98 1.927522E012 7680 95 1.124388e+12 6912 96 1.606269E+12 7168 97 1.686582e12 7200 98 1.927522E12 7680 ``` 3. Paste the text into localc column A1 4. In the import dialog, adjust separators appropriately to get three columns 5. Check "Detect special numbers" 6. OK the dialog Expected: At least one number in the middle column should be recognized as a number (the 8 rows exhaust all combinations of [e vs E]×[+ vs no +]×[leading zero in exponent vs no leading zero]). Actual: The entire middle column contains text cells. -- You are receiving this mail because: You are the assignee for the bug.
