Hi Team,
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”);
sourceWorkbook.Save(“Output.xlsx”);
}
and attached Debug.zip which contain SampleTemplatePageSetupIssue.xlsx and Output.xlsx
After_PageSetup.PNG (30.6 KB)
Before_PageSetup.PNG (24.9 KB)
Debug.zip (299.7 KB)
Thanks