When use subtotal function with Epplus, I get "Excel found unreadable content in..." error

Question

I have a simple Excel document generated by Epplus library in my web page; however when I use the excel function "subtotal", I get the following error: Excel found unreadable content in... Here is the code: ``` protected void Page_Load(object sender, EventArgs e) { ExcelPackage pck = new ExcelPackage(); ExcelWorksheet ws = pck.Workbook.Worksheets.Add("hoja1"); ws.Cells["A1"].Value = 1; ws.Cells["A2"].Value = 2; ws.Cells["A3"].Value = 3; ws.Cells["A1:A3"].Style.Numberformat.Format = "#,##0"; ws.Cells["A4"].Formula= "SUBTOTAL(9;A1:A3)"; Response.Clear(); Response.AddHeader("content-disposition", string.Format("attachment;filename=\"{0}\"", "Reporte.xlsx")); Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.BinaryWrite(pck.GetAsByteArray()); Response.End(); } ``` And xml document wiht detail: ```

Accepted Answer

Not sure if this is the issue or not, but try replacing the ";" with a ",":

```
ws.Cells["A4"].Formula= "SUBTOTAL(9,A1:A3)";
```

Good luck.

When use subtotal function with Epplus, I get "Excel found unreadable content in..." error

Solution

Problem