Colby B. Hearn

icon indicating a website link https://TheCodesmiths.io icon indicating an email [email protected]

icon company The Codesmiths icon location Tyler, Texas icon location Learning more and more about less and less, until ultimately I know absolutely everything about nothing at all.

Results 5 comments of Colby B. Hearn

Some address expression references to an empty cell should return zero

Here's sample code and a sample workbook [issue559.xlsx](https://github.com/EPPlusSoftware/EPPlus/files/7738468/issue559.xlsx). ``` ExcelPackage.LicenseContext = LicenseContext.NonCommercial; var package = new ExcelPackage(); var ws = package.Workbook.Worksheets.Add("sample"); var b1 = ws.Cells["B1"]; b1.Formula = "ISBLANK(A1)"; var b2...

Some address expression references to an empty cell should return zero

Since this is a critical defect for my customer, I took a stab at fixing this: #561 It's not pretty IMO, but perhaps it might save you some time while...

Some address expression references to an empty cell should return zero

I had to amend PR #561 as NamedValueExpression's compile method also had to resolve references to empty cells.

Circular Reference detection does not consider external workbook

No worries on overlooking. Thank you all so much for investigating and doing what you do!

Epplus result differs from excel for number and empty string inequality

@swmal Ok, understood. Thanks so much for jumping on these defects (@JanKallman too!). I'll look into v7 again!