I'm using Cells for Java V2.0.0 with the PHP Java bridge. In order to get around the lack of a chart copy function, I have an Excel file with several worksheets containing charts. I add worksheets that contain spreadsheets to the file and set the data series on the appropriate charts to point to the spreadsheets that I added. The chart worksheets that I do not use, I want to delete when I am done processing data. Deleting them seems to work fine, but I get an error when I try to save the file out:
com.aspose.cells.CellsException: Worksheet has been destroyed.
This only seems to happen if I remove more than 1 worksheet from the file. Also, I am careful to remove the sheets from highest index to lowest.
Laura