| /******************************************************************************* | 
 |  * You may amend and distribute as you like, but don't remove this header! | 
 |  * | 
 |  * EPPlus provides server-side generation of Excel 2007/2010 spreadsheets. | 
 |  * See http://www.codeplex.com/EPPlus for details. | 
 |  * | 
 |  * Copyright (C) 2011  Jan Källman | 
 |  * | 
 |  * This library is free software; you can redistribute it and/or | 
 |  * modify it under the terms of the GNU Lesser General Public | 
 |  * License as published by the Free Software Foundation; either | 
 |  * version 2.1 of the License, or (at your option) any later version. | 
 |  | 
 |  * This library is distributed in the hope that it will be useful, | 
 |  * but WITHOUT ANY WARRANTY; without even the implied warranty of | 
 |  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. | 
 |  * See the GNU Lesser General Public License for more details. | 
 |  * | 
 |  * The GNU Lesser General Public License can be viewed at http://www.opensource.org/licenses/lgpl-license.php | 
 |  * If you unfamiliar with this license or have questions about it, here is an http://www.gnu.org/licenses/gpl-faq.html | 
 |  * | 
 |  * All code and executables are provided "as is" with no warranty either express or implied. | 
 |  * The author accepts no liability for any damage or loss of business that this product may cause. | 
 |  * | 
 |  * Code change notes: | 
 |  * | 
 |  * Author							Change						Date | 
 |  * ****************************************************************************** | 
 |  * Mats Alm   		                Added       		        2013-03-01 (Prior file history on https://github.com/swmal/ExcelFormulaParser) | 
 |  *******************************************************************************/ | 
 |  | 
 | using System.Linq; | 
 | using OfficeOpenXml.FormulaParsing.Exceptions; | 
 |  | 
 | namespace OfficeOpenXml.FormulaParsing.ExpressionGraph; | 
 |  | 
 | public class NamedValueExpression : AtomicExpression { | 
 |   public NamedValueExpression(string expression, ParsingContext parsingContext) | 
 |       : base(expression) { | 
 |     _parsingContext = parsingContext; | 
 |   } | 
 |  | 
 |   private readonly ParsingContext _parsingContext; | 
 |  | 
 |   public override CompileResult Compile() { | 
 |     var c = _parsingContext.Scopes.Current; | 
 |     var name = _parsingContext.ExcelDataProvider.GetName(c.Address.Worksheet, ExpressionString); | 
 |     //var result = _parsingContext.Parser.Parse(value.ToString()); | 
 |  | 
 |     if (name == null) { | 
 |       throw (new ExcelErrorValueException(ExcelErrorValue.Create(eErrorType.Name))); | 
 |     } | 
 |     if (name.Value == null) { | 
 |       return null; | 
 |     } | 
 |     if (name.Value is ExcelDataProvider.IRangeInfo) { | 
 |       var range = (ExcelDataProvider.IRangeInfo)name.Value; | 
 |       if (range.IsMulti) { | 
 |         return new(name.Value, DataType.Enumerable); | 
 |       } | 
 |       if (range.IsEmpty) { | 
 |         return null; | 
 |       } | 
 |       var factory = new CompileResultFactory(); | 
 |       return factory.Create(range.First().Value); | 
 |     } | 
 |     { | 
 |       var factory = new CompileResultFactory(); | 
 |       return factory.Create(name.Value); | 
 |     } | 
 |  | 
 |     //return new CompileResultFactory().Create(result); | 
 |   } | 
 | } |