)
We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to handle "Maximum number of extended formats exceeded" exception?

Platform: WinForms |
Control: XlsIO |
Published Date: February 28, 2018 |
Last Revised Date: February 28, 2018

This article explains how to handle maximum number of extended formats exceeded exception.

Why maximum number of extended formats exceeded exception is thrown?

MS Excel 97-2003 version supports only 4095 formats and so does XlsIO. When the formats created exceeds 4095, then “Maximum number of extended formats exceeded” exception is thrown.

By default, there are 21 extended formats in workbook creation. To work with more than 4095 formats, we need to set the workbook version greater than Excel 97-2003. This will resolve ”Maximum number of extended formats” exception.

 

 

To know more about cell formatting in XlsIO, please refer the documentation.

Download complete sample

The following C#/VB.NET complete code snippet shows how to handle maximum number of extended formats exceeded exception.

 

 

2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon