ImportExcelFile won't change tabs

Aspose.Cells Product Family
1

We are uploading an xlsm files and have found some will let us change tabs no problems and others will not.

I have attached a file that when uploaded and then rendered will not allow us to click on the different tabs.

Some help in identifying the issue would be very valuable.

Thanks.

2

Hi Jade,

Thanks for your posting and using Aspose.Cells for GridWeb.

We were able to observe this issue after importing your Excel file into GridWeb with the latest version. Once, the file is imported into GridWeb, user is unable to change worksheet tabs inside the GridWeb.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-42642.

I have attached the screenshot highlighting this issue for a reference.

C#


string filePath = @“F:\WA_KPIF_data_templates_plans_benefits_July+31_version-HIOS_CSV7_Update_082313.xlsm”;


GridWeb1.WebWorksheets.ImportExcelFile(filePath);


3

Hi,


After further evaluation, well, it is due to data validation applied to the worksheet cells. You may try the following line of code (in bold) before importing file to GridWeb, it works fine.
e.g
Sample code:


string filePath = @“e:\test2\WA_KPIF_data_templates_plans_benefits_July+31_version-HIOS_CSV7_Update_082313.xlsm”;

GridWeb1.ForceValidation = false;

GridWeb1.WebWorksheets.ImportExcelFile(filePath);


Thank you.
4

Hi,


Please try the attached version/fix: Aspose.Cells.GridWeb v8.0.1.2001 (attached), we have fixed your issue now.

Thank you.
5

The issues you have found earlier (filed as CELLSNET-42642) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.