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??

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"); } }