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.
Id #15464 | Release:
| Updated: Wed at 11:36 PM by messedup | Created: Wed at 11:36 PM by messedup
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:
| Updated: Wed at 5:57 PM by fhilton | Created: Wed at 5:54 PM by fhilton
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:
| Updated: Wed at 3:52 PM by pdxsam | Created: Wed at 3:50 PM by pdxsam
The totalling functions for RowFunctions.Count and RowFunctions.CountNum are reversed (102 vs. 103).
Id #15461 | Release:
| Updated: Tue at 9:08 PM by zpffpz | Created: Tue at 9:07 PM by zpffpz
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:
| Updated: Tue at 2:10 PM by zpffpz | Created: Tue at 2:04 PM by zpffpz
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))
Id #15459 | Release:
| Updated: Tue at 12:22 PM by messedup | Created: Tue at 12:21 PM by messedup
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?
Id #15458 | Release:
| Updated: Apr 29 at 3:07 PM by orijuan0710 | Created: Apr 29 at 3:07 PM by orijuan0710
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:
| 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#
Id #15456 | Release:
| Updated: Apr 28 at 11:11 AM by kakarotto | Created: Apr 28 at 11:11 AM by kakarotto
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:
| Updated: Apr 27 at 10:00 PM by kilkfoe | Created: Apr 27 at 9:35 PM by kilkfoe