There was a problem sending the command to the program.

when I save excel file and try to open it with excel 2016 I get the following error: "There was a problem sending the command to the program." and excel opens up in compatibility mode. this does ...

Id #15589 | Release: None | Updated: Fri at 3:37 PM by hepek | Created: Fri at 3:37 PM by hepek

Spaces not allowed in TableName

In the file ExcelTableCollection.cs it says that spaces in table names are not allowed: private void ValidateTableName(string Name) { if (string.IsNullOrEmpty(Name)) { throw new ArgumentExcepti...

Id #15588 | Release: None | Updated: Fri at 2:24 PM by DarkLite1 | Created: Wed at 8:41 AM by DarkLite1

v4.1.0 image (drawing) re-size causes wrong size, especially Jananese Excel file.

Excel calculates drawings size and offset in EMU, that has 9525 times precision of pixel. But, EPPlus calculates drawings size in pixel. This causes in wrong size (and aspect ratio) for small dra...

Id #15587 | Release: None | Updated: Feb 11 at 4:15 AM by kazy111 | Created: Feb 11 at 4:15 AM by kazy111

Huge performance issues after referencing ValidationList and Cells

Hello EPPlus-Team, I have to set validation list references for a lot of Cells (up to 8000) in one worksheet. This causes huge performance problems in setting the reference and saving the packa...

Id #15586 | Release: None | Updated: Feb 9 at 9:36 AM by JLautenschlager | Created: Feb 9 at 9:33 AM by JLautenschlager

EPPlus Formula value resulting in #VALUE!

I am trying to retrieve the cell content from Excel using EPPlus and it returns #VALUE! To reproduce the issue I have an Excel file with a named range Countries and PhoneCodes and another table t...

Id #15585 | Release: None | Updated: Fri at 1:25 PM by JanKallman | Created: Feb 1 at 5:57 AM by ashleyabraham

Bad signature exception

Hi all, Sometimes, I get an exception when I write double values in cells : Bad singature XXXX at position XXXXX This is the code which write into the excel file : FileInfo existingFile = ne...

Id #15584 | Release: None | Updated: Jan 30 at 8:33 AM by maxmont | Created: Jan 30 at 8:33 AM by maxmont

Project produces an invalid format when used as a data source in excel

Microsoft Excel will produce the following error when attempting to add the workbook (produced by the EPPlus library) as an external data source. "External table is not in the expected format". If ...

Id #15583 | Release: None | Updated: Jan 25 at 9:38 AM by Hutoa | Created: Jan 25 at 9:38 AM by Hutoa

I'm having issue creating hyperlink to cell in another sheet

This is the code to try it out: using OfficeOpenXml; using System; using System.Collections.Generic; using System.IO; using System.Linq; using System.Text; using System.Threading.Tasks; namespace ...

Id #15582 | Release: None | Updated: Jan 25 at 12:12 AM by Evlo | Created: Jan 24 at 11:59 PM by Evlo

DataFieldFunctions.CountNums not working as expected

Hey there i tried to create a pivot table with a Datafield with the Function "CountNums". Sadly it worked not as i expected. It gets handled as it would be "count". After a quick check in the s...

Id #15581 | Release: None | Updated: Jan 23 at 9:32 AM by stofa | Created: Jan 23 at 9:32 AM by stofa

ContentType order causes Spam filter to reject EPPlus documents

Scenario: As part of our CI process, we generate an .xlsx file (with EPPlus) of the changes and e-mail it to stakeholders. Recently, our internal SPAM filter starting removing this attachment....

Id #15580 | Release: None | Updated: Jan 19 at 3:42 PM by JamesB_PS | Created: Jan 19 at 3:42 PM by JamesB_PS