EPPlus 4.0.2

EPPlus 4.0.2

Visit epplus.codeplex.com for the latest information

EPPlus-Create Advanced Excel spreadsheet.

New features

Replaced Packaging API with DotNetZip

• This will remove any problems with Isolated Storage and enable multi threading

New Cell store

• Less memory consumtion
• 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 :)

Perfomance *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 bugfixes...

Beta 2 Changes

• Fixed bug when using RepeatColumns & RepeatRows at the same time.
• VBA project will be left untouched if its not accessed.
• Fixed problem with strings on save.
• Added locks to the cellstore for access by mulitple 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 Candidare 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 cauesed corruption of the package
• Fixed a few Calculation when refering ranges (for example If) function and some
• Added ChartAxis.DisplayUnit
• Fixed a bug related to shared formulas
• Named styles faild in some cases.
• Style.Indent got an invalid value in some cases.
• Fixed a problem with AutofitColumns method.
• Performance fix.
• An 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 hanges 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 smal fixes