To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104236 Issue #|104236 Summary|format number does not handle multiple decimals Component|Spreadsheet Version|OOo 3.1 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|sandreas41
------- Additional comments from [email protected] Fri Aug 14 18:15:28 +0000 2009 ------- >From a spreadsheet created before 3.0, I have a column formatted as 0.0.0.0 for ip addresses. I import access logs in csv format, and paste-special without formats into that spreadsheet. I have become aware of this bug becase Browser version numbers have changed from 0.0 format to 0.0.0 Now in 3.1 if I format a column or cell as 0.0.0 and enter 1.2.3 it shows as 123.0.0 and changes to 123 in the formula/edit bar field. When I look back at the ip address column, which STILL WORKS in 3.1, ( I enter 1.2.3.4 and it shows as 1.2.3.4) When I look at Format Cells...Number, the Format Code now shows as 000.000000000".." and the Format listbox shows the entry as -1234.123456789. and the Preview Field shows as 1.2.3.4 But, if I try to format a New cell with the format code of 0.0.0.0 and enter 1.2.3.4 it shows as 1234.0.0.0 I open Format Cells... and see: The format code still shows as 0.0.0.0 The Format listbox shows as -1234.1.2.3 and the Preview Field shows as 1234.0.0.0 If I try to duplicate the weird format code that still works by entering 000.000000000".." then enter 1.2.3.4 it becomes 1234.000000000. But I do see that formatting it as General does recognize 1.2.3.4 as 1.2.3.4 but that doesn't help fix 0.0.0 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
