[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] (OFFICE-3860) Extend specification of number of decimal digits in number formatting
[ https://issues.oasis-open.org/browse/OFFICE-3860?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=59586#comment-59586 ] Michael Stahl commented on OFFICE-3860: --------------------------------------- for easier reference, here's the "rationale" and "impacts" from Laurent's attachment: 2 Rationale 2.1. Use cases: Decimal number can have a variable number of decimal digits, if number:decimal-replacement attribute is set to empty string. Number of decimal digits may vary from 0 to number:decimal-places attribute value. In some case, it might be useful to consider a minimal number of decimal digits higher than 0. For instance, marks rounded to a quarter of point, should be displayed as: 10.0 8.5 7.75; i.e. at least one decimal digit, up to 2 decimal digits. Scientific numbers need some extra attributes to be more flexible: sign of the exponent may be ignored if exponent is positive, i.e. 1,234 should be displayed as 1.234E3 and not 1.234E+3. Like for decimal numbers, scientific numbers should have a variable length of their decimal part, i.e. 1,000 and 1,234 should be respectively displayed as 1E3 and 1.234E3 with the same format. Adding these attributes will improve MS-Office compatibility. These additions are independent and could be considered apart. 2.2. Alternatives considered: No workaround. 4 Impacts 4.1. Conformance: No conformance issue known. 4.2. Backwards compatibility: This addition will not cause a backward compatibility issue since they are new attributes. 4.3. Accessibility impact: There is no impact on accessibility. > Extend specification of number of decimal digits in number formatting > --------------------------------------------------------------------- > > Key: OFFICE-3860 > URL: https://issues.oasis-open.org/browse/OFFICE-3860 > Project: OASIS Open Document Format for Office Applications (OpenDocument) TC > Issue Type: New Feature > Components: Formatting Properties > Affects Versions: ODF 1.2 > Reporter: Andreas Guelzow > Assignee: Andreas Guelzow > Priority: Minor > Fix For: ODF 1.3 > > > This relates to the comment received in https://lists.oasis-open.org/archives/office-comment/201407/msg00008.html > Currently the number:number element use a single attribute number:decimal-places to specify the number of decimal digits to be used. This means that formats such as "0.00#" (specified here using the Excel number format syntax) cannot be translated into ODF without the use of conditional formatting. > I would propose to add an attribute to allow for formats of this type. -- This message was sent by Atlassian JIRA (v6.2.2#6258)
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]