/*******************************************************************************
* 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
*******************************************************************************
* Starnuto Di Topo & Jan Källman Initial Release 2010-03-14
* Jan Källman License changed GPL-->LGPL 2011-12-27
*******************************************************************************/
using System;
using System.Collections.Generic;
using System.Text;
namespace OfficeOpenXml
{
///
/// A single cell address
///
public class ExcelCellAddress
{
public ExcelCellAddress()
: this(1, 1)
{
}
private int _row;
private int _column;
private string _address;
///
/// Initializes a new instance of the ExcelCellAddress class.
///
/// The row.
/// The column.
public ExcelCellAddress(int row, int column)
{
this.Row = row;
this.Column = column;
}
///
/// Initializes a new instance of the ExcelCellAddress class.
///
///The address
public ExcelCellAddress(string address)
{
this.Address = address;
}
///
/// Row
///
public int Row
{
get
{
return this._row;
}
private set
{
if (value <= 0)
{
throw new ArgumentOutOfRangeException("value", "Row cannot be less than 1.");
}
this._row = value;
if(_column>0)
_address = ExcelCellBase.GetAddress(_row, _column);
else
_address = "#REF!";
}
}
///
/// Column
///
public int Column
{
get
{
return this._column;
}
private set
{
if (value <= 0)
{
throw new ArgumentOutOfRangeException("value", "Column cannot be less than 1.");
}
this._column = value;
if (_row > 0)
_address = ExcelCellBase.GetAddress(_row, _column);
else
_address = "#REF!";
}
}
///
/// Celladdress
///
public string Address
{
get
{
return _address;
}
internal set
{
_address = value;
ExcelCellBase.GetRowColFromAddress(_address, out _row, out _column);
}
}
///
/// If the address is an invalid reference (#REF!)
///
public bool IsRef
{
get
{
return _row <= 0;
}
}
}
}