Template file -> purple cells

Hello, I just installed version 4.0.3 through NuGet and I noticed something when using a template Excel file. When I open this file, fill in some data, and send it back to the client it comes out...

Id #15243 | Release: None | Updated: Wed at 12:37 PM by TimvdL | Created: Wed at 12:37 PM by TimvdL

Error in Address function

ADDRESS function implementation in Address.cs ignores the last argument (spreadsheet name). Fixed version attached.

Id #15242 | Release: None | Updated: Tue at 4:43 AM by zonk_shtol | Created: Tue at 4:43 AM by zonk_shtol

Errors detected (and repaired) in generated .xlsx

Using the latest EPPlus version. Generated a pretty simple Excel file. When loading file into Excel, an error comes up: <?xml version="1.0" encoding="UTF-8" standalone="true"?> -<recoveryLog x...

Id #15241 | Release: None | Updated: Apr 3 at 4:09 PM by djmarcus | Created: Apr 3 at 4:06 PM by djmarcus

Excel crash with pivot table

Hi, when creating a pivot table for a data range where one of the field names contains a line break (\r\n) , Excel crashes on opening the resulting .xlsx file. This can also be reproduced with ...

Id #15240 | Release: None | Updated: Apr 2 at 2:53 PM by ThomasBraun66 | Created: Apr 2 at 2:53 PM by ThomasBraun66

EPPlus and PowerShell

Great library! I wrote a PowerShell Export-Excel. Export data from PowerShell to Excel spreadsheets without Excel. It lets you create Pivot Tables and charts. Check out the short video I did: ...

Id #15239 | Release: None | Updated: Apr 1 at 11:59 PM by dfinke | Created: Apr 1 at 11:59 PM by dfinke

All whitespace in ExcelTextFormat()?

Hi Developer, I am new EPPlus. Here is my sample program code: ..................................... ..................................... var format = new ExcelTextFormat(); format.Delimit...

Id #15238 | Release: None | Updated: Apr 1 at 12:32 PM by adnan_salah84 | Created: Apr 1 at 12:32 PM by adnan_salah84

Resolving CountIf for cells with null values

I found an issue related to the CountIf formula: When some of the cells in the range being validated contains cells with null values, the formula's evaluation is not completed. The null value happe...

Id #15237 | Release: None | Updated: Apr 3 at 9:29 PM by swmal | Created: Apr 1 at 9:27 AM by MytyMyky

Limit maximum number of rows

I have an application using EPPlus to create a one-page spreadsheet. My problem is that, when printed, it has a second, blank, page appended. Is there some way to limit the spreadsheet to, say, 60...

Id #15236 | Release: None | Updated: Apr 1 at 6:45 AM by jdlaw75 | Created: Apr 1 at 6:44 AM by jdlaw75

Using named ranges in cell formulas

Hi, I'm having problems getting a workbook to recalculate correctly when using named ranges in cell formulas. I have a simple workbook where I've named the range A2:A4 'Index' and populated it ...

Id #15235 | Release: None | Updated: Mar 23 at 6:27 PM by r2718 | Created: Mar 23 at 6:27 PM by r2718

Exception with ExcelRange.Copy and merged cells (still present in 59920b4b5f9f)

This relates to the work item 15200 marked as solved. I slightly modified the test case and the problem is still there. Exception: "Can't merge and already merged range" It looks like when ins...

Id #15234 | Release: None | Updated: Mar 23 at 12:27 PM by ioan38 | Created: Mar 23 at 12:27 PM by ioan38