Hi we are trying to do the same thing. It seems like the Workbook.copy method works fine, but the Worksheet.copy method is messing with the column widths and making them all a little bit bigger. Nothing seems to work adding different copy options, even setting the default font. We are using Cells for .NET v19.8.0.
Here is a sample of the basic test we are doing:
Workbook wb = new Workbook("./TestWorkbook.xlsx"); Workbook outputWb = new Workbook(); // This does change the widths. outputWb.Worksheets.Clear(); outputWb.Worksheets.Add(); outputWb.Worksheets.Copy(wb.Worksheets); // This does not change the widths. // outputWb.Copy(wb); outputWb.Save("./testoutput.xlsx");