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] Commented: (OFFICE-3695)number:max-denominator-digits attribute to number:fraction



    [ http://tools.oasis-open.org/issues/browse/OFFICE-3695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=25943#action_25943 ] 

Andreas Guelzow  commented on OFFICE-3695:
------------------------------------------

Gnumeric has exactly the same options as Excel. This is exactly what this proposal is intended to enable to be stored in ODF files. 

Is there any implementation that currently has something like a reduction flag? It sounds like a good idea to me but including such a flag as long as there is no implementation that would be using it is (imho) questionable. Your comment outlines what Gnumeric and Excel offer (Gnumeric also allows many other fraction formats via its custom formats, I suspect Excel does too), LoCalc 3.3.2 seems to have only 2 fraction formats to choose from:
- single denominator digit
- something that looks like 2 denominator digts but 0.1 is shown as "0" while 0.01 is shown as "1/99" 

> number:max-denominator-digits attribute to number:fraction
> ----------------------------------------------------------
>
>                 Key: OFFICE-3695
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-3695
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: New Feature
>          Components: Formatting Properties
>    Affects Versions: ODF 1.2 CD 07
>            Reporter: Andreas Guelzow 
>            Assignee: Andreas Guelzow 
>             Fix For: ODF 1.3 CSD 01
>
>
> In ODF 1.2 the <number:fraction> element has the attribute number:denominator-
> value. If this attribute is not present, a denominator that is appropriate for
> displaying the number is used. Clearly what is considered appropriate will be implementation dependent/defined. For example LibreOffice considers the appropriate denominator for of:=PI() to be 7 although a denominator of 113 would create a much closer approximation. From a user perspective if formatting a number as a fraction usually the size of the denominator is important even if the exact chosen denominator does not matter. Some implementations, for example Gnumeric, permit the user to determine a maximum number of digits to be used in the choice of the denominator. Currently Gnumeric stores that information in a foreign element: gnm:max-denominator-digits. In the interest of interoperability it would be desirable to include a similar attribute in the ODF1.3 standard.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        


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