need help with calculation in my spreadsheet array

[Ron Edgerson]

im currently making a spreadsheet that calculate user input and puts the row, column,values,total in the spreadsheet and im trying to store the formula in the cell but im having problems doing so can some one help me out??

heres my code:

 
import java.io.IOException;
import java.util.Scanner;

public class Sheet {


    public static void main(String[] args) throws IOException {
			// TODO Auto-generated method stub
    	double [][] Sheet = new double[5][7];
		for(int row = 0; row < 5 ; row++)
			for(int col = 0; col < 7; col++);
		//twoDimArray[row][col]= (double)row * 100.0 + (double)col;

		Scanner in = new Scanner(System.in);
		
		 
	
          
		
           System.out.println("Enter the Cell Column, Row, and Value: ");
	   String S = in.next();
           char    colLet = S.charAt(0);
           int col = (int) colLet;
           if ((col >= 65) && (col <= 90)) col = col - 65;
           else if ((col >= 97) && (col <= 122)) col = col - 97;
           else System.out.println("Invalid row letter entered.");
           // col = col- 65;
		  	int row = in.nextInt();
		  	double value = in.nextDouble();
			Sheet[row][col] = value;
			
			
		
		
	    String S2 = in.next();
            char    colLet1 = S2.charAt(0);
            int col2 = (int) colLet1;
            if ((col2 >= 65) && (col2 <= 90)) col2 = col2 - 65;
            else if ((col2 >= 97) && (col2 <= 122)) col2 = col2 - 97;
            else System.out.println("Invalid row letter entered.");
            //col2 = col2 - 65;
	    int row2 = in.nextInt();
	    double value1 = in.nextDouble();
	    Sheet[row2][col2] = value1;
	   //store = colLet1 + String.valueOf(value1) + row2;
		     
	    String s1 = in.next();
	   // operation string add, sub, multiply, division, 
	    double total = 0;
	// ignore input case from string "+", and add to string together
	 if (s1.equalsIgnoreCase("+"))
			 {
	 System.out.println( + value + " + " + value1 + " = " + (value+value1));
	   total = value + value1;
				
				 
			 }
			 
	    else if (s1.equalsIgnoreCase("-"))
			 {
	   System.out.println( + value + " - " + value1 + " = " + (value-value1));
	     total = value - value1;
			 }
	     else if (s1.equalsIgnoreCase("*"))
			 {
	   System.out.println(+ value+ " * " + value1 + " = " + (value*value1));
	     total = value * value1;
			}
	    else if (s1.equalsIgnoreCase("/"))
			 {
	    System.out.println( + value + "/" + value1 + " = " + (value/value1));
	     total = value / value1;
			 }
			  
       
			  
		 String S3 = in.next();
	         char    colLet2 = S3.charAt(0);
	         int col3 = (int) colLet2;
	         if ((col3 >= 65) && (col3 <= 90)) col3 = col3 - 65;
	         else if ((col3 >= 97) && (col3 <= 122)) col3 = col3 - 97;
	         else System.out.println("Invalid row letter entered.");
	         // col3 = col3 - 65;
		 int row3 = in.nextInt();
		 Sheet[row3 ][col3] = total;
		
		
		   
    	arrayPrt(Sheet);

    	System.out.println("Enter to change the row and col: ");
    	String S4 = in.next();
    	char    colLet4 = S4.charAt(0);
        int col4 = (int) colLet4;
        col4 = col4 - 65;
        int row4 = in.nextInt();
         value = in.nextDouble();
        //Sheet[row3][col3] =  total;
		 
	Sheet[row3 ][col3] = total;
        Sheet[row4][col4] = value;
       //String store =  String.valueOf(value) + s1 +  String.valueOf(value1) + " = " + String.valueOf(total);
       //System.out.println(store);
        
       if (s1.equalsIgnoreCase("+"))
		 {
       System.out.println( + value + " + " + value1 + " = " + (value+value1));
        total = value + value1;
			 
		 }
        arrayPrt(Sheet);
    }
    


		   
	 private static void arrayPrt(double[][] A) {
		// TODO Auto-generated method stub
	double Cols = A[0].length;
	double Rows = A.length;
					
	System.out.print("\n   ");
	//char[] letter = {'A'= 1, 'B' = 2, 'C'= 3, 'D' = 4, 'E'= 5};  
	 for (char i = 'A'; i <= 'G'; i++) 
	System.out.printf("%8.3s   ", String.valueOf(i));
	System.out.printf("\n   |");
	for(int col = 0; col < Cols; col++) System.out.printf(" ---------|");
					
	for(int row= 0; row < Rows; row++)
		{
	System.out.printf("\n%2d |" ,row);
	for( int col = 0; col < Cols; col++)	
        System.out.printf("%6.3f    |" , A[row][col]);
	System.out.printf("\n   |");
	for( int col = 0; col < Cols; col++) System.out.printf(" ---------|");
		}
				
				    
	System.out.print("\n");
					

							 
					
		}
					

    
    }

[Jesper de Jong]

Welcome to the Ranch!

Can you explain in more detail what aspect of it you exactly have problems with? Do you get any error messages; if yes, then what exactly are the error messages? Does the program run, but doesn't it do what you expect - if yes, then how does what it actually does differ from what you expect?

[Ron Edgerson]

Ok so if does give me a error yet, nonetheless, here is my output:

Enter the Cell Column, Row, and Value:
a 0 3.4 b 0 3.4 + c 0
3.4 + 3.4 = 6.8

A B C D E F G
| ---------| ---------| ---------| ---------| ---------| ---------| ---------|
0 | 3.400 | 3.400 | 6.800 | 0.000 | 0.000 | 0.000 | 0.000 |
| ---------| ---------| ---------| ---------| ---------| ---------| ---------|
1 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| ---------| ---------| ---------| ---------| ---------| ---------| ---------|
2 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| ---------| ---------| ---------| ---------| ---------| ---------| ---------|
3 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| ---------| ---------| ---------| ---------| ---------| ---------| ---------|
4 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| ---------| ---------| ---------| ---------| ---------| ---------| ---------|
Enter to change the row and col:
A 0 2.333
2.333 + 3.4 = 5.7330000000000005

A B C D E F G
| ---------| ---------| ---------| ---------| ---------| ---------| ---------|
0 | 2.333 | 3.400 | 6.800 | 0.000 | 0.000 | 0.000 | 0.000 |
| ---------| ---------| ---------| ---------| ---------| ---------| ---------|
1 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| ---------| ---------| ---------| ---------| ---------| ---------| ---------|
2 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| ---------| ---------| ---------| ---------| ---------| ---------| ---------|
3 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| ---------| ---------| ---------| ---------| ---------| ---------| ---------|
4 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| ---------| ---------| ---------| ---------| ---------| ---------| ---------|


Now i ask the user to input column, row number, value, and then column two, row number 2, value two, operator, and then store the total in the cell specified. which it does store the correct total in the first prompt, but when i ask the user to change the value in column A , row 0 , the new value is store but the total will not change ( which it suppose to change from 6.8 to 5.7).
im not sure how to get the new total to store??