Free cookie consent management tool by TermsFeed Policy Generator

source: trunk/sources/HeuristicLab.ExtLibs/HeuristicLab.EPPlus/4.0.3/EPPlus-4.0.3/FormulaParsing/Excel/Functions/Information/IsBlank.cs @ 12074

Last change on this file since 12074 was 12074, checked in by sraggl, 9 years ago

#2341: Added EPPlus-4.0.3 to ExtLibs

File size: 2.6 KB
Line 
1/* Copyright (C) 2011  Jan Källman
2 *
3 * This library is free software; you can redistribute it and/or
4 * modify it under the terms of the GNU Lesser General Public
5 * License as published by the Free Software Foundation; either
6 * version 2.1 of the License, or (at your option) any later version.
7
8 * This library is distributed in the hope that it will be useful,
9 * but WITHOUT ANY WARRANTY; without even the implied warranty of
10 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. 
11 * See the GNU Lesser General Public License for more details.
12 *
13 * The GNU Lesser General Public License can be viewed at http://www.opensource.org/licenses/lgpl-license.php
14 * If you unfamiliar with this license or have questions about it, here is an http://www.gnu.org/licenses/gpl-faq.html
15 *
16 * All code and executables are provided "as is" with no warranty either express or implied.
17 * The author accepts no liability for any damage or loss of business that this product may cause.
18 *
19 * Code change notes:
20 *
21 * Author             Change            Date
22 *******************************************************************************
23 * Mats Alm                       Added                   2013-12-03
24 *******************************************************************************/
25using System;
26using System.Collections.Generic;
27using System.Linq;
28using System.Text;
29using OfficeOpenXml.FormulaParsing.ExpressionGraph;
30
31namespace OfficeOpenXml.FormulaParsing.Excel.Functions.Information
32{
33    public class IsBlank : ExcelFunction
34    {
35        public override CompileResult Execute(IEnumerable<FunctionArgument> arguments, ParsingContext context)
36        {
37            if (arguments == null || arguments.Count() == 0)
38            {
39                return CreateResult(true, DataType.Boolean);
40            }
41            var result = true;
42            foreach (var arg in arguments)
43            {
44                if (arg.Value is ExcelDataProvider.IRangeInfo)
45                {                   
46                    var r=(ExcelDataProvider.IRangeInfo)arg.Value;
47                    if (r.GetValue(r.Address._fromRow, r.Address._fromCol) != null)
48                    {
49                        result = false;
50                    }
51                }
52                else
53                {
54                    if (arg.Value != null && (arg.Value.ToString() != string.Empty))
55                    {
56                        result = false;
57                        break;
58                    }
59                }
60            }
61            return CreateResult(result, DataType.Boolean);
62        }
63    }
64}
Note: See TracBrowser for help on using the repository browser.