Beispiel #1
0
        public void TestingCounts()
        {
            SpreadSheet test = new SpreadSheet(50, 26);

            Assert.AreEqual(test.RowCount, 50);
            Assert.AreEqual(test.ColumnCount, 26);
        }
Beispiel #2
0
        public void TestingSelfReference()
        {
            List <string> undoInput = new List <string>();
            SpreadSheet   test      = new SpreadSheet(50, 26);

            test.GetCell(1, 0).Text = "=A1+5";
            Assert.AreEqual(test.GetCell(1, 0).ValueStr, "!self reference");
        }
Beispiel #3
0
        public void TestingBadReference()
        {
            List <string> undoInput = new List <string>();
            SpreadSheet   test      = new SpreadSheet(50, 26);

            test.GetCell(1, 0).Text = "=Cell678+50";
            Assert.AreEqual(test.GetCell(1, 0).ValueStr, "!bad reference");
        }
Beispiel #4
0
        public void TestingIfDefault()
        {
            List <string> undoInput = new List <string>();
            SpreadSheet   test      = new SpreadSheet(50, 26);

            test.GetCell(1, 0).Text = "test";
            Assert.AreEqual(test.DetermineDefault(test.GetCell(1, 0)), 0);
        }
Beispiel #5
0
        public void TestingSpreadsheetText()
        {
            SpreadSheet test = new SpreadSheet(50, 26);

            test.GetCell(1, 0).Text = "12";
            test.GetCell(1, 1).Text = "=(A1+13)";
            Assert.AreEqual(test.GetCell(1, 1).Text, "=(A1+13)");
        }
Beispiel #6
0
        public void TestingSpreadsheetVale()
        {
            SpreadSheet test = new SpreadSheet(50, 26);

            test.GetCell(11, 0).Text = "12";
            test.GetCell(1, 1).Text  = "=(A11+13)";
            Assert.AreEqual("25", test.GetCell(1, 1).ValueStr);
        }
Beispiel #7
0
        public void TestingCircularReference()
        {
            List <string> undoInput = new List <string>();
            SpreadSheet   test      = new SpreadSheet(50, 26);

            test.GetCell(1, 0).Text = "=A2";
            test.GetCell(2, 0).Text = "=A3";
            test.GetCell(3, 0).Text = "=A1";
            Assert.AreEqual(test.GetCell(3, 0).ValueStr, "!circular reference");
        }
Beispiel #8
0
        public void TestingClearStack()
        {
            List <string> undoInput = new List <string>();
            SpreadSheet   test      = new SpreadSheet(50, 26);

            undoInput.Add("0");
            undoInput.Add("0");
            undoInput.Add("color");
            undoInput.Add("4294967295");
            test.AddUndo(undoInput);
            test.ClearStacks();
            Assert.AreEqual(test.DetermineUndo(), -1);
        }
Beispiel #9
0
        public void TestingColorUndoRedo()
        {
            List <string> undoInput = new List <string>();
            SpreadSheet   test      = new SpreadSheet(50, 26);

            test.GetCell(1, 0).Color = 4286644096;
            undoInput.Add("0");
            undoInput.Add("0");
            undoInput.Add("color");
            undoInput.Add("4294967295");
            test.AddUndo(undoInput);
            test.Undo();
            Assert.AreEqual(test.GetCell(1, 0).Color.ToString(), "4294967295");
            test.Redo();
            Assert.AreEqual(test.GetCell(1, 0).Color.ToString(), "4286644096");
        }
Beispiel #10
0
        public void TestingUndoRedo()
        {
            List <string> undoInput = new List <string>();
            SpreadSheet   test      = new SpreadSheet(50, 26);

            test.GetCell(1, 0).Text = "50";
            undoInput.Add("0");
            undoInput.Add("0");
            undoInput.Add("txt");
            undoInput.Add(string.Empty);
            test.AddUndo(undoInput);
            test.Undo();
            Assert.AreEqual(string.Empty, test.GetCell(1, 0).ValueStr);
            test.Redo();
            Assert.AreEqual(test.GetCell(1, 0).ValueStr, "50");
        }
Beispiel #11
0
        /// <summary>
        /// Initializes a new instance of the <see cref="Form1"/> class.
        /// Constructor for the form.
        /// </summary>
        public Form1()
        {
            this.InitializeComponent();
            this.dataGridView1.ColumnCount      = 26;
            this.dataGridView1.Columns[0].Name  = "A";
            this.dataGridView1.Columns[1].Name  = "B";
            this.dataGridView1.Columns[2].Name  = "C";
            this.dataGridView1.Columns[3].Name  = "D";
            this.dataGridView1.Columns[4].Name  = "E";
            this.dataGridView1.Columns[5].Name  = "F";
            this.dataGridView1.Columns[6].Name  = "G";
            this.dataGridView1.Columns[7].Name  = "H";
            this.dataGridView1.Columns[8].Name  = "I";
            this.dataGridView1.Columns[9].Name  = "J";
            this.dataGridView1.Columns[10].Name = "K";
            this.dataGridView1.Columns[11].Name = "L";
            this.dataGridView1.Columns[12].Name = "M";
            this.dataGridView1.Columns[13].Name = "N";
            this.dataGridView1.Columns[14].Name = "O";
            this.dataGridView1.Columns[15].Name = "P";
            this.dataGridView1.Columns[16].Name = "Q";
            this.dataGridView1.Columns[17].Name = "R";
            this.dataGridView1.Columns[18].Name = "S";
            this.dataGridView1.Columns[19].Name = "T";
            this.dataGridView1.Columns[20].Name = "U";
            this.dataGridView1.Columns[21].Name = "V";
            this.dataGridView1.Columns[22].Name = "W";
            this.dataGridView1.Columns[23].Name = "X";
            this.dataGridView1.Columns[24].Name = "Y";
            this.dataGridView1.Columns[25].Name = "Z";

            for (int a = 1; a < 51; a++)
            {
                this.dataGridView1.Rows.Add();
                this.dataGridView1.Rows[a - 1].HeaderCell.Value = a.ToString();
            }

            this.sheet = new SpreadSheet(50, 26);
            this.dataGridView1.CellBeginEdit += new DataGridViewCellCancelEventHandler(this.DataGridView1_CellBeginEdit);
            this.dataGridView1.CellEndEdit   += new DataGridViewCellEventHandler(this.DataGridView1_CellEndEdit);
            this.sheet.PropertyChanged       += this.CellPropertyChanging;
            this.dynamicButton.Click         += new EventHandler(this.Button1_Click);
        }
Beispiel #12
0
        public void TestingGetCellColumn()
        {
            SpreadSheet test = new SpreadSheet(50, 26);

            Assert.AreEqual(test.GetCell(49, 25).ColumnIndex, 25);
        }
Beispiel #13
0
        public void TestingGetCellRow()
        {
            SpreadSheet test = new SpreadSheet(50, 26);

            Assert.AreEqual(test.GetCell(50, 25).RowIndex, 49);
        }