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:all-tabpanel ]

Michael Stahl updated OFFICE-3860:
----------------------------------

    Proposal: 
I. Schema changes:

Add:
<define name="number-scientific-number-attlist" combine="interleave">
    <optional>
        <attribute name="number:exponent-sign" a:defaultValue="true">
            <ref name="boolean"/>
        </attribute>
    </optional>
</define>

Add:
<define name="common-min-decimal-digits-attlist">
    <optional>
        <attribute name="number:min-decimal-digits">
            <ref name="integer"/>
        </attribute>
    </optional>
</define>

Add new "common-min-decimal-digits-attlist" in these 2 places:
<define name="number-number">
    <element name="number:number">
        <ref name="common-min-decimal-digits-attlist"/>

<define name="number-scientific-number">
    <element name="number:scientific-number">
        <ref name="common-min-decimal-digits-attlist"/>

II.
Section 16.27.3 <number:number>

Add to the generated "The <number:number> element has the following attributes:"

    number:min-decimal-digits 19.xxy

III.
Section 16.27.5 <number:scientific-number>

Add to the generated "The <number:scientific-number> element has the following attributes":

    number:min-decimal-digits 19.xxy and number:exponent-sign 19.xxz

IV. Add new section:
Section 19.xxy number:min-decimal-digits

Section 19.xxy.1 General
The number:min-decimal-digits attribute specifies the minimum number of digits in the decimal part.

Section 19.xxy.2 <number:number>
If the number:min-decimal-digits attribute is not specified, it is set to:
* 0 if number:decimal-replacement attribute is equal to empty string
* the value of number:decimal-places attribute in other cases.

The number:min-decimal-digits attribute is usable with the following element: <number:number> 16.27.3.
The number:min-decimal-digits attribute has the data type integer 18.2.

Section 19.xxy.3 <number:scientific-number>
If the number:min-decimal-digits attribute is not specified, it is set to the value of number:decimal-places attribute.

The number:min-decimal-digits attribute is usable with the following element: <number:scientific-number> 16.27.5.
The number:min-decimal-digits attribute has the data type integer 18.2.

V. Add new section:
Section 19.xxz number:exponent-sign

The number:exponent-sign attribute specifies whether the sign of the exponent for a scientific number is always displayed.
The defined values for the number:exponent-sign attribute are:
* false: the exponent sign is displayed only for negative value of exponent, otherwise it is not displayed.
* true: the exponent sign is always displayed whatever the value of exponent.

The default value for this attribute is true.

The number:exponent-sign attribute is usable with the following element: <number:scientific-number> 16.27.5.
The number:exponent-sign attribute has the data type boolean 18.3.3.

Copied Laurent Balland-Poirier's proposal from the attached ODT file to Proposal field.


> 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]