We just load a template with pivot data and have “Page Setup”–>“Sheet” setting using Aspose.Cells.Workbook. But it not able to load Page Setup setting properly like
before value of Row to repeat at top was $1:$14 and Columns to repeat at left was $A:$K but on load it change to $1:$1 and $A:$A respectively.
attached snapshot for before and after pagesetup setting.
Below is the code snippet
static void Main(string args)
Workbook sourceWorkbook = new Workbook(@“SampleTemplatePageSetupIssue.xlsx”);
and attached Debug.zip which contain SampleTemplatePageSetupIssue.xlsx and Output.xlsx