Another "ColumnMax can not span over existing column" error

Hi, With version 4.0, I have found another occasion where the error "ColumnMax can not span over existing column" is being raised. This may be related to the issues 14977 and 15010. I am coming...

Id #15049 | Release: None | Updated: Aug 29 at 4:28 PM by Zadjil | Created: Aug 29 at 2:00 PM by Zadjil

VLOOKUP fails in Beta 4.0 Beta 2

we are use the latest Beta 4.0 Beta 2 available and found that VLOOKUPs do not get fired. Our use case requires us to change some cells in a predefined workbook and fire the calculation refresh...

Id #15048 | Release: None | Updated: Aug 28 at 3:31 PM by RagingKore | Created: Aug 25 at 9:27 AM by PralayAhluwalia

EPPlus 4.0 Beta version and IFERROR function in excel

The 4.0 Beta version of EPPlus does not seem to read and evaluate the IFERROR function of Excel correctly. In excel, we see the output of the formula as 0. However, when we try to read that same ce...

Id #15047 | Release: None | Updated: Aug 25 at 5:24 AM by AllenLin | Created: Aug 22 at 10:51 PM by ManthanShah

Create Array Formula

I try to create an array formula , but it doesn't work, only first cell show the value, others are empty. code: worksheet.Cells["E2:E5"].CreateArrayFormula("FREQUENCY(B2:B18,C2:C5)"); Excel: ...

Id #15046 | Release: None | Updated: Aug 22 at 6:48 AM by AllenLin | Created: Aug 22 at 6:48 AM by AllenLin

NullReferenceException when i try to delete a column

Version: EPPlus 4.0 Beta 2 Description deletion of the first column works (at least there is no exception) but when I try to delete the second column I end up with the exception below. Code: ...

Id #15045 | Release: None | Updated: Aug 18 at 10:54 AM by Xenolith | Created: Aug 18 at 10:53 AM by Xenolith

Mask being displayed on iPhone instead of number

I am using the following format for one of the fields in my Excel file: worksheet.Column(7).Style.Numberformat.Format = "###,###,##0.00;RED"; It works fine in Windows and on Android, but on th...

Id #15044 | Release: None | Updated: Aug 11 at 5:36 PM by JoeThePimpernel | Created: Aug 11 at 5:34 PM by JoeThePimpernel

Issue when copying worksheet with cells having more complex formating

When copying worksheet from one excel package to other package, cells with more complex formating get distorted, e.g. "m3" (where "3" is a superscript) becomes <r xmlns="http://schemas.openxmlforma...

Id #15043 | Release: None | Updated: Aug 8 at 1:29 PM by JanKallman | Created: Aug 5 at 4:35 PM by ossaltu

Cells with Formulas returns null value after editing and saving with epplus.

Hi I have a workbook created using Excel 2013 with two named ranges, NamedRange1 and NamedRange2. NamedRange1 has 5 cells with numerical values and NamedRange2 has one cell with a formula "=sum(...

Id #15042 | Release: None | Updated: Aug 11 at 8:48 PM by vamsibora | Created: Aug 5 at 10:09 AM by vamsibora

ExcelRangeBase.Text property does not return correctly formatted text

The attached xlsx has one cell with formatting 00.00.00.000.0 and content 202100083, and shows "02.02.10.008.3" (without quotes) in Excel 2013. When this file is opened with EPPlus and the A1 cel...

Id #15041 | Release: None | Updated: Aug 5 at 2:59 PM by wrummler | Created: Jul 31 at 5:33 AM by wrummler

DisplayRSquaredValue and DisplayEquation for Trendlines

First, let me thank you for all of your work. EPPlus version : 4.0 Beta 2 Excel 2013 version : 15.0.4420.1017 I found a small issue when setting either (or both) DisplayRSquaredValue and Disp...

Id #15040 | Release: None | Updated: Aug 5 at 2:41 PM by JanKallman | Created: Jul 29 at 8:52 AM by eagle47