SpreadsheetGear - performance spreadsheet components
| | | |
Products
Samples
Downloads
Support
Company
Frequently Asked Questions

1. Can SpreadsheetGear 2009 be deployed royalty free?
2. How many developer licenses do I need to purchase?
3. Is Excel required to use SpreadsheetGear 2009?
4. Is COM required to use SpreadsheetGear 2009?
5. Does SpreadsheetGear 2009 support Excel 2007?
6. Does SpreadsheetGear 2009 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 2009 in a Visual Studio 2005 / 2008 or Visual Web Developer Express Edition Web Site Project?
10. How do I add the SpreadsheetGear 2009 Windows Forms Controls to the Microsoft Visual C# 2005 / 2008 Express Edition Toolbox or the Microsoft Visual Basic 2005 / 2008 Express Edition Toolbox?
11. Can multiple versions of SpreadsheetGear 2009 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 2009 be deployed royalty free?
SpreadsheetGear 2009 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 2009?
No, Excel is not required to use SpreadsheetGear 2009. Using Excel in a server environment is not supported, which makes SpreadsheetGear 2009 a good solution for your server applications as well as your client applications.
  
Is COM required to use SpreadsheetGear 2009?
No, SpreadsheetGear 2009 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 2009 support Excel 2007?
SpreadsheetGear 2009 provides robust support for Excel 2007 Open XML (.xlsx) workbooks as well as Excel 97-2003 (.xls) workbooks.
  
Does SpreadsheetGear 2009 support charts?
SpreadsheetGear 2009 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 2009 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 and Visual Studio 2008. See Windows Forms Spreadsheet Control Samples for more information.
  
How do I use SpreadsheetGear 2009 in a Visual Studio 2005 / 2008 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 2009 Windows Forms Controls to the Microsoft Visual C# 2005 / 2008 Express Edition Toolbox or the Microsoft Visual Basic 2005 / 2008 Express Edition Toolbox?
1. Install Microsoft Visual C# 2005 / 2008 Express Edition or Microsoft Visual Basic 2005 / 2008 Express Edition.
2. Install SpreadsheetGear 2009.
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)
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 2009 be used at the same time on one machine?
Yes. SpreadsheetGear 2009 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 2009.
  
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.

Note: It may be necessary to delete any occurences of SpreadsheetGear.dll from your project directory before adding the new assembly.
SpreadsheetGear 2009
Now Available
NEW!  93 Analysis Toolpak functions, CSV and text files, auto fill, goal seeking, data series, bubble charts, chart axis titles, gradients, rotated text and more.  Download the Licensed version or the FREE Evaluation Now.
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
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 for .NET
A Pleasure to Work With
"SpreadsheetGear for .NET is truly a pleasure to work with. I was up and running within the first day. It is the best spreadsheet generator out on the market. Performance, Ease of Use, and Full Control of the generation process sold me. I no longer have to be concerned with memory leaks, hung processes, COM Interop and slow performance. Our users demand cosmetically appealing reports without additional work. I can build templates at will, with complete control to freeze panes, page setup, cell formats, etc., etc. The old days of pre-building templates are gone. I cannot think of anything this product cannot do."

Todd Dickard
TA Billing Systems Mgr.
TravelCenters of America
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
ASP.NET and
SpreadsheetGear
A Match Made in Heaven
"ASP.NET and Microsoft Excel is a dangerous combination. ASP.NET and SpreadsheetGear is a match made in heaven. When you need your web or Windows app to interact with Excel files with lightening speed and no COM crashes, SpreadsheetGear for .NET is what you use. This product truly separates the men from the boys in the spreadsheet control marketplace."

Robbe Morris
Microsoft MVP - C#
Co-founder of EggHeadCafe.com and former Gartner Sr. Software Engineer
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 - 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
SpreadsheetGear for .NET Worked as Described
"After trying every Microsoft Excel compatible spreadsheet solution for the .NET Framework I could find, SpreadsheetGear for .NET is the only one that actually worked as described."

Michael Garnett
Interpublic Group
New York, NY
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
Copyright © 2003-2009 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.