public void TextWithInvalidArgumentReturnsPoundValue() { var func = new OfficeOpenXml.FormulaParsing.Excel.Functions.Text.Text(); var args = FunctionsHelper.CreateArgs(); var result = func.Execute(args, this.ParsingContext); Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result.Result).Type); }
public override CompileResult Execute(IEnumerable<FunctionArgument> arguments, ParsingContext context) { // Sanity check, will set excel VALUE error if min length is not met ValidateArguments(arguments, 2); //Replace swedish year format with invariant for parameter 2. var format = arguments.ElementAt(1).Value.ToString().Replace("åååå", "yyyy"); var newArgs = new List<FunctionArgument> { arguments.ElementAt(0) }; newArgs.Add(new FunctionArgument(format)); //Use the build-in Text function. var func = new Text(); return func.Execute(newArgs, context); }