Demo version limitations

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

Demo version limitations

Postby adaptive » Fri Oct 08, 2010 2:22 am

Could you please tell me - or point me to some information - about the limitations the demo version has?

So far (I'm evaluating this component as part of a pilot project) I've found the following issues/limitations:
- Columns are limited to 256
- I cannot save a worksheet in Excel 2007 or 2010 format
- The spreadsheet gets protected when saved
- and the more obvious "new" worksheet saying this is trial version of Spire.XLS

Are there any more limitations that I should be aware of? How do I know if these limitations or issues are not an issue in the paid/full version?

Thanks again!
Roshan
adaptive
 
Posts: 3
Joined: Fri Oct 08, 2010 12:57 am
Location: Melbourne, Australia

Re: Demo version limitations

Postby Flash » Fri Oct 08, 2010 2:38 pm

Hello,

Thank you for your inquiry.
- Columns are limited to 256
You need set excel version to excel 2007, so columns are not limited to 256.
Workbook workbook = new Workbook();
workbook.Version = ExcelVersion.Version2007;

//Initailize worksheet
workbook.CreateEmptySheets(1);
Worksheet sheet = workbook.Worksheets[0];
sheet.GridLinesVisible = false;
sheet.Range[2, 266].Text = "test";

- I cannot save a worksheet in Excel 2007 or 2010 format
Please use following to save excel 2007 or 2010 format.
workbook.SaveToFile("Sample.xlsx",ExcelVersion.Version2007);

- The spreadsheet gets protected when saved
Here is a link for your reference.
http://www.e-iceblue.com/Knowledgebase/ ... ction.html

- and the more obvious "new" worksheet saying this is trial version of Spire.XLS
If you use trail version of Spire.XLS, a evaluation warning sheet will be added in your workbook.

Best Regards
User avatar
Flash
 
Posts: 56
Joined: Thu Jun 29, 2006 2:34 pm


Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 0 guests