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

Free Support Forum - aspose.com

Combining Excel-pages in multiple tabs messes up the formatting and formulas

Dear Aspose,

we seem to be having issues when we want to 'stitch' single page excel-sheets to one master excel-sheet where the different single pages need to be presented in different tabs.

It seems that formulas and some of the formatting of the first single page is being repeated in all the other tabs (when we put another single sheet on the first tab of the master excel-sheet, the formulas of THAT sheet are repeated in all the other tabs).

Is this a known issue?

The work-around we have temporarily implemented is adding a dummy first tab (containing no formulas) to the master excel-sheet. This solves the issue.

The dummy tabsheet is not desirable of course.

Is there a solution to this issue?

Greetings & thanks in advance!

Franky

Hi,

BulletTabNerd:

we seem to be having issues when we want to 'stitch' single page excel-sheets to one master excel-sheet where the different single pages need to be presented in different tabs.

It seems that formulas and some of the formatting of the first single page is being repeated in all the other tabs (when we put another single sheet on the first tab of the master excel-sheet, the formulas of THAT sheet are repeated in all the other tabs).

Is this a known issue?

Well, Aspose.Cells generally follows Ms Excel standards and specifications even in combining workbooks operation (you may evaluate it by merging spreadsheets in MS Excel manually). If you still find the issue with Aspose.Cells APIs, kindly create a sample console application (runnable) with Aspose.Cells for .NET v8.3.1.0 (latest version), zip it and post us here with all the files, we will check it soon.

BulletTabNerd:

The work-around we have temporarily implemented is adding a dummy first tab (containing no formulas) to the master excel-sheet. This solves the issue.

The dummy tabsheet is not desirable of course.

Is there a solution to this issue?

If this resolves your issue, then you may simply remove that temporary worksheet via Aspose.Cells APIs before rendering to final output Excel file.


Thank you.