Create logo

Badges badges badges!

Maintain pivot table page field order

For generating pivot table cache, don't fail when formula evaluation fails.

TryGetValue should return false if formula evaluation fails

Add Boolean and TimeSpan item types when saving.

Implement the full range of Item subclasses for pivot tables ( https://msdn.microsoft.com/en-us/library/documentformat.openxml.spreadsheet.shareditems.aspx )

Add and implement extension method Type.IsSimpleType

Consolidate XLCell.InsertData and XLCell.InsertTable into one internal method: XLCell.InsertDataInternal

Clarify the "createTable" parameter in XLCell.InsertData

Simplify logic of transposing with inline functions

Fix spelling error

Add and implement IXLAutoFilter.Reapply()

Implement IXLAutoFilter.HiddenRows

Refactor (simplify) filter interfaces: Remove IXLAutoFilter. Rename IXLBaseAutoFilter to IXLAutoFilter. Remove IXLAutoFilter.Set method.

CodeMaid organise and clean autofilter files

Clear all cell contents (formats too) in pivot table range upon loading.

Clear pivot table rendered range upon loading to avoid conflict on rendered cells when opening the file.

Refactor content managers and implement manager for sheetviews

Rename to XLWorksheetContentManager.cs

Move XLWSContentManager to ContentManagers/ dir

Add helper method VisibleRows for autofilters

Skip checks and other logic when new name is same as old name.

Allow pivot tables to have no theme

Exclude files in bin directory from being embedded!

Correctly determine used range when there are merged ranges on a worksheet (fix #881) (#887) ...

* Failing tests added

* Failing tests for predicates added.

* Missing predicates added to LastCellUsed and FirstCellUsed

* Analyze merged ranges with any value of includeFormats flag.

* Use extension method instead of two comparisons

* Use null propagation for predicate

Correctly unprotect worksheet without password

Bump version to 0.94

Ignore pivot table data field base items that are out of range.

Make calculation engine exception public