I am trying to edit the embedded xlsx of a clustered bar chart that I have included in my docx. I am able to edit and save the xlsx from my code. But when I open the new doc and right click on the chart and try to edit data, nothing happens. Unzipping the docx and opening the spreadsheet, MS Excel tells me that it found "unreadable content" in the file. It repairs the xlsx and opens the file and I find that all the data is there just as I want it.
With further experiment, I have found that the "unreadable content" is actually the series names (column headers) of the bar chart. If I edit only the category names and data values, the embedded xlsx opens up just fine. Why are the series names corrupting the xlsx?
My series name is of the format "MM/DD-MM/DD" (Eg: 12/09-11/25). I am saving them into the cells as type 'STCellType.STR'. This is the same way I'm saving the category names (though they are simple strings).