To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76515 Issue #|76515 Summary|Decimal places should be "undefined" for default view. Component|Spreadsheet Version|OOo 2.2 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|ftack
------- Additional comments from [EMAIL PROTECTED] Thu Apr 19 12:32:22 +0000 2007 ------- Opposite to other spreadsheets, calculate requires a fixed number of decimal places for the "general" number format. The number of decimal places is controlled using tools - Options - OOo.Calc - Calculate, "Decimal places". As a result, numbers with a large number of digits (depending on the current cell width) will more rapidly be represented as "##" than in other spreadsheets. For example, with a decimal setting of 3, following number 12345.6789 might be displayed as ## in Calc (depending on the column width) while under the same circumstances, competing spreadsheets would just display less decimals, e.g. 12345.6 and only display ## if also the integer part doesn't fit in the cell anymore. The latter approach allows for greater flexibility in the default display of numbers. In Calc, a user has to recur more rapidly to adapting the cell width (which will affect the whole column) or changing the "Decimal places" option (which will affect the whole spreadsheet). Thus, I would suggest that the "Decimal places" option in "Calculate" dissappears, and that instead Calc handles the default display in a more advanced and flexible way, i.e. * Show the integer part and as many decimals that fit * Even better yet for numbers that won't fit: switch to exponential format --------------------------------------------------------------------- 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]