Menu
▾
▴
#113 XLSX Data range info for Scatter , Dough ,nut , pie charts
R5248
The data range information get lost for some kinds of charts:
Scatter , Dough ,nut and Pie Chart
The source date contained in the Tables located on the sheets is
represented in different ways in the charts.
In the original file the connection between charts and Tables is accessed
directly. Changes in the table result automatically in changes in the
chart.
After conversion to ODS: all information is hardwired via Chart Data
Tables. As a consequence, even if the table is changed, the chart remains
the same.
The open Office converter uses (Data Point Series) Data Ranges instead. The
direct connection between source data and charts is retained.
After roundtrip the source data still is independent of the charts (even
though some kind of information on data ranges seems to be preserved)
It is already implemented for other charts. But the functionality is not implemented for Scatter Charts , Dough
nut Chart and Pie
