[Libreoffice-bugs] [Bug 53491] New: FILEOPEN: "Detect special numbers" option during text import seems to be backwards?

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=53491

             Bug #: 53491
           Summary: FILEOPEN: "Detect special numbers" option during text
                    import seems to be backwards?
    Classification: Unclassified
           Product: LibreOffice
           Version: 3.6.0.4 release
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
 Status Whiteboard: BSA
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: skoehler at bell.net


Created attachment 65544
  --> https://bugs.freedesktop.org/attachment.cgi?id=65544
An example TSV file showing the issue with exponential-formatted numbers.

Problem description: 
Selection of the detect special numbers seems to work backwards from
documentation
(http://help.libreoffice.org/Common/Text_Import#Detect_special_numbers) and (at
least my) expectations.

Steps to reproduce:
1. Open temp.tsv (attached) using scalc
2. Select (or don't select) "Detect special numbers" on import.

Current behavior:
"Detect special numbers" selected -> 3E is left as text
"Detect special numbers" unselected -> 3E is converted to 3

Expected behavior:
The exact opposite behavior (but with the option still left unselected by
default...I believe this matches Excel's behavior, not that Excel is the
touchstone to meet :) ).

Platform (if different from the browser): CentOS 5.6, x86_64

Other notes: Interestingly, the documentation seems to be incorrect either way
about not interpreting any exponential number...you'll notice that the 2nd item
in temp.tsv (3E2) is interpreted as a number regardless of this option's value.
 However, Excel does the same thing, so I actually prefer it that way for
interoperability purposes.  In any event, this software is truly great, thanks!
 And, as always, I apologize in advance if this is something braindead that I'm
not understanding properly.

Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:14.0) Gecko/20100101
Firefox/14.0.1

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.