knarita/ClosedXML

Fork: 0

knarita / ClosedXML

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
2010-12-15	1f78340 Browse files » - 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 committed on 15 Dec 2010
2010-12-12	347c527 Browse files » Improved performance (A LOT) MDeLeon_cp committed on 12 Dec 2010
2010-12-09	353a922 Browse files » Replaced optional parameters with method overloads. MDeLeon_cp committed on 9 Dec 2010
2010-12-09	7a5ea7e Browse files » - 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 committed on 9 Dec 2010
2010-12-05	4ae70c4 Browse files » Fixed bug when opening/saving workbooks with hyperlinks MDeLeon_cp committed on 5 Dec 2010
2010-12-04	20b70e8 Browse files » - Added cell.GetTimeSpan() method MDeLeon_cp committed on 4 Dec 2010
2010-12-04	109fd8f Browse files » - ClosedXML now opens any Excel '07/'10 file. If you have a file that doesn't open/save correctly, please submit a ticket ... on the Issue Tracker tab and attach the file that you're trying to open. - You can open/save workbooks from/to streams. - Fixed issue #5844 MDeLeon_cp committed on 4 Dec 2010