Bug 113233 - Add an attribute with reference value for grid and ticks.
Summary: Add an attribute with reference value for grid and ticks.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected)
Hardware: x86 (IA32) All
: medium enhancement
Assignee: Not Assigned
URL: https://issues.oasis-open.org/browse/...
Depends on:
Blocks: Chart-Enhancements
  Show dependency treegraph
Reported: 2017-10-18 18:17 UTC by Regina Henschel
Modified: 2019-03-19 13:48 UTC (History)
0 users

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Regina Henschel 2017-10-18 18:17:16 UTC
Currently the position of ticks and thereby of the grid lines are calculated starting from the minimum of the axis. For example, if you set chart:minimum="-2.5" and chart:interval-major="2" you get ticks at -2.5, -0.5, 1.5, 3.5.
But you likely want to get ticks at -2, 0, 2, 4.

The situation is worth, when you use logarithmic scaling. Here you need a lot of mathematic for to get e.g. the ticks at 100, 200, 400, 800, 1600 and an axis start somewhere between 50 and 100.

Gnumeric has no special setting, but uses 0 as position for linear axes and 1 as position for logarithmic axes. That does not mean, that these values need to be included in the actual interval of the axis.

Excel has no special setting, but starts at minimum too.

I propose to introduce an attribute chart:tick-marks-ref-value, with values "start", "end" or any double value. The major ticks are then positioned in a way, that one major tick is on this position. The given double value need not be inside the chart:minimum - chart:maximum range, but determines the entire grid.

The values "start" and "end" are needed to get the current behavior, especially when auto-scaling is on.

Having such attribute would ease the use of Calc for scientific and educational use cases.
Comment 1 Buovjaga 2017-11-07 15:05:31 UTC
Setting to NEW.. for science!
Comment 2 Regina Henschel 2019-03-19 13:48:43 UTC
ODF will be extended (see URL) with attributes chart:major-origin attribute and chart:minor-logarithmic, likely in ODF 1.4.

When implementing such feature, consider the new ODF attributes.