using System;
using System.Collections.Generic;
using System.Text;
using System.Collections;
using Biff8Excel.Interface;
using Biff8Excel.Excel;

namespace Biff8Excel.Formulas
{
    public class CellCollection : CollectionBase 
    {
        Dictionary<string, ExcelCell> dic;

        public CellCollection()
        {
            dic = new Dictionary<string, ExcelCell>();
        }

        public void Add(ExcelCell Value)
        {
            List.Add(Value);
            dic.Add(Value.ToString(), Value);
        }

        public void Add( string key,ExcelCell Value)
        {
            List.Add(Value);
            dic.Add(key, Value);
        }


        public ICell this[int index]
        {
            get
            {
                return List[index] as ExcelCell;
            }

            set
            {
                List[index] = value;
            }
        }

        public ICell this[string key]
        {
            get { 
                ExcelCell exc;

                if (dic.TryGetValue(key, out exc) == false )
                    return null;

                return dic[key] as ExcelCell; }
        }
    }
}