SpreadsheetGear 2010 FAQ

SpreadsheetGear - performance spreadsheet components

Products

Samples

Downloads

Support

Company

Frequently Asked Questions

1.	Can SpreadsheetGear 2010 be deployed royalty free?

2.	How many developer licenses do I need to purchase?

3.	Is Excel required to use SpreadsheetGear 2010?

4.	Is COM required to use SpreadsheetGear 2010?

5.	Does SpreadsheetGear 2010 support Excel 2007 and Excel 2010?

6.	Does SpreadsheetGear 2010 support charts?

7.	Do you have a list of supported Excel functions?

8.	Do you have samples for Windows Forms Applications?

9.	How do I use SpreadsheetGear 2010 in a Visual Studio 2005 / 2008 / 2010 or Visual Web Developer Express Edition Web Site Project?

10.	How do I add the SpreadsheetGear 2010 Windows Forms Controls to the Microsoft Visual C# 2005 / 2008 / 2010 Express Edition Toolbox or the Microsoft Visual Basic 2005 / 2008 / 2010 Express Edition Toolbox?

11.	Can multiple versions of SpreadsheetGear 2010 be used at the same time on one machine?

12.	Why don't I see SpreadsheetGear listed under the .NET tab when using Add Reference?

13.	Why does the IntelliSense and Dynamic Help not work in Visual Studio?

Can SpreadsheetGear 2010 be deployed royalty free?

SpreadsheetGear 2010 can be deployed royalty free with most client and server applications. Please see the license agreement for limitations.

How many developer licenses do I need to purchase?

One developer license is required for each and every developer working on any application which references SpreadsheetGear.dll.

Is Excel required to use SpreadsheetGear 2010?

No, Excel is not required to use SpreadsheetGear 2010. Using Excel in a server environment is not supported, which makes SpreadsheetGear 2010 a good solution for your server applications as well as your client applications.

Is COM required to use SpreadsheetGear 2010?

No, SpreadsheetGear 2010 is 100 percent safe managed code written exclusively for the .NET Framework. All that is required is the .NET Framework and SpreadsheetGear.dll.

Does SpreadsheetGear 2010 support Excel 2007 and Excel 2010?

SpreadsheetGear 2010 provides robust support for Excel 2007-2010 Open XML (.xlsx) and macro-enabled Open XML (.xlsm) workbooks as well as Excel 97-2003 (.xls) workbooks.

Does SpreadsheetGear 2010 support charts?

SpreadsheetGear 2010 comes with the most comprehensive Excel compatible charting support found in any .NET component, including charting APIs, chart rendering and chart editing.

Do you have a list of supported Excel functions?

See the Supported Excel Functions on the product page.

Do you have samples for Windows Forms Applications?

SpreadsheetGear 2010 comes with the SpreadsheetGear Explorer sample solutions for C# and Visual Basic. The SpreadsheetGear Explorer is a helpful Windows Forms Application sample soluton for Visual Studio 2005, Visual Studio 2008 and Visual Studio 2010. See Windows Forms Spreadsheet Control Samples for more information.

How do I use SpreadsheetGear 2010 in a Visual Studio 2005 / 2008 / 2010 or Visual Web Developer Express Edition Web Site Project?

Follow these getting started instructions and then refer to the live ASP.NET Samples.

How do I add the SpreadsheetGear 2010 Windows Forms Controls to the Microsoft Visual C# 2005 / 2008 / 2010 Express Edition Toolbox or the Microsoft Visual Basic 2005 / 2008 / 2010 Express Edition Toolbox?

1. Install Microsoft Visual C# 2005 / 2008 / 2010 Express Edition or Microsoft Visual Basic 2005 / 2008 / 2010 Express Edition.
2. Install SpreadsheetGear 2010.
3. Launch Visual C# Express or Visual Basic Express.
4. On the File menu click New Project…. The New Project dialog box appears. (You may also Open an existing Windows Application project.)
5. Under Templates, choose Windows Application.
6. Change the Name as desired.
7. Click OK to create the project
8. On the View menu click Toolbox. The Toolbox appears.
9. Right-click in the Toolbox and click Add Tab. A new Tab appears to be named.
10. Name the Tab (such as SpreadsheetGear 2010)
11. Right-click within the Tab and click Choose Items….
12. Scroll through the list and check FormulaBar and WorkbookView.
13. Click OK to add the controls to the Tab.

Can multiple versions of SpreadsheetGear 2010 be used at the same time on one machine?

Yes. SpreadsheetGear 2010 is a strong named assembly which enables the installation and use of multiple versions on one machine.

Why don't I see SpreadsheetGear listed under the .NET tab when using Add Reference?

Visual Studio only looks for new .NET components once. Be sure to close and restart Visual Studio after installing SpreadsheetGear 2010.

Why does the IntelliSense and Dynamic Help not work in Visual Studio?

If you recently installed a new version of SpreadsheetGear, you may need to remove the reference to the SpreadsheetGear assembly from your project using the Solution Explorer window in Visual Studio. First, remove the old reference, then, add the new one back by using the .NET tab of the Add Reference dialog.

It is also important to note that Visual Studio 2010 replaced the MS Help 2 system with the new Microsoft Help Viewer 1.0 system. This new help system does not have Dynamic Help, though it does still support IntelliSense, and pressing F1 on a term such as "IWorkbookSet".

See SpreadsheetGear 2010 -> Getting Started -> Using Help in the SpreadsheetGear Help for more information on using the SpreadsheetGear 2010 help with Visual Studio 2005 / 2008 / 2010.

Note: It may be necessary to delete any occurences of SpreadsheetGear.dll from your project directory before adding the new assembly.

Like SpreadsheetGear?

SpreadsheetGear 2010
Now Available

NEW! Autofilters, password protected workbooks, macro-enabled Open XML (.xlsm) support, Excel 2010 support, Visual Studio 2010 and .NET 4.0 support, a number of charting features and more.

Download the FREE Trial.

Microsoft Chooses
SpreadsheetGear for .NET

"After carefully evaluating SpreadsheetGear, Excel Services, and other 3rd party options, we ultimately chose SpreadsheetGear for .NET because it is the best fit for MSN Money."

Chris Donohue
Program Manager
MSN Money

Spreadsheet Component
Industry Veterans

"Our key developers have over fifty years of combined experience developing high performance commercially available spreadsheet technology which is used by most of the Fortune 500."

Joe Erickson
Founder and CEO
SpreadsheetGear LLC

Over 100 Times Faster
Than Other Controls

"We just wanted you to know how thrilled we are by the performance we are seeing with SpreadsheetGear for .NET. A 6,000 KB Excel workbook is loading into the WorkbookView control in less than a second. This is over 100 times faster than other controls we’ve tested. That difference makes it possible for us to develop and release a viable product with the Microsoft .NET Framework."

Amy Tate
Chief .NET Architect
Applied OLAP, Inc.
Huntsville, Alabama

Special Product
Great Job

We’ve been using SpreadsheetGear for 5 years. One of the things that makes this product special is that I really don’t have to think about it – I can spend my time worrying about the application that wraps it rather than the technology itself.

The vendor is great to work with too – technical questions are addressed quickly and accurately, without a lot of the refusal to admit problems that plagues other vendors.

Great job!!!

Bill Wilson
Development Manager
Thomson Reuters

SpreadsheetGear - The
Best I Have Encountered

"The sample code you provided has worked very well indeed. Many thanks for your help. As a developer of bespoke software I can honestly say that of all the components my company has ever used, SpreadsheetGear is the best that I have encountered."

Peter Rose, Director
TEKenable, Ltd.
Dublin, Ireland

Your Quick Responses...
You Continue to Impress

"Your quick responses to queries are one of the original reasons why we opted for your product, and you continue to impress us with the speed at which questions and issues are dealt with."

Justin Blackwell
Volume Design Ltd.
Berkshire, United Kingdom

First Rate Support
Superior Control

"Your support is first rate. We always get an answer within a few minutes of any request or question. This support, combined with the exceptional speed and ease of use of your superior control enables me to create complex spreadsheet solutions that work in a few minutes instead of days. Keep up the excellent work!"

Greg Newman
WSFS Bank
Newark DE

I'm Impressed With the
Ease of Use and Speed

"I'm impressed with the ease of use and speed of SpreadsheetGear for .NET in rendering large workbooks from a web page. Congrats for your work!"

José M. Marcenaro
Tercer Planeta
Buenos Aires, Argentina

Reduced Time From
20 Minutes to 4 Seconds

"We integrated SpreadsheetGear for .NET with an existing application with about two days work and it reduced the time it takes to generate a critical daily report from 20 minutes to 4 seconds. Thanks for making my team look like miracle workers!"

Luke Melia, Software
Development Manager
Oxygen Media, New York

Excellent Product
And Service

"Thank you for all your help during the trial period.

Your excellent product and service is what convinced us to buy this component."

Etienne Demers
OceanLogics, Canada

SpreadsheetGear
ROCKS!!!!

"We recently bought SpreadsheetGear for an Excel reporting project and have found it to be excellent!

However, this week I have discovered that I can use SpreadsheetGear to open an Excel spreadsheet and interrogate it on the fly. This facility has literally saved me weeks of work. Hence I am just dropping you a quick email to say thank you very much.

SpreadsheetGear ROCKS!!!!"

Andrew Breward
Caboodal

Microsoft, Microsoft Excel, Visual Studio and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.