EPPlus

EPPlus copied to clipboard

ExcelNamedRangeCollection.Insert causes error "We found a problem with some content in 'test.xlsx'."

1

Hi, If a named range references a whole column (e.g. `Sheet1!$C:$C`) and we insert rows in the worksheet, the range address is changed to something like `Sheet1!Sheet1!$C1:#REF!`. When we try...

owebia

Duplicate index in range - but there are no duplicates.

4

I can't add column mappings regardless of how many columns I add and regardless of indexes. I triple checked my indexes and they are all correct. Yet, the code says...

gassnerj

When there are defined names referencing a whole column (e.g. `Sheet1!$C:$C`), inserting rows fails to update the range: `Sheet1!Sheet1!$C1:#REF!`. Same issue for named row ranges and inserting columns. This fixes...

owebia

When used (excelpackage.doadjustdrawings = false) to copy shape, Shapes can not be placed in a specific location

3

When using (excelpackage.doadjustdrawings = false), the shapes will overlap. In order to see clearly, I manually moved the position of the shapes a little **epplus version 5.8.12**  When used...

93910676wangd

Scope: formula calculation Description of this functionality: Add a name to the workbook and let it refer to a range with a locked address. **1. If the range has multiple...

swmal

Issue with INDEX formula when used with SUM

1

I am trying to use the **SUM** of a range by using **INDEX** method inside it. For e.g. **=SUM(B2:INDEX(A2:C6, 5, 2)).** This is working fine in excel sheet but giving...

kulesshhh

IFERROR not working properly when containing a function that returns an error

3

The `IFERROR` function doesn't seem to work properly in certain situations. For example, if I write the following formula without first defining the name `MyName1`, I'll (correctly) get a `#NAME?`...

craigbrown

Non-Full-Trust environments throw System.Security.VerificationException on simple formula calculation

4

## Problem description * Given is a cell with a formula "500*4" and a call to calculate this cell * On some framework versions and different trust-environments, the .NET runtime...

jochenwezel

Can't set a cell to an error value

3

I found this potential bug (?) while writing a unit test. In Excel, if I type the string `#VALUE!` into a cell, it is stored in the XML as an...

craigbrown

Incorrect Calculations

4

Hi, I am EPPlus 6.0.6.0 to do some excel calculations In one cell I have the below equation in sheet Y =SUM(A!B151:A!B159) which is calculate the sum of cells B151...

adawi9