Beispiel #1
0
        public void TestAdresses()
        {
            // GetColumnIndex
            var idx = XLRefAddress.GetColumnIndex("A");

            if (idx != 1)
            {
                throw new Exception("Address Error");
            }
            idx = XLRefAddress.GetColumnIndex("AA");
            if (idx != 27)
            {
                throw new Exception("Address Error");
            }

            // Get
            var colName = XLRefAddress.GetColumnName(1);

            if (colName != "A")
            {
                throw new Exception("Address Error");
            }
            colName = XLRefAddress.GetColumnName(26);
            if (colName != "Z")
            {
                throw new Exception("Address Error");
            }
            colName = XLRefAddress.GetColumnName(27);
            if (colName != "AA")
            {
                throw new Exception("Address Error");
            }
        }
Beispiel #2
0
        public void TestColumnNameIndexConversion()
        {
            var idx = XLRefAddress.GetColumnIndex("Z");

            if (idx != 26)
            {
                throw new Exception("Column Name=>Index Conversion Error");
            }

            idx = XLRefAddress.GetColumnIndex("AZ");
            if (idx != 52)
            {
                throw new Exception("Column Name=>Index Conversion Error");
            }

            idx = XLRefAddress.GetColumnIndex("ABZ");
            if (idx != 754)
            {
                throw new Exception("Column Name=>Index Conversion Error");
            }


            var cname = XLRefAddress.GetColumnName(26);

            if (cname != "Z")
            {
                throw new Exception("Column Index=>Name Conversion Error");
            }

            cname = XLRefAddress.GetColumnName(52);
            if (cname != "AZ")
            {
                throw new Exception("Column Index=>Name Conversion Error");
            }

            cname = XLRefAddress.GetColumnName(53);
            if (cname != "BA")
            {
                throw new Exception("Column Index=>Name Conversion Error");
            }

            cname = XLRefAddress.GetColumnName(754);
            if (cname != "ABZ")
            {
                throw new Exception("Column Index=>Name Conversion Error");
            }

            cname = XLRefAddress.GetColumnName(79);
            if (cname != "CA")
            {
                throw new Exception("Column Index=>Name Conversion Error");
            }

            cname = XLRefAddress.GetColumnName(677);
            if (cname != "ZA")
            {
                throw new Exception("Column Index=>Name Conversion Error");
            }

            for (uint i = 1; i <= 16000; i++)
            {
                cname = XLRefAddress.GetColumnName(i);
                foreach (var c in cname)
                {
                    if (!char.IsLetter(c))
                    {
                        throw new Exception("Column Index=>Name Conversion Error. Corrupted character");
                    }
                }
                var cidx = XLRefAddress.GetColumnIndex(cname);
                if (cidx != i)
                {
                    throw new Exception("Column Index=>Name Conversion Error. Unexpected column name");
                }
            }
        }