Export very big data set stops at 65535 rows

I exported a grid with 70k+ rows (16.1 MB file) and a grid with 90k+ rows (21.7 MB file). File was successfully exported. But when I tried to open them pops up Microsoft Security Alert - Office Fil...

Id #1659 | Release: None | Updated: Jan 23, 2014 at 7:47 PM by puremood | Created: Jan 23, 2014 at 7:46 PM by puremood

Unable to Create New sheet on Exported Excel File

Steps to Reproduce 1) After save the excel file in you system 2) Open the excel File 3) Click new sheet in excel file 4) Microsoft excel is stopped working :(

Id #1537 | Release: None | Updated: Dec 3, 2013 at 12:33 PM by DVLNarayana | Created: Dec 3, 2013 at 12:33 PM by DVLNarayana

1904 date issue

By default when i generate an excel using Lite library, the date format is defaulted to 1904. Can we set the 'Date1904' property to false at the workbook level.

Id #1509 | Release: None | Updated: Nov 5, 2013 at 8:16 PM by adisatya2002 | Created: Nov 5, 2013 at 8:16 PM by adisatya2002

DateTime is rounded up to the next day using ExcelLibrary

The datetime I'm writing to Excel always get rounded up to the next day: workSheet.Cells[0, 0] = new Cell(DateTime.Now, new CellFormat(CellFormatType.DateTime, @"HH:mm:ss")); In the output Excel f...

Id #1462 | Release: None | Updated: Jan 29, 2015 at 5:33 PM by efamadors | Created: Sep 28, 2013 at 7:52 PM by edmolko

The type initializer for MS.Internal.JoltHelper threw an exception

Good day, I get this error message when I try to open an Excel 97-2003 Workbook: The type initializer for MS.Internal.JoltHelper threw an exception Here is my code: FileStream fs = File.Open(file...

Id #1185 | Release: None | Updated: Apr 25, 2013 at 3:15 PM by Edo999 | Created: Mar 14, 2013 at 12:43 PM by Ramkat

How to make a cell as locked/read only.

Hi, I am using excellite library for exporting & importing excel from my silverlight application, while exporting the datagrid data to excel i want to make some columns readonly/locked for editing...

Id #1133 | Release: None | Updated: Apr 25, 2013 at 3:15 PM by Edo999 | Created: Jan 17, 2013 at 6:47 AM by dmohana

How can i create borders?

First of all it is a very fast working library, thanks a lot. But i couldn't find any way for making borders, does it support?

Id #1037 | Release: None | Updated: Apr 25, 2013 at 3:16 PM by Edo999 | Created: Oct 9, 2012 at 9:43 PM by osmangumus

DateTime as value of a cell loses time

As can be seen in Lite.ExcelLibrary.BinaryFileFormat.SharedResource.EncodeDateTime:   public double EncodeDateTime(DateTime value) { double days = (value - BaseDate).Days; if (days > 365) days++; r...

Id #902 | Release: None | Updated: Apr 25, 2013 at 3:16 PM by Edo999 | Created: Jul 3, 2012 at 10:41 AM by gius

Negative decimal values throw error

If you pass negative decimal number as a cell value, you get Overflow exception.

Id #901 | Release: None | Updated: Feb 14, 2013 at 8:25 PM by gius | Created: Jul 3, 2012 at 10:11 AM by gius

Excel Lite throws error when working with Large set of data (49000 rows)

Excel Lite seems to throw the below error when we try to save excel data with 49000 rows, the error details is given below   Error:Specified argument was out of the range of valid values. Paramete...

Id #806 | Release: None | Updated: Nov 5, 2013 at 7:44 AM by virtual_matador | Created: Jun 14, 2012 at 6:49 AM by deepeshp