https://bugs.freedesktop.org/show_bug.cgi?id=32954
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #66183|0 |1 is obsolete| | --- Comment #13 from [email protected] 2012-09-02 16:07:10 UTC --- Created attachment 66497 --> https://bugs.freedesktop.org/attachment.cgi?id=66497 screenshot after pasting With me, it's not the decimal separator thing... - I am using LibreOffice 3.6.0.2 on Kubuntu 12.04. (It seems to work fine on Win) - 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? -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
