New Release 2.3 and its Hot Fixes

Aspose.Cells Product Family
1

Dear Customers,

2.3.0.0 is Released. You can download it here.

2

Dear Customers,

HotFix 2.3.1 is released!

*Added

1.Chart data source in designer spreadsheet can be changed at run time.
[C#]
Excel excel = new Excel();
excel.Open("c:\\chart.xls");

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);

[VB]
Dim excel as Excel = new Excel()
excel.Open("c:\chart.xls")

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

*Enhanced
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>
*Fixed
1. Adding pictures from stream bug.

</oStick out tongue>
3

Dear Customers,

HotFix 2.3.2 is released!

*Added

Range.Worksheet property

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

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

4

Dear Customers,

HotFix 2.3.3 is released!

*Added

  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];

cells[“A1”].PutValue(100);
cells[“A2”].PutValue(200);
cells[“A3”].PutValue(300);
cells[“A4”].PutValue(“A”);

cells[“b1”].PutValue(400);
cells[“b2”].PutValue(500);
cells[“b3”].PutValue(600);
cells[“b4”].PutValue(“B”);

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;

  1. NA value support
    cell.PutValue("#N/A");

l Fixed:

PageSetup issue in Worksheet.Copy method.

Comment setting issue.

5

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.