GemBox.Spreadsheet Free, Trial, Time Limited and Professional - Knowledgebase / GemBox.Spreadsheet - GemBox Support Center

GemBox.Spreadsheet Free, Trial, Time Limited and Professional

GemBox.Spreadsheet has four working modes (Free, Trial, Time Limited and Professional) which use the same GemBox.Spreadsheet assembly. Every working mode delivers the same performances and set of features and can work in unlimited time period, except for the Time Limited mode. Additionally, Free and Trial modes do have some restrictions applied to them.

Before using any other class from GemBox.Spreadsheet assembly it is necessary to call a SetLicense method to set the license (serial) key. This method can be called multiple times, but the key can only be set once (if you try another key, exception will be thrown). The best place to call this method is from static constructor of from your application's main class.

 

Free mode

The default behaviour of GemBox.Spreadsheet in Free mode is that a FreeLimitReachedException will be thrown when loading or saving a spreadsheet, if a spreadsheet content has more than 150 rows or 5 sheets.
This behaviour can be overridden, to achieve trimming of a spreadsheet content to first 150 rows and 5 sheets when loading or saving a spreadsheet, by handling a SpreadsheetInfo.FreeLimitReached event and setting the FreeLimitEventArgs.FreeLimitReachedAction to FreeLimitReachedAction.Stop.

C# code

// Set license key to use GemBox.Spreadsheet in a Free mode.
SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");

// Stop reading/writing a spreadsheet when the free limit is reached.
SpreadsheetInfo.FreeLimitReached += (sender, e) => e.FreeLimitReachedAction = FreeLimitReachedAction.Stop;

VB.NET code

' Set license key to use GemBox.Spreadsheet in a Free mode.
SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY")

' Stop reading/writing a spreadsheet when the free limit is reached.
AddHandler SpreadsheetInfo.FreeLimitReached, Sub(sender, e) e.FreeLimitReachedAction = FreeLimitReachedAction.Stop

 

Trial mode

For evaluating beyond the first 150 rows and 5 worksheets GemBox.Spreadsheet offers a Trial mode.
Free and Trial modes use the same key: FREE-LIMITED-KEY.
To use GemBox.Spreadsheet in Trial mode requires to subscribe to the SpreadsheetInfo.FreeLimitReached event and set FreeLimitEventArgs.FreeLimitReachedAction to FreeLimitReachedAction.ContinueAsTrial.

C# code

// Set license key to use GemBox.Spreadsheet in a Free mode.
SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");

// Continue to use the component in a Trial mode when free limit is reached.
SpreadsheetInfo.FreeLimitReached += (sender, e) => e.FreeLimitReachedAction = FreeLimitReachedAction.ContinueAsTrial;

VB.NET code

' Set license key to use GemBox.Spreadsheet in a Free mode.
SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY")

' Continue to use the component in a Trial mode when free limit is reached.
AddHandler SpreadsheetInfo.FreeLimitReached, Sub(sender, e) e.FreeLimitReachedAction = FreeLimitReachedAction.ContinueAsTrial

For more information see the GemBox.Spreadsheet performance example.

Limitation of Trial mode is:
- When loading / saving a spreadsheet - approximately 5% of (randomly selected) cells will have their value replaced with string TRIAL.

 

Time Limited mode

GemBox.Spreadsheet also offers a Time Limited mode that can be used for 30 days without any limitations. If you'd like a temporary license key for this mode, please contact us.

 

Professional mode

Using the component in a Professional mode, which has no limitations, requires using a license key. License keys can be purchased from the GemBox.Spreadsheet web shop page.

C# code

// Set license key to use GemBox.Spreadsheet in a Professional mode.
SpreadsheetInfo.SetLicense("your-professional-license-key");

VB.NET code

' Set license key to use GemBox.Spreadsheet in a Professional mode.
SpreadsheetInfo.SetLicense("your-professional-license-key")

For more information visit the GemBox.Spreadsheet Evaluation and Licensing help page.

Helpful Unhelpful

33 of 54 people found this page helpful

Add a comment

You need to log in before you can submit a comment.

Need a password reminder?