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

FYI–We are using Aspose.Cells version -18.11.0.0

@rajendrak,

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.

@rajendrak,

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.

@rajendrak,

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