https://bugs.freedesktop.org/show_bug.cgi?id=60403
Priority: medium
Bug ID: 60403
Assignee: [email protected]
Summary: FORMATTING: Number 1.000.000 paste in Calc like it is
a text
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 3.6.5.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 74326
--> https://bugs.freedesktop.org/attachment.cgi?id=74326&action=edit
Print screen of Language settings and Format cells
Problem description:
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):
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
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.
Current behavior:
Any number with two dots does not paste correctly.
Expected behavior:
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: 3.6.5.2 release
--
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
