I have a worksheet called "My Sheet" with data I want to use as the datasource for a chart.
If I code chart.setSourceData('My Sheet!A1:M9',true) or char.setSourceData("'My Sheet'!A1:M9,true), I get an error. The only way to get it to work is to remove all spaces from the worksheet name, but I want the worksheet name to have some spaces to make it more readable.
Even though the worksheet name can also include other characters, like a dash or comma, having those in the specified worksheet name when calling the setSourceData method causes errors.
How can I use data from a worksheet in the setSourceData method when the worksheet name contains blanks and other allowed characters?
Hi Ray,
Thank you for your prompt response. I have reproduced this behavior on my machine starting with version 2018.2 to the latest version, so I have logged it in our internal system. I have also created a new private ticket for you, that is linked to the issue in our system.
This way you will receive automatic notifications on the status of the issue, and can also send updates at anytime.
Please let me know if you have further questions, I will be glad to help.
ChartTest.zip
We are using 2018.2. If you replace the "2018.2/latest" in the attached file with just "latest", an error still occurs but with a slightly different message.
I tried creating a sample for that and I am getting 'Invalid region name' using this syntax. At the same time, I was able to set data source from the same same sheet. If you are able to send an isolated sample reproducing the issue, I will be able to investigate it immediately for you.
Most probably this is a bug that will then needs to be logged in our system and investigated further.
Hristo