[libreoffice-users] Calc on Linux doesn't recognize numbers pasted in / loaded from .txt/.csv

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
- thus, the summing in the status bar upon highlighting does not work
- cell C5, which computes the average of B2:B4 says Div/0.

This is already annoying enough but if I then change the Category to
"Number", then

- the numbering stuff still doesn't work but
- the content of the cells B2:B4 is changed: now the numbers are in
there with a single quote preceding them, still rendering them text
(see attachment calc2.png).

(i) Why can't I just paste numbers into Calc and have them be
recognized as numbers or,
(ii) if Calc is dumb enough to treat them as text although I say Field
category: General, why can't I at least get them to work as numbers
when I format the cells as numbers and not have a stupid quote in
there messing things up?

On Windows, this seems too work, but on Kubuntu 12.04 it does not

-- 
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