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, 2 Oct 2017 23:25:54 +0000 (UTC)

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

Regina Henschel updated OFFICE-3936:
------------------------------------

Proposal:
20.27
Add "for details see 20.28." to the first sentence. The wording would then be
The chart:interval-major attribute specifies major intervals on an axis 11.8, for details see 20.28.

20.28
Add the following text before the last sentence.

Let a be the value at a major grid line and b the value at the next major grid line and m the value of the attribute chart:interval-major.
For an axis with proportional scale it is m = b - a, for an axis with logarithmic scale it is m = log_10(b) - log_10(a) = log_10(b over a).
The distance D, measured e.g. in centimeter, between a pair of two adjacent major grid lines is the same for all such pairs.

Let n be the value of the attribute chart:interval-minor-divisor, and x_k the value at the k-th minor grid line with a < x_k < b.

Then for both kind of scale it is x_k = a + {{b - a} over n} cdot k .
But the distance d, measured e.g. in centimeter, from the major grid line at value a to the k-th minor grid is different.
For an axis with proportional scale it is
d = D cdot {k over n} = {D over m} cdot (x_k-a)
For an axis with logarithmic scale it is
d = {D over m} cdot (log_10(x_k) - log_10(a))

was:
20.27
Add "for details see 20.28." to the first sentence. The wording would then be
The chart:interval-major attribute specifies major intervals on an axis 11.8, for details see 20.28.

20.28
Add the following text before the last sentence.

Let a be the value at a major grid line and b the value at the next major grid line and m the value of the attribute chart:interval-major.
For an axis with proportional scale it is m = b - a, for an axis with logarithmic scale it is m = log_10(b) - log_10(a) = log_10(b over a).
The distance D, measured e.g. in centimeter, between a pair of two adjacent major grid lines is the same for all such pairs.

Let n be the value of the attribute chart:interval-minor-divisor, and x_k the value at the k-th minor grid line with a < x_k < b.

Then for both kind of scale it is x_k = a + {{b - a} over n} cdot k .
But the distance d, measured e.g. in centimeter, from the major grid line at value a to the k-th minor grid is different.
For an axis with proportional scale it is
d = D cdot {k over n} = {D over m} cdot (x_k-a)
For an axis with logarithmic scale it is
d = {D over {log_10(m)}} cdot (log_10(x_k) - log_10(a))

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