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:
| Updated: Mon at 9:27 AM by PralayAhluwalia | Created: Mon at 9:27 AM by PralayAhluwalia
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:
| Updated: Mon at 5:24 AM by AllenLin | Created: Aug 22 at 10:51 PM by ManthanShah
I try to create an array formula , but it doesn't work, only first cell show the value, others are empty.
Id #15046 | Release:
| Updated: Aug 22 at 6:48 AM by AllenLin | Created: Aug 22 at 6:48 AM by AllenLin
Version: EPPlus 4.0 Beta 2
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.
Id #15045 | Release:
| Updated: Aug 18 at 10:54 AM by Xenolith | Created: Aug 18 at 10:53 AM by Xenolith
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:
| Updated: Aug 11 at 5:36 PM by JoeThePimpernel | Created: Aug 11 at 5:34 PM by JoeThePimpernel
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
Id #15043 | Release:
| Updated: Aug 8 at 1:29 PM by JanKallman | Created: Aug 5 at 4:35 PM by ossaltu
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:
| Updated: Aug 11 at 8:48 PM by vamsibora | Created: Aug 5 at 10:09 AM by vamsibora
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:
| Updated: Aug 5 at 2:59 PM by wrummler | Created: Jul 31 at 5:33 AM by wrummler
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:
| Updated: Aug 5 at 2:41 PM by JanKallman | Created: Jul 29 at 8:52 AM by eagle47
Tested in version 4.0.0 beta 2. Provided a solution as part of this post.
While updating hyperlinks in a WorkSheet, the location is not encoded. This causes an error when trying to load the updat...
Id #15039 | Release:
| Updated: Aug 8 at 1:29 PM by JanKallman | Created: Jul 22 at 7:40 PM by vamsibora