https://bugs.documentfoundation.org/show_bug.cgi?id=42593
--- Comment #5 from ady <[email protected]> --- (In reply to Szczepan Hołyszewski from comment #3) > 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 I selected the text directly from comment 3. In Calc, I used paste special in order to select the "use text import dialog". > 4. In the import dialog, adjust separators appropriately to get three > columns In the dialog, I selected UTF-16, English (USA), detect special numbers, and all three columns as "US English". > 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. All pasted values were recognized as numbers, not as text. This was tested on 7.6alpha+. I have not tested with 7.5.0.3. -- You are receiving this mail because: You are the assignee for the bug.
