Created attachment 168406 [details]
attachment #167999 [details] in Word 2013 and Writer 7.0
For a chart category axis MSO offers a setting “Interval between labels” which allows to show only every nth labels, if there are many and the user only needs some of those.
Chart does not have a similar setting, so it would be a nice addition for interoperability to support such a feature in ODF (and later in OOXML import-export + UI) too.
Steps to reproduce:
1. Open attachment #167999 [details] in Word and Writer
X axis has more labels displayed than Word. The X axis settings in Word has “Interval between labels” set to 2, while there is no similar feature in the LO UI.
This bug is only about implementing a similar LabelInterval property in ODF: automatic (meaning 1) or custom value.
My Word 2013 seems to limit the custom value to 255 so for interoperability the 1-255 range would make sense in ODF.
Implementing OOXML support / UI would be topic for subsequent bugs.
Attached screenshot is from:
Version: 220.127.116.11 (x64)
Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
There is no such feature in master either.
How does Gnumeric solves the problem? For example what does Gnumeric if it gets a file, where "Specify Interval Unit" (Excel UI) is set? Has Gnumeric such option? [There exists no Windows version of current Gnumeric, so I cannot easily test it myself.]
Oops, wrong link to source file: attachment #93843 [details] should be it.
Created attachment 168743 [details]
Simple example file from Excel 2013
Created attachment 168744 [details]
The example file in Gnumeric
I have a slightly old version in Ubuntu 18.04: 1.12.35 .
This did not yet support this feature.
Created attachment 168745 [details]
The simple example in Excel
Seems straightforward -> NEW