https://bugs.freedesktop.org/show_bug.cgi?id=72459
Priority: medium
Bug ID: 72459
Assignee: [email protected]
Summary: VIEWING: chart:include-hidden-cells attribute appears
to be ignored when references are external
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: Inherited From OOo
Component: Chart
Product: LibreOffice
Created attachment 90437
--> https://bugs.freedesktop.org/attachment.cgi?id=90437&action=edit
Two ODS with charts showing references to hidden cell data (local and
external).
Problem description:
There appears to be a difference in how values in hidden cells are included in
a chart, depending on whether the reference (data) is local or external. This
may not be a bug but rather an artifact of either the ODF specification or the
manner in which the ODF specification is implemented in LO. I am report this as
a bug to at least get this matter clarified. ODF v1.2, Part 1, 20.25 states:
> The chart:include-hidden-cells attribute specifies whether data points in
> hidden cells are
> plotted in a chart. The default is to plot data points in hidden cells.
> This attribute can be used within styles that are applied to a
> <chart:plot-area> element.
> The defined values for the chart:include-hidden-cells attribute are:
> ● false: data points in hidden cells are not plotted in a chart.
> ● true: data points in hidden cells are plotted in a chart.
The first thing to note is "the default is to plot data points in hidden cells"
because it would seem that this is not what LO implements, at least from what
is contained in this report.
The attached pair of example spreadsheets were created under Ubuntu 10.04
x86_64 using v4.1.3.2 Build ID: 70feb7d99726f064edab4605a8ab840c50ec57a and are
fairly self-explanatory:
- hidden_cells_local.ods: three sheets (complete, column, row) showing how data
is suppressed from appearing in a chart if either a column or row is hidden.
- hidden_cells_external.ods: one sheet with three charts referencing the data
ranges (one sheet per chart) in the first file.
The local file suppresses display of data as expected. The external file
displays all data in each chart regardless of the state of cell hiding. The
code in hidden_cells_external.ods/Object\ 2/content.xml (the chart referencing
the column sheet) reveals:
> <style:style style:name="ch4" style:family="chart">
> <style:chart-properties chart:include-hidden-cells="false" ... >
> </style:style>
> ...
> <chart:plot-area chart:style-name="ch4"
> table:cell-range-address="'file:///home/oweng/doc/hidden_cells_local.ods'#column.A1:'file:///home/oweng/doc/hidden_cells_local.ods'#column.C6"
> ... >
The only significant difference between the above and that for
hidden_cells_local.ods/Object\ 3/content.xml (the bar chart in the column
sheet) appears to be the table:cell-range-address:
> <style:style style:name="ch3" style:family="chart">
> <style:chart-properties chart:include-hidden-cells="false" ... >
> </style:style>
> ...
> <chart:plot-area chart:style-name="ch3"
> table:cell-range-address="column.A1:column.C6" ... >
By way of further testing I have opened both attached sheets under the same
operating system using:
- v3.3.0.4 OOO330m19 Build: 6
- v3.4.6.2 OOO340m1 Build: 602
- v3.5.7.2 Build ID: 3215f89-f603614-ab984f2-7348103-1225a5b
- v3.6.7.2 Build ID: e183d5b
- v4.0.6.2 Build ID: 2e2573268451a50806fcd60ae2d9fe01dd0ce24
In all cases the display of hidden cell data is suppressed from appearing in
the corresponding chart in the local file and revealed in the external file. If
this is a problem, it would appear to be Inherited From OOo, so I have set the
version as such.
Steps to reproduce:
1. Open hidden_cells_external.ods (attached).
2. Respond "Yes" when asked to update external references.
3. Note second and third chart (column/row in title) display all data i.e.,
identical display to first chart.
Current behavior:
References to external data in a chart appear to ignore the value of the
chart:include-hidden-cells attribute.
Expected behavior:
The value of the chart:include-hidden-cells attribute is taken into
consideration, even when references are external.
Operating System: Ubuntu
Version: Inherited From OOo
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
