Created attachment 74326 [details]
Print screen of Language settings and Format cells
Pasting a number with two dots (thousand and million separator) are pasted as text (dots preserved after pasting into Calc cell).
Steps to reproduce:
1. First of all I have renamed the profile C:\Documents and Settings\[user]\Application Data\LibreOffice\3 to C:\Documents and Settings\[user]\Application Data\LibreOffice\3_old to make sure this is not a profile problem.
2. Check the Tools | Options | Language Settings | Languages. My settings are "Slovenian" (see attached file for details). In my local settings dots "." are used for thousand, million, billion etc separator and comma "," is used for decimal separator.
3. Becuase of default profile all of the cells are by default formated as numbers (menu Format | Cells | Numbers tab | Category = Number.
4. Now copy the following numbers into Calc (paste into cell A1):
Note: All of the pasted numbers are correctly pasted. No problem.
4. Now copy numbers from step 3 one by one, each number in new cell.
Note: All of the numbers are pasted as numbers, except for the number 1.000.000. In "Input line" there is obvious dots are preserved in cell after pasting.
I have also tested the number 1.234.567 and the same problem.
Any number with two dots does not paste correctly.
Number with two dots (thousand and million separator) should paste as numbers.
P.S. See print screen of my Tools | Options | Language Settings | Languages and Format | Cells.
Operating System: Windows XP
Version: 126.96.36.199 release
Created attachment 74327 [details]
Sample calc file after pasting numbers one by one
I have tested the same problem on my Ubuntu 12.04 test computer.
=== LibreOffice v188.8.131.52 on Ubuntu 12.04 ===
Coping one number at a time (from list of numbers from bug report) and problem is exactly the same as described above for LibreOffice 184.108.40.206 on Windows XP. So this looks like an old problem appearing in v3.6.0/Ubuntu and v3.6.5/Windows.
=== LibreOffice v220.127.116.11 on Ubuntu 12.04 ===
Installing LibreOffice v4 deb files from www.libreoffice.com/download web page.
Coping one number at a time and problem is even worse then in v3.6.5.
are copied fine - after coping becomes number.
are copied with dots, so instead of numbers they become text.
So this additional problem looks like a LibreOffice v4.0 REGRESSION! to the previous LibreOffice v3.6 development line.
reproducible with LO 18.104.22.168 (Win7 Home, 64bit)
I have retested in LibreOffice v22.214.171.124 on Windows XP and behavior is the same as in "Comment 2" section "LibreOffice v126.96.36.199 on Ubuntu 12.04". So problem from version 188.8.131.52 to 184.108.40.206 got from bad to worse.
I can't reproduce this neither in 3.6.6 nor 4.0.1 (Linux), in a Slovenian locale all numbers are numbers after pasting.
Do you get the same behavior if you manually enter 1.000.000 instead of pasting?
@Eike Rathke, yes I get the same problem typing in 1.000.000.
By the way, how did you check "all numbers are numbers after pasting"? If you have pasted data in field A1, can you type in a formula in B1 like =A1+1 Do you get correct value in B1 or getting an error in cell: #VALUE!
I did another test saved the bellow values in text file:
and in LibreOffice Calc from menu File | Open and import the text file (see attachment text_import.png).
All the values imported from text file imported correctly!!! In Calc in column B I have added formula =A1+1 and copied it to check if the values are REALY numbers.
Created attachment 77409 [details]
As date separator and group separator are both '.' dot in the Slovenian sl-SI locale and one of the date patterns is "D.M." (I probably failed to reset the patterns to the locale's default in my earlier attempt to reproduce this), I presume that this is related to bug 80166 and recently fixed. It appears to be fixed in my build. Please check in one of the versions mentioned there.
*** This bug has been marked as a duplicate of bug 80166 ***
Short answer: PROBLEM SOLVED with this fix.
Detailed answer on test I performed:
I did two tests on two versions of LibreOffice:
A. LibreOffice 220.127.116.11 on Windows 7 (before fix was applied).
B. LibreOffice 18.104.22.168 on Windows 7 (after fix was applied).
Copy bellow numbers to Notepad to be sure any special character is removed and then copy to LibreOffice.
Save bellow numbers to Notepad and save the file as mytest.txt
Test 1 and Test 2 using system A:
First two numbers are correctly pasted as numbers so they become 1000, all other numbers become text. So problem exists.
Test 1 and Test 2 using system B:
All numbers are correctly pasted and opened. So problem is solved.
Until now I was forced to do the Find-Replace and search for dot and replace with empty string, this was time consuming and annoying. Thanks a million for this fix. This is one single fix most important fix that will save a lot of my time.
Great, thanks for verifying.