Free cookie consent management tool by TermsFeed Policy Generator

source: trunk/HeuristicLab.ExtLibs/HeuristicLab.EPPlus/4.0.3/EPPlus-4.0.3/FormulaParsing/ExcelUtilities/FormulaDependency.cs

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

#2341: Added EPPlus-4.0.3 to ExtLibs

File size: 3.1 KB
Line 
1/*******************************************************************************
2 * You may amend and distribute as you like, but don't remove this header!
3 *
4 * EPPlus provides server-side generation of Excel 2007/2010 spreadsheets.
5 * See http://www.codeplex.com/EPPlus for details.
6 *
7 * Copyright (C) 2011  Jan Källman
8 *
9 * This library is free software; you can redistribute it and/or
10 * modify it under the terms of the GNU Lesser General Public
11 * License as published by the Free Software Foundation; either
12 * version 2.1 of the License, or (at your option) any later version.
13
14 * This library is distributed in the hope that it will be useful,
15 * but WITHOUT ANY WARRANTY; without even the implied warranty of
16 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. 
17 * See the GNU Lesser General Public License for more details.
18 *
19 * The GNU Lesser General Public License can be viewed at http://www.opensource.org/licenses/lgpl-license.php
20 * If you unfamiliar with this license or have questions about it, here is an http://www.gnu.org/licenses/gpl-faq.html
21 *
22 * All code and executables are provided "as is" with no warranty either express or implied.
23 * The author accepts no liability for any damage or loss of business that this product may cause.
24 *
25 * Code change notes:
26 *
27 * Author             Change            Date
28 * ******************************************************************************
29 * Mats Alm                       Added                   2013-03-01 (Prior file history on https://github.com/swmal/ExcelFormulaParser)
30 *******************************************************************************/
31using System;
32using System.Collections.Generic;
33using System.Linq;
34using System.Text;
35using OfficeOpenXml.FormulaParsing.Exceptions;
36
37namespace OfficeOpenXml.FormulaParsing.ExcelUtilities
38{
39    public class FormulaDependency
40    {
41        public FormulaDependency(ParsingScope scope)
42      {   
43            ScopeId = scope.ScopeId;
44            Address = scope.Address;
45      }
46        public Guid ScopeId { get; private set; }
47
48        public RangeAddress Address { get; private set; }
49
50        private List<RangeAddress> _referencedBy = new List<RangeAddress>();
51
52        private List<RangeAddress> _references = new List<RangeAddress>();
53
54        public virtual void AddReferenceFrom(RangeAddress rangeAddress)
55        {
56            if (Address.CollidesWith(rangeAddress) || _references.Exists(x => x.CollidesWith(rangeAddress)))
57            {
58                throw new CircularReferenceException("Circular reference detected at " + rangeAddress.ToString());
59            }
60            _referencedBy.Add(rangeAddress);
61        }
62
63        public virtual void AddReferenceTo(RangeAddress rangeAddress)
64        {
65            if (Address.CollidesWith(rangeAddress) || _referencedBy.Exists(x => x.CollidesWith(rangeAddress)))
66            {
67                throw new CircularReferenceException("Circular reference detected at " + rangeAddress.ToString());
68            }
69            _references.Add(rangeAddress);
70        }
71    }
72}
Note: See TracBrowser for help on using the repository browser.