Difference between revisions of "Calc/Features/Automatic decimal place adjustment"
(→Options dialog) |
(→Options dialog) |
||
| Line 63: | Line 63: | ||
=== Options dialog === | === Options dialog === | ||
In the '''Options''' dialog, the '''Calculate''' page will have a new check box labeled '''Limit decimals for general number format'''. When this check box is checked, you can specify the maximum number of decimal places allowed for cells with General number format. When this check box is ''not'' checked, cells with General number format will use as many decimal places as the column width allows. By default, this option is ''not'' checked. | In the '''Options''' dialog, the '''Calculate''' page will have a new check box labeled '''Limit decimals for general number format'''. When this check box is checked, you can specify the maximum number of decimal places allowed for cells with General number format. When this check box is ''not'' checked, cells with General number format will use as many decimal places as the column width allows. By default, this option is ''not'' checked. | ||
| − | [[Image:Calc_Automatic_decimal_options.png|thumb|500px | + | |
| + | [[Image:Calc_Automatic_decimal_options.png|thumb|500px|New check box to control automatic decimal adjustment behavior.]] | ||
=== Adjusting decimal places by column width === | === Adjusting decimal places by column width === | ||
Revision as of 16:54, 3 February 2010
Contents
Automatic decimal place adjustment
| Specification Status | |
| Author | Kohei Yoshida |
| Last Change | See wiki history |
| Status | In progress in CWS koheiautodecimal |
Abstract
Cells containing either numeric value or formula whose result is numeric are subject to automatic adjustment of decimal places based on the available column width. The automatic decimal place adjustment takes place only when their number format is General.
References
| Reference Document | Check | Location (URL) |
| Issue ID (required) | available | Issue 26826 Issue 46511 |
| Test case specification (required) | n/a |
Contacts
| Role | Name | E-Mail Address |
| Developer | Kohei Yoshida | kyoshida@novell.com |
| Quality Assurance | undetermined | |
| Documentation | up for grabs! | |
| User Experience | up for grabs! |
Detailed Specification
Options dialog
In the Options dialog, the Calculate page will have a new check box labeled Limit decimals for general number format. When this check box is checked, you can specify the maximum number of decimal places allowed for cells with General number format. When this check box is not checked, cells with General number format will use as many decimal places as the column width allows. By default, this option is not checked.
Adjusting decimal places by column width
When the number format for a cell is General and its displayed content is numeric, it is subject to automatic decimal place adjustment based on available column width. The adjustment is performed in the following fashion.
First, Calc tries to fit the displayed number within the cell width by reducing the number of decimal places. If the number doesn't fit even after all the decimal places have been exhausted, it then switches to scientific notation and continue adjusting decimal places in that notation. If the number still doesn't fit even with the scientific notation, it displays '###' in place of the original value.
Migration
N/A
Configuration
N/A
File Format
N/A
Open Issues
Not yet determined.
