Generate Chart, Apply Style in Excel, Save, Fail

Jul 2, 2014 at 8:04 PM
Edited Jul 2, 2014 at 8:05 PM
This problem exists in both the 3.1 and 4.0 code base.

To reproduce the error,
  1. Run the sample application.
  2. Open sample5.xlsx
  3. Select the Pie Chart
  4. Select the CHART TOOLS tab
  5. Select any predefined style
  6. Save the workbook
The following error is displayed:
Errors were detected while saving 'C:\temp\SampleApp\sample5.xlsx'. Microsoft Excel may be unable to save the file by removing or repairing some features. To make repairs in a new file, click Continue. To cancel saving the file, click Cancel.

Clicking Continue and trying to save the file with a new name results in the exact same error.

I would love to use EPPlus, but the user MUST have the ability to modify the generated spreadsheet when it has a chart which is impossible.

Has anyone found a workaround for this problem?