[Libreoffice-bugs] [Bug 60403] FORMATTING: Number 1.000.000 paste in Calc like it is a text
https://bugs.freedesktop.org/show_bug.cgi?id=60403 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED --- Comment #11 from Eike Rathke --- Great, thanks for verifying. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 60403] FORMATTING: Number 1.000.000 paste in Calc like it is a text
https://bugs.freedesktop.org/show_bug.cgi?id=60403 --- Comment #10 from grofaty --- Short answer: PROBLEM SOLVED with this fix. Detailed answer on test I performed: I did two tests on two versions of LibreOffice: A. LibreOffice 4.2.5.2 on Windows 7 (before fix was applied). B. LibreOffice 4.2.6.1 on Windows 7 (after fix was applied). Test 1: Copy bellow numbers to Notepad to be sure any special character is removed and then copy to LibreOffice. Test 2: Save bellow numbers to Notepad and save the file as mytest.txt Numbers: 1.000 1.000,00 1.000.000 1.000.000,00 1.000.000.000 1.000.000.000,00 1.000.000.000.000 1.000.000.000.000,00 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. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 60403] FORMATTING: Number 1.000.000 paste in Calc like it is a text
https://bugs.freedesktop.org/show_bug.cgi?id=60403 Eike Rathke changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |DUPLICATE --- Comment #9 from Eike Rathke --- 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 *** -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 60403] FORMATTING: Number 1.000.000 paste in Calc like it is a text
https://bugs.freedesktop.org/show_bug.cgi?id=60403 Jorendc changed: What|Removed |Added Attachment #74327|application/octet-stream|application/vnd.oasis.opend mime type||ocument.spreadsheet -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 60403] FORMATTING: Number 1.000.000 paste in Calc like it is a text
https://bugs.freedesktop.org/show_bug.cgi?id=60403 --- Comment #8 from grofaty --- Created attachment 77409 --> https://bugs.freedesktop.org/attachment.cgi?id=77409&action=edit text_import.png -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 60403] FORMATTING: Number 1.000.000 paste in Calc like it is a text
https://bugs.freedesktop.org/show_bug.cgi?id=60403 --- Comment #7 from grofaty --- I did another test saved the bellow values in text file: 1.000 1.000,00 1.000.000 1.000.000,00 1.000.000.000 1.000.000.000,00 1.000.000.000.000 1.000.000.000.000,00 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. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 60403] FORMATTING: Number 1.000.000 paste in Calc like it is a text
https://bugs.freedesktop.org/show_bug.cgi?id=60403 --- Comment #6 from grofaty --- @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! -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 60403] FORMATTING: Number 1.000.000 paste in Calc like it is a text
https://bugs.freedesktop.org/show_bug.cgi?id=60403 --- Comment #5 from Eike Rathke --- 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. @grofaty: Do you get the same behavior if you manually enter 1.000.000 instead of pasting? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 60403] FORMATTING: Number 1.000.000 paste in Calc like it is a text
https://bugs.freedesktop.org/show_bug.cgi?id=60403 --- Comment #4 from grofaty --- I have retested in LibreOffice v4.0.1.2 on Windows XP and behavior is the same as in "Comment 2" section "LibreOffice v4.0.0.3 on Ubuntu 12.04". So problem from version 3.6.5.2 to 4.0.1.2 got from bad to worse. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 60403] FORMATTING: Number 1.000.000 paste in Calc like it is a text
https://bugs.freedesktop.org/show_bug.cgi?id=60403 A changed: What|Removed |Added Status|UNCONFIRMED |NEW CC||er...@redhat.com Ever confirmed|0 |1 --- Comment #3 from A --- reproducible with LO 4.0.1.2 (Win7 Home, 64bit) -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 60403] FORMATTING: Number 1.000.000 paste in Calc like it is a text
https://bugs.freedesktop.org/show_bug.cgi?id=60403 --- Comment #2 from grofaty --- I have tested the same problem on my Ubuntu 12.04 test computer. === LibreOffice v3.6.0.2 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 3.6.5.3 on Windows XP. So this looks like an old problem appearing in v3.6.0/Ubuntu and v3.6.5/Windows. === LibreOffice v4.0.0.3 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. The numbers: 1.000 1.000,00 are copied fine - after coping becomes number. The numbers: 1.000.000 1.000.000,00 1.000.000.000 1.000.000.000,00 1.000.000.000.000 1.000.000.000.000,00 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. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 60403] FORMATTING: Number 1.000.000 paste in Calc like it is a text
https://bugs.freedesktop.org/show_bug.cgi?id=60403 --- Comment #1 from grofaty --- Created attachment 74327 --> https://bugs.freedesktop.org/attachment.cgi?id=74327&action=edit Sample calc file after pasting numbers one by one -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs