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.
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
You Have an
Excellent Product
"You have an excellent product. I've finished my testing and was able to rewrite a program using VB.NET and your control. I wrote the previous version 4 years ago using VB6 which employed the Excel COM object. The old program generated about 2100 excel sheets in 8 hours. With your control it now takes 7 minutes!

I also wrote a web form in ASP.NET VB using your control. This was also previously a VB6 / Excel app. This one went from 36 minutes to less than a minute.

I'm having no trouble getting this purchase approved!"

Mark Hitchcock
Manager of Information Technology
Administrative Concepts, Inc.
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
My Boss Thinks
I'm a Genius
"Just wanted to give you a little good feedback on your product. I'm a programmer for a small company in Norway and we needed to create an Excel report for one of our customers. So I purchased a license for your wonderful product and it took me about 10 minutes to get the report from a DataTable into a finished Excel document!

My boss thinks I'm a genius, but hey; the credit should go to your product. At least half of it.

Cheers!"

Hans Olav Stjernholm
Chief Developer
ZapDance as, Norway
Every Day that Goes By
I Am More Amazed
I must say that everyday that goes by I am more amazed with your component. It’s easy to use but still powerful. No more problems using Excel workbooks in the .NET environment.

You have spared me about 3 or 4 months of work with your excellent tool. I also must say that I’m using many other components from other companies and no one has proven to be as fast and effective as you in solving a support request.

Pedro Horta
IT Analyst / Programmer
OmnicomMediaGroup
Portugal
Above and Beyond Support, Exceptional
"Although there was an initial issue related to date formatting associated with a cultural problem, I found that SpreadsheetGear provided myself, and ultimately the bank, with above and beyond support, providing us with the necessary fix for the issue within 2 days.  This is nothing less than exceptional, and I for one would like to thank SpreadsheetGear for their tenacity, enthusiasm and dedication to their product."

David Lashley
IT Development Manager
Commercial Bank of Qatar
SpreadsheetGear Kills
The Competition
"I must say that in terms of structure and completeness, SpreadsheetGear kills the competition."

Mark Keogh, Technical Lead
BCC AdSystems
Sydney, Australia
SpreadsheetGear Joins
Microsoft VSIP Program
August 23, 2005 - "We welcome SpreadsheetGear to the Microsoft Visual Studio Industry Partner Program. The improved ability to create, modify, calculate, read and write Microsoft Excel (versions 97 and higher) workbooks will allow our mutual customers to create a broad range of solutions in a rich and familiar form."

Nick Abbott
Group Manager
.NET Developer Product Marketing Group
Microsoft Corp.

Microsoft VSIP Program
Unmatched Speed
and Ease of Coding
Make it a Winner
SpreadsheetGear is a great product. The speed is unmatched and the ease of coding makes it a winner.

Steve Cruickshank
Redwood Software
Copyright © 2003-2010 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear® is a registered trademark and Spreadsheet Gear is a trademark of SpreadsheetGear LLC.
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.