EPPlus Returns "STG_E_WRITEFAULT" When It Attempts to Read a Valid .xlsx File

The EPPlus Call to Method "new ExcelPackage(rawStream)" Returns "STG_E_WRITEFAULT" When It Attempts to Read a Valid .xlsx File This problem occurs when the EPPlus "ExcelPackage" constructor is ca...

Id #15520 | Release: None | Updated: Aug 22 at 10:03 PM by PhilipLGarrett | Created: Aug 22 at 10:03 PM by PhilipLGarrett

LoadFromText creates Table that is one row to long

If i create a Table from a CSV File the Excel Table has one empty row at the end. Any suggestions? regards, André using OfficeOpenXml; using OfficeOpenXml.Table; using System.IO; using Syste...

Id #15519 | Release: None | Updated: Aug 21 at 10:33 AM by Andre_S | Created: Aug 21 at 10:33 AM by Andre_S

EPPlus Cell from ExcelRange

This problem has me completely puzzled. I have a Excel document which loads in just fine. It has rows, columns and data and I want to iterate through the rows. But EPPLus is odd. I take the...

Id #15518 | Release: None | Updated: Aug 19 at 2:26 PM by PatrickAleman | Created: Aug 19 at 2:26 PM by PatrickAleman

Hyperlink fragment identifiers are not returned

URL fragment identifiers (like #foo in http://example.com/#foo) are not returned from the spreadsheet XML. The example sheet contains a single cell with the formula HYPERLINK("http://example.com/...

Id #15517 | Release: None | Updated: Aug 17 at 1:04 AM by afader | Created: Aug 17 at 1:04 AM by afader

Use user defined functions in cell (calculation)

EPPlus offers a lot of functionality but I somehow miss one. Is it by design or am I just missing something? I would like EPPlus to calculate user defined functions, as often found in a vba code mo...

Id #15516 | Release: None | Updated: Aug 22 at 8:16 PM by swmal | Created: Aug 16 at 8:33 AM by peterkae

Change chart type by serie

I've tried to create a chart with 2 columns and 2 lines. But it doesn't work : when I try to open the excel file, excel needs to repair it, and the chart doesn't appear. Here is the error log : <?...

Id #15515 | Release: None | Updated: Aug 12 at 2:34 PM by Romain44 | Created: Aug 12 at 2:33 PM by Romain44

NullReferenceException adding comments in the last two rows

When running the following code (using either 4.1 or the current source after 0271551045e6) a NullReferenceException is thrown from CellStore.NextCell() during the call to ExcelRange.AddComment: ...

Id #15514 | Release: None | Updated: Aug 12 at 12:04 PM by othulke | Created: Aug 12 at 12:04 PM by othulke

Comment handling several errors

The following code adds, then deletes comments. Create a worksheet with a few cells in Excel. Run this code, which will add a comment and save. Rerun the code in debug, and notice that the "co...

Id #15513 | Release: None | Updated: Aug 11 at 10:58 PM by JamesOliver8 | Created: Aug 11 at 10:58 PM by JamesOliver8

Concat operator can throw a NullReferenceException with an empty ExcelAddressExpression

ExcelAddressExpressions can be modified to always return an IRangeInfo. If the content of a single cell range is empty, the IRangeInfo is null and OfficeOpenXml.FormulaParsing.Excel.Operators.Oper...

Id #15512 | Release: None | Updated: Aug 11 at 7:46 PM by pdxsam | Created: Aug 11 at 5:21 PM by pdxsam

ROUND(626.3,-3) returns incorrect result

The round function seems to always do a truncate when the second argument is negative, which is incorrect. EPPlus returns 0, while Excel returns 1000. See here: https://support.office.com/en-us/...

Id #15511 | Release: None | Updated: Aug 10 at 7:41 PM by Motley | Created: Aug 10 at 5:10 PM by Motley