EPPlus 4.1.0

EPPlus 4.1 Visit https://github.com/JanKallman/EPPlus for the latest information EPPlus-Create Advanced Excel spreadsheet. New features 4.0 Replaced Packaging API with DotNetZip * This will remove any problems with Isolated Storage and enable multithreading New Cell store * Less memory consumption * Insert columns (not on the range level) * Faster row inserts, Formula Parser * Calculates all formulas in a workbook, a worksheet or in a specified range * 100+ functions implemented * Access via Calculate methods on Workbook, Worksheet and Range objects. * Add custom/missing Excel functions via Workbook. FormulaParserManager. * Samples added to the EPPlusSamples project. The formula parser does not support Array Formulas * Intersect operator (Space) * References to external workbooks * And probably a whole lot of other stuff as well :) Performance *Of course the performance of the formula parser is nowhere near Excels. Our focus has been functionality. Agile Encryption (Office 2012-) * Support for newer type of encryption. Minor new features * Chart worksheets * New Chart Types Bubblecharts * Radar Charts * Area Charts * And lots of bug fixes... Beta 2 Changes * Fixed bug when using RepeatColumns & RepeatRows at the same time. * VBA project will be left untouched if it�s not accessed. * Fixed problem with strings on save. * Added locks to the cell store for access by multiple threads. * Implemented Indirect function * Used DisplayNameAttribute to generate column headers from LoadFromCollection * Rewrote ExcelRangeBase.Copy function. * Added caching to Save ZipStream for Cells and shared strings to speed up the Save method. * Added Missing InsertColumn and DeleteColumn * Added pull request to support Date1904 * Added pull request ExcelWorksheet. LoadFromDataReader Release Candidate changes * Fixed some problems with Range.Copy Function * InsertColumn and Delete column didn't work in some cases * Chart.DisplayBlankAs had the wrong default type in Excel 2010+ * Datavalidation list overflow caused corruption of the package * Fixed a few Calculation when referring ranges (for example If function) * Added ChartAxis.DisplayUnit * Fixed a bug related to shared formulas * Named styles failed in some cases. * Style.Indent got an invalid value in some cases. * Fixed a problem with AutofitColumns method. * Performance fix. * A whole lot of other small fixes. 4.0.1 Fixes * VBA unreadable content * Fixed a few issues with InsertRow and DeleteRow * Fixed bug in Average and AverageA * Handling of Div/0 in functions * Fixed VBA CodeModule error when copying a worksheet. * Value decoding when reading str element for cell value. * Better exception when accessing a worksheet out of range in the Excelworksheets indexer. * Added Small and Large function to formula parser. Performance fix when encountering an unknown function. * Fixed handling strings in formulas * Calculate hangs if formula start with a parenthes. * Worksheet.Dimension returned an invalid range in some cases. * Rowheight was wrong in some cases. * ExcelSeries.Header had an incorrect validation check. 4.0.2 Fixes * Fixes a whole bunch of bugs related to the cell store (Worksheet.InsertColumn, Worksheet.InsertRow, Worksheet.DeleteColumn, Worksheet.DeleteRow, Range.Copy, Range.Clear) * Added functions Acos, Acosh, Asinh, Atanh, Atan, CountBlank, CountIfs, Mina, Offset, Median, Hyperlink, Rept * Fix for reading Excel comment content from the t-element. * Fix to make Range.LoadFromCollection work better with inheritence * And alot of other small fixes 4.0.3 Fixes * Added compilation directive for MONO (Thanks Danny) * Added functions IfError, Char, Error.Type, Degrees, Fixed, IsNonText, IfNa and SumIfs * And fixed a lot of issues. See http://epplus.codeplex.com/SourceControl/list/changesets for more details 4.0.4 Fixes * Added functions Daverage, Dvar Dvarp, DMax, DMin DSum, DGet, DCount and DCountA * Exposed the formula parser logging functionality via FormulaParserManager. * And fixed a lot of issues. See http://epplus.codeplex.com/SourceControl/list/changesets for more details 4.0.5 Fixes * Switched to Visual Studio 2015 for code and sample projects. * Added LineColor, MarkerSize, LineWidth and MarkerLineColor properties to line charts * Added LineEnd properties to shapes * Added functions Value, DateValue, TimeValue * Removed WPF depedency. * And fixed a lot of issues. See http://epplus.codeplex.com/SourceControl/list/changesets for more details 4.1 * Added functions Rank, Rank.eq, Rank.avg and Search * Custom function compilers can now be added via FormulaParserManager * Applied a whole bunch of pull requests... * Performance and memory usage tweeks * Ability to set and retrieve 'custom' extended application propeties. * Added style QuotePrefix * Added support for MajorTimeUnit and MinorTimeUnit to chart axes * Added GapWidth Property to BarChart and Gapwidth. * Added Fill and Border properties to ChartSerie. * Added support for MajorTimeUnit and MinorTimeUnit to chart axes * Insert/delete row/column now shifts named ranges, comments, tables and pivottables. * And fixed a lot of issues. See http://epplus.codeplex.com/SourceControl/list/changesets for more details