Free Support Forum -

New Release 2.3 and its Hot Fixes

Dear Customers, is Released. You can download it here.

Dear Customers,

HotFix 2.3.1 is released!


1.Chart data source in designer spreadsheet can be changed at run time.

Excel excel = new Excel();

Charts charts = excel.Worksheets[0].DesignCharts;

//Change chart data source
Chart chart = charts[0];
chart.NSeries.Add("Sheet1!A20:C22", true);

chart = charts[1];
chart.NSeries.Add("Sheet1!N1Stick out tongue3", false);

Dim excel as Excel = new Excel()

Dim charts as Charts = excel.Worksheets(0).DesignCharts

'Change chart data source
Dim chart as Chart = charts(0)
chart.NSeries.Add("Sheet1!A20:C22", true)

chart = charts(1)
chart.NSeries.Add("Sheet1!N1Stick out tongue3", false)

2.ExcelDesigner.ClearDataSource method

1. Shaping the Excel.Save(string) method to concurrently open the designer spreadsheet.
<?xml:namespace prefix = o ns = "urnTongue Tiedchemas-microsoft-comSurprisefficeSurpriseffice" /><oStick out tongue>
1. Adding pictures from stream bug.

</oStick out tongue>

Dear Customers,

HotFix 2.3.2 is released!


Range.Worksheet property

Cells.DeleteRange method<?xml:namespace prefix = o ns = “urnTongue Tiedchemas-microsoft-comSurprisefficeSurpriseffice” /><oStick out tongue></oStick out tongue>

Cells.ClearFormats method
Cells.ImportFromDataReader method
Worksheet.Copy method<oStick out tongue></oStick out tongue>

<oStick out tongue></oStick out tongue>

Dear Customers,

HotFix 2.3.3 is released!

1. Worksheet.IsProtected property
2. Point color setting in a chart series
Excel excel = new Excel();
Cells cells = excel.Worksheets[0].Cells;
Worksheet sheet = excel.Worksheets[0];



int chartIndex = sheet.Charts.Add(ChartType.Column, 5, 5, 20, 10);
Chart chart = sheet.Charts[chartIndex];
chart.NSeries.Add("A1:B3", true);
chart.NSeries[1].Points[1].Area.ForegroundColor = Color.Red;

3. NA value support

l Fixed:<?xml:namespace prefix = o ns = "urnTongue Tiedchemas-microsoft-comSurprisefficeSurpriseffice" /><oStick out tongue></oStick out tongue>

PageSetup issue in Worksheet.Copy method.<oStick out tongue></oStick out tongue>

Comment setting issue<oStick out tongue></oStick out tongue>

Dear Customers,

HotFix 2.3.4 is released!

* Enhanced:
Optimize Range.Copy method

* Fixed:
1. Put string value bug
2. ImportDataGrid method
3. Remove the limit on number of worksheets(no more than 1500), now you can add infinite number of worksheets to a file.