After save, an xlsm looses all the data.

I was trying to copy VBA projects from one xlsm to another, it keeps removing all the data. Even when I removed all the code and just did open and save, it still removed all the data. Current v...

Id #15464 | Release: None | Updated: Wed at 11:36 PM by messedup | Created: Wed at 11:36 PM by messedup

Table column names with formula characters such as parenthesis cause Total row functions to return #NAME.

Say a table column name has formula characters such as parenthesis such as Column (1). Thus the subtotal function for it in the Table's total row would look like this: =SUBTOTAL(109,TableName[Col...

Id #15463 | Release: None | Updated: Wed at 5:57 PM by fhilton | Created: Wed at 5:54 PM by fhilton

Special characters are not escaped in TotalsRowFunction of a Table column.

If a column name has a special character in it ([, ], #, or '), the special character(s) must be escaped in the totals row function with a '. This is not currently happening, resulting in a corrup...

Id #15462 | Release: None | Updated: Wed at 3:52 PM by pdxsam | Created: Wed at 3:50 PM by pdxsam

Excel table RowFunctions get the wrong ID.

The totalling functions for RowFunctions.Count and RowFunctions.CountNum are reversed (102 vs. 103).

Id #15461 | Release: None | Updated: Tue at 9:08 PM by zpffpz | Created: Tue at 9:07 PM by zpffpz

Saved ExcelRange with array value gets the array type saved as its value.

In Excel, if a range gets its value set to an array, only the first value is saved as the cell value. In EP Plus, the range value gets saved as the ToString() representation of the object, in this...

Id #15460 | Release: None | Updated: Tue at 2:10 PM by zpffpz | Created: Tue at 2:04 PM by zpffpz

VBA Project is missing.

There is a VBA project if I open the file and look but the following method is showing VbaProject as null. using (ExcelPackage excelpack = new ExcelPackage(utfile)) { if (excelp...

Id #15459 | Release: None | Updated: Tue at 12:22 PM by messedup | Created: Tue at 12:21 PM by messedup

Calculated element in Pivol Table

Hello. I created a pivot table with Epplus, but I need to insert a calculated element of one field of this Pivottable. Can you tell me how to do it? pivotTable.RowFields.Add(pivotTable.Fields("S...

Id #15458 | Release: None | Updated: Apr 29 at 3:07 PM by orijuan0710 | Created: Apr 29 at 3:07 PM by orijuan0710

ColumnMax can not span over existing column on AutoFitColumns() in v4.0.5

Hello, This is great component, I am using this component to generate large excel files. it was working fine till I updated to V4.05. I get this exception when I call workSheet.Cells.AutoFit...

Id #15457 | Release: None | Updated: Apr 28 at 4:16 PM by skovvur | Created: Apr 28 at 4:16 PM by skovvur

How to use EEPlus export .xlsm with VBA in mono c#

How to use EEPlus export .xlsm with VBA in mono c#

Id #15456 | Release: None | Updated: Apr 28 at 11:11 AM by kakarotto | Created: Apr 28 at 11:11 AM by kakarotto

Formulas fail with double references to another sheet

If you have a formula such as =MATCH(E1, Sheet2!A1:A6, 0) the formula will calculate correctly in both Excel and EPPlus. However if you specify Sheet2 in both the starting cell and ending cell, ...

Id #15455 | Release: None | Updated: Apr 27 at 10:00 PM by kilkfoe | Created: Apr 27 at 9:35 PM by kilkfoe