commit a3c3ef0ba3ec3702d07e61c6632f47bf2d3da10c
author Tony Fader <afader@gmail.com> Thu Aug 18 13:36:40 2016 -0700
committer Trevor Ryland <tryland@google.com> Thu Oct 22 17:28:40 2020 -0600
tree 1bce8ecfb3de825868f59f7758d0c19202291f64
parent 405f705f9bdfa4141d30f8c7dc3df8e39ca24cf8

Bugfix 15290

EPPlus/FormulaParsing/Excel/Functions/RefAndLookup/Indirect.cs

diff --git a/EPPlus/FormulaParsing/Excel/Functions/RefAndLookup/Indirect.cs b/EPPlus/FormulaParsing/Excel/Functions/RefAndLookup/Indirect.cs
index 28a9116..af85a06 100644
--- a/EPPlus/FormulaParsing/Excel/Functions/RefAndLookup/Indirect.cs
+++ b/EPPlus/FormulaParsing/Excel/Functions/RefAndLookup/Indirect.cs
@@ -45,7 +45,9 @@
             var result = context.ExcelDataProvider.GetRange(ws, adr._fromRow, adr._fromCol, address);
             if (result.IsEmpty)
             {
-                return CompileResult.Empty;
+                // Bug 15290
+                var namedValueExpr = new NamedValueExpression(address, context);
+                return namedValueExpr.Compile();
             }
             return new CompileResult(result, DataType.Enumerable);
         }