"Excel found unreadable content" issue

Hi Team, I am getting "Excel found unreadable content in ''. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes." message while generating t...

Id #15298 | Release: None | Updated: Mon at 7:47 AM by mechinmaya | Created: Mon at 7:47 AM by mechinmaya

Issue when translating FormulaR1C1

whenever I try this: ws.Cells[5,20].FormulaR1C1 = "SUM(SUMIFS(RC[-9]:RC[-1],R3C[-9]:R3C[-1],{\"L\",\"UDT\"}))/4" the R1C1 formula somehow gets translated into this: SUM(SUMIFS(RC[-9]:RC[-1],R3C[...

Id #15297 | Release: None | Updated: Fri at 6:39 AM by gelo32k | Created: Fri at 6:39 AM by gelo32k

Exception occurs reading spreadsheet after saving ExcelPackage (EPPlus)

I am manipulating data in a .xlsx spreadsheet using EPPlus (4.0.4) and saving the file, immediately afterwards I am loading parts of the data into datatables. After I call the .Save() method the ...

Id #15296 | Release: None | Updated: Jun 30 at 10:13 AM by mplm | Created: Jun 30 at 10:13 AM by mplm

Pivot table corrupts the document

I attach input.xlsx. When I open this file with EPPlus, and save it, this results in output.xlsx, which is also attached. When I open output.xlsx in Excel, it gives me error saying the file is corr...

Id #15295 | Release: None | Updated: Jun 26 at 12:35 PM by lolsoft | Created: Jun 26 at 12:35 PM by lolsoft

Excel in email attachment gets filtered

I am using EPPLUS version 4.0.0.0 for excel automation I have tried using file signature as .xlsx for the automatically created excel and saved in the disk. Excel file is getting created with t...

Id #15294 | Release: None | Updated: Jun 19 at 7:03 AM by RevathiNallasivan | Created: Jun 19 at 7:03 AM by RevathiNallasivan

Copy shape from one file to another

Last version tested: 4.0.4 Last version with bug: 4.0.4 I just found a solution to clone shapes from one file to another. Just add this to your ExcelDrawings.cs /// <summary> /// Add a ne...

Id #15293 | Release: None | Updated: Jun 18 at 12:59 PM by SClause | Created: Jun 18 at 6:29 AM by SClause

formula evaluation when data in cell is a byte

I was running into an error where formulas were not being evaluated/computed. After trying to simplify the formula in my scenario, it ultimately came down to the fact that I had been putting value...

Id #15292 | Release: None | Updated: Jun 17 at 5:40 PM by AerisG222 | Created: Jun 17 at 5:40 PM by AerisG222

AddComment: The required attribute 'authorId' is missing

I'm adding many comments into an excel file. Everything works fine in first edited sheet, but in second one EPPLUS doesn't store AuthorList : <x:authors xmlns:x="http://schemas.openxmlformats.org/...

Id #15291 | Release: None | Updated: Jun 15 at 11:11 PM by Sierrodc | Created: Jun 15 at 11:00 PM by Sierrodc

Formulas that use named ranges fail to compute

The attached example sheet has two worksheets. In the first sheet, column 4 has a formula of the form: INDEX(INDIRECT($B2),MATCH($A2,Rows,0),MATCH(D$1,Columns,0)) Where: $B2 == "MAR" In the...

Id #15290 | Release: None | Updated: Jun 30 at 10:46 AM by mplm | Created: Jun 15 at 10:58 PM by PhilipLGarrett

Deleting a worksheet with a pivot table and recreating it leads to garbage in worksheet.xml

You get two lines like this: <pivotCache cacheId="1" r:id="rId4" /> <pivotCache cacheId="1" r:id="rId7" /> Excel complains about corruption. Deleting one line manually fixes it.

Id #15289 | Release: None | Updated: Jun 15 at 5:34 PM by zippy1981 | Created: Jun 15 at 5:34 PM by zippy1981