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 then they are pasted in but - as you can see in the attachment calc1.png , when the field category is changed to Text
Are you really sure about your English locale? Whatever I try in any other version, I alwasys get numbers. I can't test with 3.6 since I wiped that rubbish off my disc. -- View this message in context: http://nabble.documentfoundation.org/Calc-on-Linux-doesn-t-recognize-numbers-pasted-in-loaded-from-txt-csv-tp4005053p4005813.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org 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