New Release 1.9 and its Hot Fixes

Aspose.Cells Product Family
1

Dear Customers,
1.9.0.0 is Released.

2

Dear customers,
Hotfix 1.9.1 Released!




*Added

1.SetLicense method
User can set licensce just once.

For example:
Excel.SetLicense(licFile);
Excel excel1 = new Excel();
…

Excel excel2 = new Excel();
…

2. ASeries.Line

for(int i = 0; i < chart.NSeries.Count; i ++)
{
chart.NSeries[i].Line.Color = Color.Red;
chart.NSeries[i].Line.Weight = WeightType.WideLine;

}


Fixed:
1. InsertRow issuse as described in https://forum.aspose.com/t/119017

2. Range copy issue in https://forum.aspose.com/t/119017

3. AutoFit issue in https://forum.aspose.com/t/119017

3

Dear customers,
Hotfix 1.9.2 Released!



*Added

1. ASeries.Area

for(int i = 0; i < chart.NSeries.Count; i ++)
{
chart.NSeries[i].Area.ForegroundColor = Color.Red;
}

2. ExcelXP protection api

Please refer to http://www.aspose.com/Products/Aspose.Excel/Api/Aspose.Excel.Worksheet.Protection.html

Fixed:
1. Autofilter issue as described in https://forum.aspose.com/t/118784.

2.Invalid formula issue as described in https://forum.aspose.com/t/118784

3.Pagebreak issue as described in https://forum.aspose.com/t/118784

4

Dear customers,
Hotfix 1.9.3 Released!



*Added
Cells.ImportDataView

*Fixed
1. GIF issue as described in https://forum.aspose.com/t/118725.

2. Formula issue as described in https://forum.aspose.com/t/118725.

3.Wrap text issue as described in https://forum.aspose.com/t/118725.

5

Hello,

Where can I really find the 1.9.1 hotfix for aspose excel
Because all links go to


which refer the 1.9.3 hotfix

Thanks

6

The newer hot fix zip file overwites the older hot fix zip file while the newer hot fix automatically includes all features added in the older hot fix.

In this case, do you still want the older hot fix? If yes please let me know why.

7

There is a problem when I open a document created with Aspose.EXcel : a strange box appears (in french) :
witch tell : ‘Name is already used’.
I have to enter a new name in a textbox, the old name is 'Impressions_des_titres’
I don’t know what does this name means
After enter a name : ‘blabla’ for example, it works.

So I want to test the version 1.9.1. Maybe this problem doesn’t exists.


NB : This box did not appears whith the 1.9.0
But I need at least version 1.9.1 for the ‘SetLicense’ function

8

Could you send me the problem document? I will check this problem ASAP.Thanks.

9

Ok I forward you my document (still in french).

10

Hi, please re-download the latest hotfix and have a try.

11

Dear Customers,
Hotfix 1.9.4 is released!



*Added:
Range.UnMerge method

*Fixed
1.CategoryAxis.TickLabelSpacing issue as described in https://forum.aspose.com/t/118676.

2. Formula issue as described in https://forum.aspose.com/t/118676

3.Border setting issue as described in https://forum.aspose.com/t/118676

4.IsColorInPalette issue as described in https://forum.aspose.com/t/118676

12

Dear Customers,
Hotfix 1.9.5 is released!



* Added
1.Cells.FindString, Cells.FindNumber methods

2.Picture.Top, Picture.Bottom, Picture.Left, Picture.Right properties
used to set absolute position in a cell.

13

Dear Customers,
Hotfix 1.9.6 is released!



*Added
1. Cells.ImportObjectArray method

*Fixed
1. Import issue as described in https://forum.aspose.com/t/119915

14

Dear Customers,
Hotfix 1.9.7 is released!



*Added
1. Cell.Formula can convert formula in designer file to string and return it.

2. Absolut reference support in Cell.Formula, please refer to https://forum.aspose.com/t/118537.

*Fixed
1.Comment not moved by InsertRow method issue as described in https://forum.aspose.com/t/118537.

2. Image distort issue as described in https://forum.aspose.com/t/118537

15

It works now!
Thanx for quick fix!

16

Dear Customers,
Hotfix 1.9.8 is released!



*Fixed
1. Cell based protection issue as described in https://forum.aspose.com/t/118504.

2. Divide by zero error in AutoFitRow method if there are data in a hidden column

3. Lose format issue