Corrupted datasource of series in chart

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
jsfkcz
Posts: 29
Joined: Thu Sep 11, 2014 8:29 am

Corrupted datasource of series in chart

Post by jsfkcz »

Hello
I made template with chart.
Image
Its datasource of series are:
Image

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.
Image

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).
Image

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
jsfkcz
Posts: 29
Joined: Thu Sep 11, 2014 8:29 am

Re: Corrupted datasource of series in chart

Post by jsfkcz »

Notice 23/5/2018:
If I add missing characters " ' " to the addresses of series the chart starts work again.

Josef Kohout
jsfkcz
Posts: 29
Joined: Thu Sep 11, 2014 8:29 am

Re: Corrupted datasource of series in chart

Post by jsfkcz »

Now, It looks ok at XLSRW 6.00.59 :-)
Post Reply