Program mimics a rudimentary spreadsheet

Assignment Help JAVA Programming
Reference no: EM13552132

Program mimics a rudimentary spreadsheet.

The particular spreadsheet in question is constructed with the following GUI. You will be graded to a large extent by how effectively you use arrays and loop processing of those arrays in your solution.

Spreadsheet is constructed from a nine by five grid of IntegerTextFields, labeled with rows numbered 1 through 9 and columns labeled A through E, as depicted to the right.

2312_spreadsheet.png

When the program begins to execute the user is expected to type in the white text fields. For this assignment we will restrict user input to two different options per text field:

1) a valid integer

2) a reference to a different spreadsheet cell so long as that cell contains an integer

The way to reference a different cell is to provide its column (an uppercase letter in the range 'A' through 'E') followed by a single digit in the range from 1 through 9. No blanks or other symbols are acceptable.

When the button (marked "Average rows and columns") is clicked then each row and each column is averaged and the resulting average is placed in the darker (cyan) text field. The picture above shows the result of clicking this button for the particular content shown.

For averaging purposes, the cells that reference other cells borrow the value of the referenced cell.

For instance, in the above example cell D4 contains the String E9. Therefore, whenever the D4 cell is used for averaging (namely averaging row 4 and column D) the value of this cell is treated as 100 because cell E9 contains 100. Any incorrect or empty cell is interpreted as containing zero.

For this 20-point assignment you can display the averages as truncated integers.

Change the averages so that they are rounded to the nearest one hundredth. The example above shows averages in this format.

Change the program so that before the spreadsheet window is displayed, the user sees the window:

1565_spreadsheet1.png

The user types integers into both fields, then hits a return key. Upon typing return in either text field your program must replace the initial window with a spreadsheet window like the one near the top of this page. Of course, this page must contain the specified number of rows and columns. You should restrict the number of rows to 1 though 9 and the number of columns to 1 through 26. As before, rows are numbered, beginning with one and columns lettered beginning with A. All cells behave as defined above. The online applet illustrates.

Reference no: EM13552132

Questions Cloud

How much work does the force do on the particle : A 2 kg particle is acted on by the constant force F=3Ni-4Nj and is displaced from the origin to position s=12mi+5mj, how much work does the force do on the particle
Examine the fundamental rationale behind corporations : Examine the fundamental rationale behind corporations
Find through how many revolutions does the tub turn : The tub of a washer goes into its spin-dry cycle, starting from rest and reaching an angular speed of 4.0 rev/s in 13.0 s. Through how many revolutions does the tub turn during this 25 s interval
Find the height of the satellite above the planets surface : A satellite in a circular orbit around the planet Glob-IV has an orbital period of 246 minutes. Find the height of the satellite above the planet's surface
Program mimics a rudimentary spreadsheet : Change the averages so that they are rounded to the nearest one hundredth. The example above shows averages in format - Change the program so that before the spreadsheet window is displayed, the user sees the window
Determine what maximum distance will it travel : a spring is compressed by 2cm and launches a block up an incline (ignore friction). what maximum distance will it travel
Vertical cylinder closed from both ends is equipped : A vertical cylinder closed from both ends is equipped with an easily moving piston dividing the volume in two parts, each containing 1 mole of air.In equilibrium at T=300K, the volume of the upper part is 4 times the volume in the lower part. At what..
What is the frequency of the rods vibration : A thin 1.7-m metal rod sustanins a longitudinal standing wave with vibration antinodes at each end of the rod. There are no other antinodes. What is the frequency of the rod's vibration
What is the mass of planet physics : While visiting Planet Physics, you toss a rock straight up at 13 m/s and catch it 2.3 s later. What is the mass of Planet Physics

Reviews

Write a Review

 

JAVA Programming Questions & Answers

  Considered to be an improved version

Part (c) is considered to be an improved version of Part (b). You may use an array (2-dimessional) to store some values that has been computed during the run so that when making recursive calls the program does not compute certain values over and ..

  What is overloading and what is overriding

What is overloading and what is overriding? Wrtie JAVA code code to explain it.

  Java program simulate a network

Java program simulate a network

  Accepts a scanner representing an input file

Write a method in JAVA called stripHtmlTags that accepts a Scanner representing an input file containing an HTML web page as its parameter, then reads that file and prints the file's text with all HTML tags removed. A tag is any text between the c..

  Write a method called writenums

Write a method called writeNums that takes an integer n as a parameter and prints to the console the first n integers starting with 1 in sequential order, separated by commas. For example, consider the

  How to detect the correct ip address and run it locally

When you compile the two modules, with disabling the package statement, it runs on one single machine, that's running the server

  1 gqueuea queue is an ordered collection of items in which

1 gqueuea queue is an ordered collection of items in which the removal of items is restricted to the fifo rst in rst

  Part-1inheritance write code using eclipse and output

part-1inheritance write code using eclipse and output screenimplement a subclass square that extends the rectangle

  Cross the dark knight and the living flame of love

What challenges does spain get from the text john of the cross the dark knight and the living flame of love?

  Write java program to receive input and displayed interest

Write a Java program that receive some input and displayed the interest. Format the number into 2 decimal places. Using loop is an advantage.

  Program with backtracking removing all gotos

Please fix the below program with backtracking removing all gotos  and also run the program before posting it and please comment before each line or explain such as what this line means or does .

  Create an abstract class named element

Part 1: Create an abstract class named Element that holds properties of elements, including their symbol, atomic number, and atomic weight. Include a constructor that requires values for all three properties and a get method for each value.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd