Calc/Features/Automatic decimal place adjustment

From Apache OpenOffice Wiki
< Calc‎ | Features
Revision as of 03:00, 3 February 2010 by Kohei (Talk | contribs)

Jump to: navigation, search

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

New check box to control automatic decimal adjustment behavior.

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 with

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 the available column width.

Migration

N/A

Configuration

N/A

File Format

N/A

Open Issues

Not yet determined.

Personal tools