Open Hub
Open Hub

 Settings |  Report Duplicate

2
I Use This!
Moderate Activity

Commits : Listings

Analyzed 1 day ago. based on code collected 1 day ago.
Aug 15, 2024 — Aug 15, 2025
Commit Message Contributor Files Modified Lines Added Lines Removed Code Location Date
- Fixed issues 6331, 6330
MDeLeon_cp
More... over 14 years ago
*1)* Added method cell.SetValue<T>(T value) which sets the cells data type based on "T" instead of the contents of "value". *2)* (.Net 4 only) When inserting a table from a collection of objects ClosedXML will check for the custom property [Display(Name="Field Name")] and use it for column name if exists. Otherwise it will use the property's name. *3)* Fixed issue where ClosedXML would load dates as numbers if the file didn't specify the data format. *4)* Fixed issue where you could not hide the first sheet. *5)* Added support for array formulas. To use it just put your formulas between curly braces, e.g. cell.FormulaA1 = "{1+1}" *6)* Fixed issues 6312, 6307, 6295, 6285
MDeLeon_cp
More... over 14 years ago
*1)* Added methods/properties to the worksheets: worksheet.Hide(), worksheet.Unhide(), worksheet.Visibility *2)* If a cell A references another cell B then cellA.Value will return the value of cellB *3)* When inserting a DataTable ClosedXML will take the columns captions (if available) and use it as headers. If no caption is available then the column name will be used. Thanks to nitzzzu for the suggestion. *4)* You can now set data validations to multiple ranges in one shot via .Ranges(...).DataValidation.
MDeLeon_cp
More... over 14 years ago
- Fixed issues 6257, 6266
MDeLeon_cp
More... over 14 years ago
- Fixed issues 6237, 6240
MDeLeon_cp
More... over 14 years ago
- Added data validation. - Deleting or clearing cells deletes the hyperlinks too.
MDeLeon_cp
More... over 14 years ago
- Hyperlinks. - Fixed issue 6131 - Added methods table.Column and table.Columns - You can now retrieve a table column by its field name.
MDeLeon_cp
More... over 14 years ago
- Interface cleanup
MDeLeon_cp
More... over 14 years ago
*1)* Fixed issues 6138 (error loading shared formulas), 6139 (Custom Properties and Shared Strings) *2)* Added method workbook.GetSharedStrings() which returns the list of strings which will be shared in the workbook. *3)* Added method workbook.AddSharedString *4)* Added Boolean property cell/range .ShareString with a default value of true. If set to false the cell's text will not be shared and stored as an inline value. *5)* Copying a worksheet also copies Table definitions, NamedRanges, PageSetup, Outlines, etc. *6)* Fixed issue with tables of the same name. *7)* Implemented custom properties via workbook.CustomProperties and workbook.CustomProperty(name) *8)* Added method cell.InsertData(collection) which returns a range that contains the data. *9)* Added method cell.InsertTable(collection) which returns a table that contains the data.
MDeLeon_cp
More... over 14 years ago
- Fixed formatting issue with non-US locale
MDeLeon_cp
More... over 14 years ago
- Added .CopyTo methods to the worksheets: - Added property worksheet.Position to set the position of the worksheets. - Added overload Worksheets.Add(String sheetName, Int32 position). This way you can add a worksheet in a specific position in one shot. - Added method range.RangeUsed() - Added method workbook.Worksheet(String/Int32) to retrieve existing worksheets. I can't believe it never occured to me to add this before. - Improved overall performance. - Fixed Issue # 6807 - Reduced the size of the generated files.
MDeLeon_cp
More... over 14 years ago
- Fixed formatting issue
MDeLeon_cp
More... over 14 years ago
Squeezed more performance out...
MDeLeon_cp
More... over 14 years ago
Broken build - Do not download
MDeLeon_cp
More... over 14 years ago
- Improved overall performance. - Hid the IXLStylized interface (this was long overdue). - Fixed Issue #6084
MDeLeon_cp
More... over 14 years ago
- Added Excel Tables, and you can call a cell using the field name. - Modified the behavior of range.InsertRows/Columns. When you insert a column after the range or a row below the range, the range will be expanded to include the newly added rows/columns. If you insert a column before the range or a row above the range, the range will move accordingly but not expand. This is the default behavior but the insert rows/columns now have a parameter for you to specify whether or not to expand the range. - Added range.ClearStyles() method. It will preserve number/date formats though. - Added set only properties to .Cells(...) so now you can do something like: worksheet.Row(1).Cells("1-3,5,7").Value = "Good!"; - Added methods to .Cells(...) - Removed the properties range.FormulaA1 and range.FormulaR1C1. Please use range.Cells().FormulaA1 and range.Cells().FormulaR1C1 instead. - Improved save performance, A LOT. (Thanks to GFraser for the help locating the bottlenecks). I still have a few things to do to improve the performance but I wanted to release this version because of the substantial improvements already made.
MDeLeon_cp
More... over 14 years ago
- AdjustToContents now ignores merged cells. - Added overloads to AdjustToContents so you can specify the rows/columns you want to use for calculating the height/width - Renamed range.ContainsRange(range) to range.Contains(range) - Added ability to freeze panes via the worksheet.SheetView object - Added method range.Intersects(range)
MDeLeon_cp
More... over 14 years ago
- Restructured Rows/Columns/Range/RangeRow/RangeColumn objects to be more natural. - Commented the interfaces so now you'll get useful information from the intellisense.
MDeLeon_cp
More... over 14 years ago
- ClosedXML now supports Theme colors. - Switched from using Color to XLColor. - Added method worksheet.Clear() - Fixed issues 5946, 5962
MDeLeon_cp
More... over 14 years ago
Fixed Issues: 5951, 5953, 5956, 5957, 5958
MDeLeon_cp
More... over 14 years ago
- Added ability to specify the order of the sheets via the worksheet.SheetIndex property. - Fixed issues 5947, 5948, plus a problem with inserted sheets (special thanks to Marc Wimmer for these)
MDeLeon_cp
More... over 14 years ago
Improved performance (A LOT)
MDeLeon_cp
More... over 14 years ago
Replaced optional parameters with method overloads.
MDeLeon_cp
More... over 14 years ago
- We're now releasing for both .Net 3.5 and .Net 4.0 frameworks. - Merge() and Unmerge() now return a range. - Replaced range.CreateNamedRange with range.AddToNamed - Made it easier to create, use, modify, and delete named ranges (including those pointing to multiple ranges). Please see modified examples. - Fixed issue #5908
MDeLeon_cp
More... over 14 years ago
Fixed bug when opening/saving workbooks with hyperlinks
MDeLeon_cp
More... over 14 years ago
- Added cell.GetTimeSpan() method
MDeLeon_cp
More... over 14 years ago
- ClosedXML now opens any Excel '07/'10 file. If you have a file that doesn't open/save correctly, please submit a ticket
MDeLeon_cp
More... over 14 years ago
ClosedXML now opens any Excel '07/'10 file. I have a bunch of small enhancements I want to implement before release though.
MDeLeon_cp
More... over 14 years ago
Optimized loading
MDeLeon_cp
More... over 14 years ago
Fixed Issue # 5822 and made some small optimizations.
MDeLeon_cp
More... over 14 years ago