.Calculate Failing on IF Statement

Hi I have an issue with 4.0 Beta 2 where .Calculate() is failing to correctly evaluate IF statements when cell Addresses are used instead of integer values in the IF statement. The Excel file creat...

Id #15062 | Release: None | Updated: Sep 30 at 2:38 PM by Shav | Created: Sep 30 at 2:36 PM by Shav

Printer setting to keep "Print Entire Work" instead of "Print Active sheet" in epplus

Can we use epplus to keep excel printer setting to print entire work book instead of print active sheet. As of now i can see that we cannot set settings to print entire work book.

Id #15061 | Release: None | Updated: Sep 26 at 5:07 AM by akspjry | Created: Sep 26 at 5:07 AM by akspjry

Chart Axis set DisplayUnit

Hi Can this please be added to the ExcelChartAxis class. I have been using the following code for my own purposes. const string _displayUnitPath = "c:dispUnits/c:builtInUnit/@val"; public st...

Id #15060 | Release: None | Updated: Sep 25 at 11:00 AM by Mubien | Created: Sep 25 at 11:00 AM by Mubien

InsertRow(int, int,int), InsertRow(int,int) does not work! EPPlus 4.0 Beta 2.

Methods InsertRow(int,int,int) and InsertRow(int,int) does not work in EPPlus 4.0 Beta2 FileInfo inFile = new FileInfo(@"c:\Book.xlsx"); FileInfo outFile = new FileInfo(@"c:\Book1.x...

Id #15059 | Release: None | Updated: Sep 19 at 5:07 PM by evgnib123 | Created: Sep 19 at 5:07 PM by evgnib123

Unable to define worksheet (similar to discussion:402213)

Am running the below code. When i step through the code in debug it works. When i build my solution and run it i get the following error Object reference not set to an instance of an object The ...

Id #15058 | Release: None | Updated: Sep 19 at 9:46 AM by rubenesposito | Created: Sep 19 at 9:45 AM by rubenesposito

ExcelWorksheets Class "Add(string Name)" Method trims the worksheet name

I am using EpPlus (version 3.1.3.0) and observed that, when I add a new worksheet to workbook with a name of 35 char, it trims the name to 31 char. Do we have any newer version with the fix.

Id #15057 | Release: None | Updated: Sep 18 at 3:39 PM by Agnimitra | Created: Sep 17 at 8:45 AM by Agnimitra

Setting null or blank formula on a multi-cell range causes broken shared formula

Using 3.1 Stable (https://epplus.codeplex.com/SourceControl/changeset/d09aa5eaced9) : var path = @"C:\path\to\output.xlsx"; var file = new FileInfo(path); file.Delete(); using (var ep = new ExcelPa...

Id #15056 | Release: None | Updated: Sep 19 at 1:00 PM by JanKallman | Created: Sep 16 at 8:42 PM by wrummler

ExcelFunction's ArgToDecimal method returns Double

I've been toying with the custom formula engine in the 4.0 Beta, and I couldn't help but notice that in the ExcelFunction class, there is the following code: protected double ArgToDecimal(object ob...

Id #15055 | Release: None | Updated: Sep 15 at 10:13 PM by IronMan84 | Created: Sep 15 at 10:13 PM by IronMan84

Charts EEplus with values not from a range of cells

I'm using eeplus to generate an excel workbook. I want to make series values assigned by a list that I'm defining and not from a range of cells in the excel library i can do this: series1.Values ...

Id #15054 | Release: None | Updated: Sep 15 at 2:23 PM by youmnah | Created: Sep 15 at 2:23 PM by youmnah

Excel Export can not be saved any more 4.0.0.1!

Hello friends, I am trying to use EPPlus 4.0 beta to generate an Excel worksheet, but I recieve always the following error: The CPF database has been loaded. The Excel-Export has started. De...

Id #15053 | Release: None | Updated: Sep 8 at 11:30 AM by KurtEwald | Created: Sep 8 at 11:30 AM by KurtEwald