https://bugs.documentfoundation.org/show_bug.cgi?id=154131

V Stuart Foote <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|1                           |0
           See Also|                            |https://bugs.documentfounda
                   |                            |tion.org/show_bug.cgi?id=53
                   |                            |491
             Status|NEW                         |UNCONFIRMED
         Depends on|                            |108254
                 CC|                            |[email protected],
                   |                            |[email protected]

--- Comment #3 from V Stuart Foote <[email protected]> ---
Well the other facet is hat the paste is being done into a column set with
Number General, so Numbers are *expected* to be recognized coming into the
cell.

If working with alphanumeric text you don't want the treated as number (1E1 ->
10, 5E2 -> 500) set the sheet column format to be 'Text' on import.

I don't think we can say the 'Detect special numbers' is at fault here. 1E1 and
5E2 are correctly picked up a numbers. The special numbers just renders them to
scientific notation.

IMHO => NAB

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: a179f6c91692076e7e17babf4890638caa398384
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108254
[Bug 108254] [META] File format filters (import/export) bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to