Corrupted datasource of series in chart
Posted: Fri May 18, 2018 8:30 am
Hello
I made template with chart.
Its datasource of series are:
I opened this template by XLSRW 6.036 and wrote null to the cell A1.
Saved result has corrupted datasource of series. It cause translation name of sheet containing spaces.
If I open this result at same excel where I made template (excel 2007) I get "freeze" picture of chart (the same as above).
If I open this result at excel 2016 I get "freeze" picture of chart with some differences (title, name of series).
Notice 23/5/2018:
If I add missing characters " ' " to the addresses of series the chart starts work again.
The template and result are at http://www.genet.cz/kohout/xlsrw/201805 ... xample.zip to download.
Josef Kohout
I made template with chart.
Its datasource of series are:
I opened this template by XLSRW 6.036 and wrote null to the cell A1.
Saved result has corrupted datasource of series. It cause translation name of sheet containing spaces.
If I open this result at same excel where I made template (excel 2007) I get "freeze" picture of chart (the same as above).
If I open this result at excel 2016 I get "freeze" picture of chart with some differences (title, name of series).
Notice 23/5/2018:
If I add missing characters " ' " to the addresses of series the chart starts work again.
The template and result are at http://www.genet.cz/kohout/xlsrw/201805 ... xample.zip to download.
Josef Kohout
