Hot Fixes for Release 1.5

Dear Customers,

This thread is a collection for hot fixes since the new release 1.5 (available at the download package) was published.

  1. First please check what we define as a hot fix and what we define as a new release at Aspose.

  2. Once a hot fix is ready, we update the Aspose.Excel.zip file on the server and then add a post in this thread to declare what we have done in this fix. So please always check back on this thread to see what’s happening on Aspose.Excel.dll.

  3. The url for the hot fix is always at http://www.aspose.com/Products/Aspose.Excel/Fixes/Aspose.Excel.zip. For efficiency we won’t include the download address of the fix in our future posts any more. Please bookmark this address for future use.

  4. To avoid confusion, we only store the latest hot fix on the server: whenever a new hotfix is introduced, we overwite the earlier one. So that you will always download the latest version.

  5. If you find Aspose.Excel.dll functions improperly, we highly recommend that you try the latest fix before report the error in this forum. Past experience indicates some of the problems are caused by not using the latest hot fix. Thanks for your understanding and cooperation.

https://forum.aspose.com/t/120074

https://forum.aspose.com/t/120071

https://forum.aspose.com/t/120017

https://forum.aspose.com/t/120012

https://forum.aspose.com/t/120025

https://forum.aspose.com/t/119998

https://forum.aspose.com/t/119984

Hot Fix 1.5.9.0 is released. Please download it.



In this fix, we do the following:
1. Fixed: Too many merged cells problem

2. Added Method:
Excel.Copy
///


/// Copys data from a source excel object.
///

/// Source excel object.
public void Copy(Excel source)

Pictures.Add
///
/// Adds a picture to the collection.
///

/// Upper left row index.
/// Upper left column index.
/// Image filename.
/// Scale of image width, a percentage.
/// Scale of image width, a percentage.
/// object index.
public int Add(int upperLeftRow, int upperLeftColumn, string fileName, int widthScale, int heightScale)


3. Added Property:
Cells.MaxColumn,Cells.MaxRow
///
/// Max column number of cell which contains data or style.
///

public int MaxColumn

///
/// Max row number of cell which contains data or style.
///

public int MaxRow

Hot Fix 1.5.10 is released. Please download it.



In this fix, we do the following:

1. Fixed: A bug in Excel.Replace method

2. Added:

Can save a result file as CSV format.

Worksheets.AddCopy method
///


/// Adds a worksheet to the collection and copys data from an existed worksheet.
///

/// Index of source worksheet.
/// Worksheet object index.
public int AddCopy(int sheetIndex)

Style.Copy method
///
/// Copys data from another style object
///

/// Source Style object
public void Copy(Style style)

Hot Fix 1.5.11 is released. Please download it.



In this fix, we do the following:

1. Fixed: A bug in Excel Names-Function

2. Added:

Header / Footer image support in designer file.

Worksheet.AutoFitRow method
///


/// Autofits the row height.
///

/// Row index.
public void AutoFitRow(int rowIndex)

Worksheet.AutoFitColumn method
///
/// Autofits the column width.
///

/// Column index.
public void AutoFitColumn(byte columnIndex)

After HotFix 1.5.11, we do the following:

1. Changed: Cell.Formula

Now, combined formula can be added to a cell. For example:

cell.Formula = “=A1+B1C1";
cell.Formula = "=SUM(A1:D5)
(sheet2!A1 + sheet2!B1)”;

2. Added:

Comment.Width
Comment.Height

3. Fixed: A bug in AutoFit row to wrapped text