This project has moved and is read-only. For the latest updates, please go here.

ClosedXML 0.53.3

Rating: No reviews yet
Downloads: 131
Change Set: 67346
Released: Jun 3, 2011
Updated: Jun 4, 2011 by MDeLeon
Dev status: Stable Help Icon

Recommended Download

Application ClosedXML for .Net Framework 4.0
application, 179K, uploaded Jun 4, 2011 - 76 downloads

Other Available Downloads

Application ClosedXML for .Net Framework 3.5
application, 179K, uploaded Jun 4, 2011 - 55 downloads

Release Notes

New on this release:

1) Added FindCells, FindColumns, and FindRows methods to the workbook object.

2) Added cell.ValueCached property that holds Excel's cache of formula evaluations.

3) Added the following properties to the worksheets:

ShowFormulas
ShowGridLines
ShowOutlineSymbols
ShowRowColHeaders
ShowRuler
ShowWhiteSpace
ShowZeros

4) Added methods Worksheets.Add(DataTable), Worksheets.Add(DataSet). See examples Adding DataTable as Worksheet, Adding DataSet

5) Fixed issues 6609, 6532, 6510, 6499, 6705, 6508

Breaking Changes:

Removed static method XLWorkbook.GetXLFont(). When you add a header/footer text which you want to format just modify the rich text/font returned by the .AddText(...) methods. See example Headers and Footers Tab

New on v0.53.1

1) Added TabColor property to the worksheets. See example Tab Colors

2) Added overloads to further fine tune how adjust to contents functions work:

IXLColumn AdjustToContents(Double minWidth, Double maxWidth);
IXLColumn AdjustToContents(Int32 startRow, Double minWidth, Double maxWidth);
IXLColumn AdjustToContents(Int32 startRow, Int32 endRow, Double minWidth, Double maxWidth);

IXLRow AdjustToContents(Double minHeight, Double maxHeight);
IXLRow AdjustToContents(Int32 startColumn, Double minHeight, Double maxHeight);
IXLRow AdjustToContents(Int32 startColumn, Int32 endColumn, Double minHeight, Double maxHeight);

3) Fixed issue 6706 (sheet protection)

New on v0.53.2

1) Added overload address.ToString(XLReferenceStyle) to pick from A1, R1C1, or the workbook default.

2) Added overload range.Cells(String) for you to specify multiple cells at once.

3) ClosedXML will no longer set the default print area to the worksheet.RangeUsed()

4) Fixed issue 6749 (range.RangeUsed method)

New on v0.53.3

1) Improved Overall Performance

2) Fixed issues 6769, 6756

New Examples
Adding DataTable as Worksheet
Adding DataSet
Tab Colors

Modified Examples:
Headers and Footers Tab

Reviews for this release

No reviews yet for this release.