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 Actual results: 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. Expected results: 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. LibreOffice details: Attached screenshot is from: Version: 7.0.0.3 (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 Calc: CL 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