Disable Compatibility Checker in Excel Worksheets with Aspose.Cells for .NET API in C#

Aspose.Cells Product Family
1

Hi,

Can we disable Compatibility Checker for a particular worksheet in Excel.

I have attached a excel file and a doc file which will make you clear about my requirements.

1. On saving the Excel file, a dialoge opens to say "Following features are not supported in earlier version of Excel." Below that there is a checkbox "Check compatibility while saving this workbook".

I want to uncheck it programmatically.

2. Also the heading shows "KPI_comprop.xls[Compatibility Mode]".I want to remove this compatibility mode.

How to do this?

Please let me know.

Thanks !

Rohan

2

Hi,

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

Please try the following code and see if it works fine.

Please download and use the latest version:
Aspose.Cells for .NET (Latest Version)


C#


workbook.Settings.CheckExcelRestriction = false;

Also, I have logged this issue in our database to help you better. Development team will look into this feature and help you asap.

This issue has been logged as CELLSNET-40682.

3
Hi,

For this requirement, we will try to support it in next week.
4

I downloaded latest dll and tried your code.

But the issue is not resolved.

Thanks!

Rohan

5

Hi,

Thanks for feedback.

I have already logged a New Feature Request for this issue.

We will support it in coming week hopefully.

6

Okay. Thanks a lot.

Please let me know once it is done.

Also look after the removal of [Compatibility Mode] in the heading of the file.

Thanks!

Rohan

7

Hi,

Sure, we will take care of it.

We have also logged your comment against the same issue id: CELLSNET-40682

8

Hi,

We have fixed this issue.

Please download and try the latest fix: Aspose.Cells for .NET (Latest Version)

Please set workbook.Settings.CheckComptiliblity = false;

9

Thanks a lot.

It is working. After saving the file , it doesn't show me a dialogue now.

But second problem persists. The heading shows [Compatibility Mode].

Can we remove that?

Thanks !

Rohan

10

Hi,

Thanks for your feedback.

Could you please highlight the second problem in a screenshot for better illustration? It will help development team to fix this issue too.

11

Please see the attached Excel and doc file.

Thanks !

Rohan

12

Hi,

Well, I think, this is not possible.

Can you do it using Ms-Excel 2010 or 2007? Please show us the steps.

If you want to get rid of the compatibility caption, then you should save your file in xlsx format instead.

13

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

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