Bug 139149 - EDITING Chart category axis does not have “Interval between labels” setting
Summary: EDITING Chart category axis does not have “Interval between labels” setting
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart ODF-spec
  Show dependency treegraph
 
Reported: 2020-12-22 10:00 UTC by NISZ LibreOffice Team
Modified: 2022-11-28 11:51 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
attachment #167999 in Word 2013 and Writer 7.0 (124.29 KB, image/png)
2020-12-22 10:00 UTC, NISZ LibreOffice Team
Details
Simple example file from Excel 2013 (13.18 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-01-07 12:22 UTC, Gabor Kelemen (allotropia)
Details
The example file in Gnumeric (149.05 KB, image/png)
2021-01-07 12:24 UTC, Gabor Kelemen (allotropia)
Details
The simple example in Excel (68.22 KB, image/png)
2021-01-07 12:47 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2020-12-22 10:00:54 UTC
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.
Comment 1 Regina Henschel 2020-12-22 13:57:17 UTC
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.]
Comment 2 Gabor Kelemen (allotropia) 2021-01-07 12:09:56 UTC
Oops, wrong link to source file: attachment #93843 [details] should be it.
Comment 3 Gabor Kelemen (allotropia) 2021-01-07 12:22:53 UTC
Created attachment 168743 [details]
Simple example file from Excel 2013
Comment 4 Gabor Kelemen (allotropia) 2021-01-07 12:24:15 UTC
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.
Comment 5 NISZ LibreOffice Team 2021-01-07 12:47:27 UTC
Created attachment 168745 [details]
The simple example in Excel
Comment 6 Buovjaga 2021-11-26 14:38:44 UTC
Seems straightforward -> NEW