New Chart Option on Hidden Cells


Proposal owner: Kohei Yoshida, Ingrid Halama

Proposal short name: Additional chart option on handling of hidden cells in a spreadsheet document.


Use cases

Charts can visualize data from cell ranges in a spreadsheet. While in a spreadsheet the user can hide rows or columns, it is unclear whether or not data from hidden cells should be displayed within the chart. Some users want data in hidden cells to be displayed while others prefer them not being displayed. To solve this conflict, the proposed change will make this behavior configurable.

Supporting this is also important for interoperability with Excel.

Alternatives considered

No alternatives are considered for this feature.

Requested changes to the ODF Standard

Text changes/additions Section 16.16 <chart:chart-properties> (change)

The <style:chart-properties> element may have the following attributes: ... chart:include-hidden-cells 18.x, ...

Text changes/additions Section 18.x chart:include-hidden-cells (new section)

The chart:include-hidden-cells attribute specifies whether or not data points in hidden cells are plotted in a chart.

This attribute can be used within styles that are applied to a <chart:plot-area> element.

Schema changes/additions

<define name="style-chart-properties-attlist" combine="interleave">
        <attribute name="chart:include-hidden-cells" a:defaultValue="true">
            <ref name="boolean"/>



If an application doesn't support the chart:include-hidden-cells attribute, it should plot data from hidden cells in all cases.

Backwards compatibility

This addition will not cause a backward compatibility issue since it is a new attribute.

Accessibility impact

There is no impact on accessibility.

Workflow (to be filled in by TC Chairs)

Category: CategoryIntegratedProposal

Date Proposal initially made:22 August 2008

Dates Proposal discussed on TC calls: 2008-09-29

Date vote is requested:

Date vote is held: 13 October 2008

Results of vote: Approved

Version in which this proposal has been integrated: ODF 1.2 draft 8

New_Chart_Option_on_Hidden_Cells (last edited 2009-08-12 18:04:30 by localhost)