The following fragment of code applied to the attached file sample.xlsx produces a copy.xlsx workbook with the observed issue:
var workbook = new Workbook(“sample.xlsx”);
var copy = new Workbook();
copy.Copy(workbook);
copy.Save(“copy.xlsx”);
The workbook opened (after Excel refreshes worksheets pivot tables) loses formatting. See the Sales - Trades worksheet:
- row fields have the font switchs from Arial Narrow 8 to Arial 10
- numeric formatting for value fields switches to the time format