using System;
using System.Collections.Generic;
using System.Text;
using HH.WMS.Utils.NPOI.SS.Util;

namespace HH.WMS.Utils.NPOI.SS
{
    /**
     * This enum allows spReadsheets from multiple Excel versions to be handled by the common code.
     * Properties of this enum correspond to attributes of the <i>spReadsheet</i> that are easily
     * discernable to the user.  It is not intended to deal with low-level issues like file formats.
     * <p/>
     *
     * @author Josh Micich
     * @author Yegor Kozlov
     */
    public class SpreadsheetVersion
    {
        /**
         * Excel97 format aka BIFF8
         * <ul>
         * <li>The total number of available columns is 256 (2^8)</li>
         * <li>The total number of available rows is 64k (2^16)</li>
         * <li>The maximum number of arguments to a function is 30</li>
         * <li>Number of conditional format conditions on a cell is 3</li>
         * <li>Length of text cell contents is unlimited </li>
         * <li>Length of text cell contents is 32767</li>
         * </ul>
         */
        public static SpreadsheetVersion EXCEL97 = new SpreadsheetVersion(0x10000, 0x0100, 30, 3, 32767);

        /**
         * Excel2007
         *
         * <ul>
         * <li>The total number of available columns is 16K (2^14)</li>
         * <li>The total number of available rows is 1M (2^20)</li>
         * <li>The maximum number of arguments to a function is 255</li>
         * <li>Number of conditional format conditions on a cell is unlimited
         * (actually limited by available memory in Excel)</li>
         * <li>Length of text cell contents is unlimited </li>
         * </ul>
         */
        public static SpreadsheetVersion EXCEL2007 = new SpreadsheetVersion(0x100000, 0x4000, 255, Int32.MaxValue, Int32.MaxValue);

        private int _maxRows;
        private int _maxColumns;
        private int _maxFunctionArgs;
        private int _maxCondFormats;
        private int _maxTextLength;

        private SpreadsheetVersion(int maxRows, int maxColumns, int maxFunctionArgs, int maxCondFormats, int maxText)
        {
            _maxRows = maxRows;
            _maxColumns = maxColumns;
            _maxFunctionArgs = maxFunctionArgs;
            _maxCondFormats = maxCondFormats;
            _maxTextLength = maxText;
        }

        /**
         * @return the maximum number of usable rows in each spReadsheet
         */
        public int MaxRows
        {
            get
            {
                return _maxRows;
            }
        }

        /**
         * @return the last (maximum) valid row index, equals to <code> GetMaxRows() - 1 </code>
         */
        public int LastRowIndex
        {
            get
            {
                return _maxRows - 1;
            }
        }

        /**
         * @return the maximum number of usable columns in each spReadsheet
         */
        public int MaxColumns
        {
            get
            {
                return _maxColumns;
            }
        }

        /**
         * @return the last (maximum) valid column index, equals to <code> GetMaxColumns() - 1 </code>
         */
        public int LastColumnIndex
        {
            get
            {
                return _maxColumns - 1;
            }
        }

        /**
         * @return the maximum number arguments that can be passed to a multi-arg function (e.g. COUNTIF)
         */
        public int MaxFunctionArgs
        {
            get
            {
                return _maxFunctionArgs;
            }
        }

        /**
         *
         * @return the maximum number of conditional format conditions on a cell
         */
        public int MaxConditionalFormats
        {
            get
            {
                return _maxCondFormats;
            }
        }

        /**
         *
         * @return the last valid column index in a ALPHA-26 representation
         *  (<code>IV</code> or <code>XFD</code>).
         */
        public String LastColumnName
        {
            get
            {
                return CellReference.ConvertNumToColString(LastColumnIndex);
            }
        }

        /**
         * @return the maximum length of a text cell
         */
        public int MaxTextLength
        {
            get
            {
                return _maxTextLength;
            }
        }

    }

}