OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[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

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]