knarita/ClosedXML

Fork: 0

knarita / ClosedXML

2011-04-18	1278706 Browse files » - Added sorting capabilities to ranges and tables. Please see example [Sorting Data] ... - Fixed issue 6494. MDeLeon_cp committed on 18 Apr 2011
2011-04-14	662af3c Browse files » - Fixed issue 6487 MDeLeon_cp committed on 14 Apr 2011
2011-04-13	9508298 Browse files » 1) Added method range.CopyTo(range/cell) ... 2) Added AutoFilter feature for ranges. 3) You can now open from a file or stream and save to either a file or a stream (regardless of the source). 4) Fixed issues 6429, 6380, 6482 MDeLeon_cp committed on 13 Apr 2011
2011-04-12	3137e25 Browse files » - worksheet.CopyTo(...) should now work as expected. ... - Fixed issues 6406, 6370 - Applied patches 9077, 8683, 9014 MDeLeon_cp committed on 12 Apr 2011
2011-04-04	36a8986 Browse files » 1) Added suport for sheet/cell protection (Thanks to BlackMael for all the help). ... 2) If you set the value of a cell to a string containing an Environment.NewLine, ClosedXML will turn on wrap text on the cell. This behavior is consistent with Excel's. 3) Implemented style.Border.OutsideBorder (this was long overdue). 4) Fixed issues 6375, 6391 MDeLeon_cp committed on 4 Apr 2011
2011-03-28	6609ece Browse files » 1) Modified the save function so it will be less likely to break an existing file with features not recognized by ClosedXML. ... 2) Added methods cell.AddToNamed(...) 3) Fixed issues 6313, 6340, 6392, 6389, 6341 MDeLeon_cp committed on 28 Mar 2011
2011-03-25	1b26532 Browse files » Fixed issue 6363 (slow saving of formulas) MDeLeon_cp committed on 25 Mar 2011
2011-03-24	76fc372 Browse files » Fixed issue 6373 MDeLeon_cp committed on 24 Mar 2011
	ab99fe4 Browse files » - Fixed issue 6364 MDeLeon_cp committed on 24 Mar 2011
	f87fd98 Browse files » 1) Formulas now adjust automagically when you insert/delete rows/columns/cells ... 2) Added methods ranges.AddToNamed(...), ranges.Value, ranges.SetValue(...) 3) Insert[Rows/Columns/Cells] methods now return the collection of inserted rows/columns/cells. 4) Added methods cell.InserCells[Above/Below/Before/After](Int32) 5) Added method worksheet.NamedRange(String) 6) The value of a cell that points to another cell in another sheet now returns the correct value. 7) Fixed issue 6268 MDeLeon_cp committed on 24 Mar 2011
2011-03-16	ef05be2 Browse files » - Fixed issues 6331, 6330 MDeLeon_cp committed on 16 Mar 2011
2011-03-14	687176a Browse files » 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 committed on 14 Mar 2011
2011-03-07	cd4659d Browse files » 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 committed on 7 Mar 2011
2011-02-23	6346881 Browse files » - Fixed issues 6257, 6266 MDeLeon_cp committed on 23 Feb 2011
2011-02-15	9751739 Browse files » - Fixed issues 6237, 6240 MDeLeon_cp committed on 15 Feb 2011
2011-02-14	ed77234 Browse files » - Added data validation. ... - Deleting or clearing cells deletes the hyperlinks too. MDeLeon_cp committed on 14 Feb 2011
2011-01-31	b65211a Browse files » - Hyperlinks. ... - Fixed issue 6131 - Added methods table.Column and table.Columns - You can now retrieve a table column by its field name. MDeLeon_cp committed on 31 Jan 2011
2011-01-24	2b5c0da Browse files » - Interface cleanup MDeLeon_cp committed on 24 Jan 2011
2011-01-24	9bb8973 Browse files » 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 committed on 24 Jan 2011
2011-01-21	2177974 Browse files » - Fixed formatting issue with non-US locale MDeLeon_cp committed on 21 Jan 2011
2011-01-19	498f26c Browse files » - 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 committed on 19 Jan 2011
2011-01-16	682be27 Browse files » - Fixed formatting issue MDeLeon_cp committed on 16 Jan 2011
2011-01-15	88faed0 Browse files » Squeezed more performance out... MDeLeon_cp committed on 15 Jan 2011
2011-01-15	48f7195 Browse files » Broken build - Do not download MDeLeon_cp committed on 15 Jan 2011
2011-01-14	dfac230 Browse files » - Improved overall performance. ... - Hid the IXLStylized interface (this was long overdue). - Fixed Issue #6084 MDeLeon_cp committed on 14 Jan 2011
2011-01-09	723dbad Browse files » - 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 committed on 9 Jan 2011
2010-12-31	6694f38 Browse files » - 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 committed on 31 Dec 2010
2010-12-28	c53fa59 Browse files » - 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 committed on 28 Dec 2010
2010-12-22	95fc424 Browse files » - ClosedXML now supports Theme colors. ... - Switched from using Color to XLColor. - Added method worksheet.Clear() - Fixed issues 5946, 5962 MDeLeon_cp committed on 22 Dec 2010
2010-12-16	be0b216 Browse files » Fixed Issues: 5951, 5953, 5956, 5957, 5958 MDeLeon_cp committed on 16 Dec 2010