https://bugs.documentfoundation.org/show_bug.cgi?id=157109
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |INVALID --- Comment #3 from ady <[email protected]> --- (In reply to CSV from comment #0) > Description: > Calc dialog offer an import option to "Detect Special Numbers", which cannot > be turned off. That sentence contradicts the following: > Actual Results: > letter+text combinations looking like hex code, IE3, 2E5, 2E6 etc, are > converted to decimal, or scientific notation > > > Expected Results: > 2E22 is converted to 2E+22, etc etc etc > It is not clear what is the intended meaning of the values: scientific notation of numbers, or something else (not a number, but text with some meaning that is not numeric). Calc includes functions to deal with hex code, but "hex code" by itself is not a number for Calc. Additionally, each column in the importing dialogue can be set to some other format (e.g. text) instead of a plain number. I am setting this report as INVALID for now. If there is really a bug to report, then the report needs more clear descriptions of the importing options, the intended result and the current behavior. It should also be tested with a current version of LO before reporting (LO 7.5 or newer at the moment I'm writing this comment). Please feel free to change the status of this report to UNCONFIRMED if relevant details of the problem can be provided. -- You are receiving this mail because: You are the assignee for the bug.
