Peter Pervers wrote > > Following problem: > > - I am using LibreOffice 3.6.0.2 on Kubuntu 12.04. > - I am using a English US locale where the decimal separator is the > period. > - when I copy these three numbers out of this text box: > > 2.09 > 2.40 > 2.12 > > and paste them into Calc cells B2:B4 with the following settings > > - Separated by tab > - Text delimiter = nothing > - Field/column type: Standard > > If I select the three numbers in your post, then use ctrl+C and ctrl+V in LibreOffice 3.6.1.2, I get the "Text Import" screen. In that, ensure that *detect special numbers* is ticked.
-- View this message in context: http://nabble.documentfoundation.org/Calc-on-Linux-doesn-t-recognize-numbers-pasted-in-loaded-from-txt-csv-tp4005053p4005400.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
