EPPlus does not support the Excel 'Value' function

EPPlus does not appear to support the Excel 'Value' function. I have attached an example Excel worksheet that reproduces the problem.

Id #15273 | Release: None | Updated: Thu at 4:51 PM by PhilipLGarrett | Created: Thu at 4:51 PM by PhilipLGarrett

Outlining and protected worksheet

Hello ! Is there a way to enable outlining in a protected worksheet ? Thanks in advance for your help ! Grunvald

Id #15272 | Release: None | Updated: Thu at 3:57 PM by grunvald | Created: Thu at 3:57 PM by grunvald

R1C1 formula translation

Hello everyone, First, thank you guys for a great library. The problem is that when you have the following R1C1 formula cell.FormulaR1C1 = "SUM(C[-3])"; EPPlus needs to convert it to A1 forma...

Id #15271 | Release: None | Updated: Thu at 1:23 PM by Ozonni | Created: Thu at 1:21 PM by Ozonni

When method 'ExcelWorksheet.Tables' is called for a workbook containing a Chart sheet, EPPlus returns the error "This property or method is not supported for a Chartsheet"

I understand that EPPlus does not currently support Chart sheets, but would it be possible for the 'ExcelWorksheet.Tables' method to simply ignore Chart sheets in this case and return a valid respo...

Id #15270 | Release: None | Updated: Tue at 10:01 PM by PhilipLGarrett | Created: Tue at 10:01 PM by PhilipLGarrett

mail merge fails at 4.0.4, was fine with 4.0.3

Hi, I'm using EPPlus to generate excel file, that will feeds Microsoft.Office.Interop.Word.MailMerge with docMerge.OpenDataSource( dataFile.FullName, ReadOnly: true,...

Id #15269 | Release: None | Updated: Tue at 10:12 AM by JakubPawlinski | Created: Tue at 10:12 AM by JakubPawlinski

Load xlsm file

Hi, i have created xlsm file with open file xml sdk concept. In that file , only xml is viewed in the sheet. I would like to know is it possible to modify xml using EPPLus package. Regards

Id #15268 | Release: None | Updated: Mon at 10:44 AM by sivaranjani | Created: Mon at 9:39 AM by sivaranjani

Excel chart Axis Title

Hi I am trying to change the orientation of each tick label in a chart, and to change it's format from "dd/MM/yyyy HH:mm:ss" to "dd/MM/yyyy" but it's not working. chart.XAxis.Title.Rotation = 3...

Id #15267 | Release: None | Updated: May 14 at 3:59 PM by Issame | Created: May 14 at 3:59 PM by Issame

Problem saving spreadsheet with PivotTables

Latest version throwing an exception in ExcelWorkSheet.cs method SavePivotTables when using a template with pivot tables. problem line var ws = Workbook.Worksheets[pt.CacheDefinition.SourceRange...

Id #15266 | Release: None | Updated: Wed at 7:32 AM by svetob | Created: May 14 at 9:23 AM by pblackburn1968

RepeatRows corrupts using worksheet name with apostrophe

If using RepeatRows and a worksheet name with an apostrophe the workbook comes up as corrupted due to apostrophe's used to specify the worksheet name. Below is the workbook.xml where you can see th...

Id #15265 | Release: None | Updated: May 12 at 8:30 PM by Tydude4Christ | Created: May 12 at 8:30 PM by Tydude4Christ

Consider using recyclablememorystream to speed up generation of large spreadsheets

I want to investigate the benefits and risks of this: https://github.com/Microsoft/Microsoft.IO.RecyclableMemoryStream

Id #15264 | Release: None | Updated: May 8 at 9:07 PM by zippy1981 | Created: May 8 at 9:07 PM by zippy1981