To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=46511
------- Additional comments from [EMAIL PROTECTED] Fri Nov 25 14:07:19 -0800 2005 ------- I've been bitten by this one. Playing with Excel XP, I notice that it will widen the column to make room for more decimals if it needs them. If I then narrow the column, it will flip to scientific to indicate the number, round if needed, and not go to '##' until the column is too narrow to show any approximation of the number. This is particularly nasty when the number is small. Enter .001, and OO will display '0', which is just wrong, a relative error of 100%, an outright bug IMO. Display '#'s if the number can't be displayed with accuracy and at least the user knows something is amiss (very large numbers do this), but don't silently round away the entire number and show zero. Since this potentially effects every numeric cell with default formatting in imported spreadsheets, perhaps this merits a "ms_compatibility" keyword? --------------------------------------------------------------------- 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]