We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

PageSetup Getting change on Worksheet Load and Save

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”);

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)


FYI–We are using Aspose.Cells version -


Thanks for the template file and sample code.

After an initial test, I am able to observe the issue as you mentioned (via screenshots) by using your template file and sample code. I found that Page Setup setting is changed after loading and saving the MS Excel file. I have logged a ticket with an id “CELLSNET-46569” for your issue. We will look into it soon.

Once we have an update on it, we will let you know here.


This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-46569”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.


Please try our latest version/fix: Aspose.Cells for .NET v19.1.5 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells19.1.5 For .Net2_AuthenticodeSigned.Zip (4.7 MB)
Aspose.Cells19.1.5 For .Net4.0.Zip (4.8 MB)

The issues you have found earlier (filed as CELLSNET-46569) have been fixed in Aspose.Cells for .NET v19.2. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi