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

# office message

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

Subject: [OASIS Issue Tracker] (OFFICE-3936) logarithmic scale misses information about basis

• From: OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>
• To: office@lists.oasis-open.org
• Date: Mon, 16 Oct 2017 20:37:54 +0000 (UTC)

```    [ https://issues.oasis-open.org/browse/OFFICE-3936?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=67859#comment-67859 ]

Andreas Guelzow commented on OFFICE-3936:
-----------------------------------------

For the minor ticks it seems that Libreoffice and Excel divide the range between two consecutive major ticks into intervals of equal value ranges while Gnumeric divides that range into equal distances.
My suggestion for 20.28 is:
20.28 The chart:interval-minor-divisor attribute specifies a divisor for the chart:interval-major value, the division of which determines the minor interval: If a and b are the locations of consecutive major ticks (see 20.27) and m is the value of chart:interval-minor-divisor then the minor ticks are placed at a + (b-a)/m * k with k = 1,2, ..., (m-1).

I believe that these are the tick locations of LibreOffice and Excel. To match Gnumeric's behaviour one would need to have:

If the axis is linear and the value of this attribute is m, minor ticks are placed at  a + (b-a)/m * k with k = 1,2, ..., (m-1) where a and b are consecutive major ticks (see 20.27)
If the axis is logarithmic and the value of this attribute is m, minor ticks are placed at  10^(log_10(a)+(log_10(b)-log_10(a))/m * k) with  k = 1,2, ..., (m-1) where a and b are consecutive major ticks (see 20.27)

> logarithmic scale misses information about basis
> ------------------------------------------------
>
>                 Key: OFFICE-3936
>                 URL: https://issues.oasis-open.org/browse/OFFICE-3936
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Improvement
>          Components: Chart
>    Affects Versions: ODF 1.2
>            Reporter: Regina Henschel
>             Fix For: ODF 1.3
>
>
> http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part1.html#property-chart_interval-major
> Although the basis 10 is widely used, others a common too, e.g basis 2 for audiogram.
> This proposal adds not only the basis but additional details to the description of chart:interval-major and chart:interval-minor-division.
> Specifications are not only read by developers but by authors of guides and tutorials too. For those the mathematic impact of the attributes values might be not obvious.
> Formulas in the proposal are written StarMath.
> I think, that logarithmic scale should only be allowed for a value-axis, but have not included that in this proposal.

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