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=59910#comment-59910 ] 

Andreas Guelzow  commented on OFFICE-3860:
------------------------------------------

I am not sure about the interaction between number:min-decimal-digits and number:decimal-digits. We want to be able to specify what in "Excel" would be 0.000##. So one would want at least 3 decimal places shown and at most 5 with following 0s omitted (as long as we at least have 3 decimals).

IN this case should number:min-decimal-digits=3 and number:decimal-digits=5? So do we have a restriction number:min-decimal-digits<=number:decimal-digits? If we do we should spell it out.

Perhaps we really mean something like number:optional-decimal-digits=2 and number:decimal-digits=3 for 0.000##??

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