Support Center

GemBox.Spreadsheet Free, Trial and Professional

GemBox.Spreadsheet has three working modes (Free, Trial 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, but 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 versions 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 sample.

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

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.

11 of 13 people found this page helpful
Subscribe to this article to get an email notification when it is updated.

0 Comments

  • There are no comments.