Discuss about the simplified version of spreadsheet storage

Assignment Help Programming Languages

Reference no: EM132398868

Problem description

The assignment deals with a simplified version of spreadsheet storage. A worksheet, in it's most fundamental nature, stores numbers in rows and columns. Of course, spreasheets can store other kinds of values like names, addresses, etc but that is beyond the scope of this assignment.

You are provided the method read(String) in class WorksheetReader. Do not modify this method. It relies on the file containing input data being in the following format:

WorksheetName

<row><column><value>
<row><column><value>
<row><column><value>
...

A workbook is a collection of worksheets.

You are provided the method read(String) in class WorkbookReader. Do not modify this method. It relies on the file containing input data being in the following format:

WorkbookName
<empty line>
WorksheetName1
<row><column><value>
<row><column><value>
<row><column><value>
...
<empty line>
WorksheetName2
<row><column><value>
<row><column><value>
<row><column><value>
...
<empty line>
WorksheetNameN
<row><column><value>
<row><column><value>
<row><column><value>
...
DataEntry.java

Start with DataEntry.java. Complete the method inRange. Each DataEntry object has 3 attributes:

• row number (row): int

• column number (column): int

• contents (value): double

Note that row and column numbers begin with 0.

Worksheet.java

Move on to Worksheet.java. This is where you need to complete most of the methods. Read the javadoc comments and take a look at the tests to figure out what needs to be done.

A worksheet contains an ArrayList of DataEntry objects.

Hence, a worksheet with items:

• row=0, column=3, value=2.5

• row=1, column=2, value=-1.5

• row=2, column=1, value=4.5

• row=2, column=28, value=0.5

represents the following worksheet:

A(0) B(1) C(2) D(3) ... AC(28)
0 - - - 2.5 -
1 - - -1.5 - -
2 - 4.5 - - 0.5
Workbook.java

The third stage is Workbook.java. The only method we want you to complete in this class is copyPaste that copies a range of data from one worksheet and pastes it at a specified location (as given by row and column numbers) in another spreadsheet.

Reference no: EM132398868

Questions Cloud

Explain normalization : Explain normalization and describe the 1st, 2nd, and 3rd normal forms it and why this is important.

Probability of failure of an entire distributed system : How does the probability of failure of an entire distributed system change as the number of independent components in the distributed system grows?

How do these compare to national statistics : What are the statistics for your state and town/city in regards to marijuana use and arrests/citations? How do these compare to national statistics?

Explain the difference between 32-bit and 64-bit : Explain the difference between 32-bit and 64-bit. How many color values can each display in a typical monitor? Compare with audio files.

Discuss about the simplified version of spreadsheet storage : The assignment deals with a simplified version of spreadsheet storage. A worksheet, in it's most fundamental nature, stores numbers in rows and columns.

Available in today commercial or open source market : What types of vulnerabilities could such printers have? Is there an effective method of control available in today's commercial or open source market?

Company tremendous competitive advantage : The decision to adopt or bypass a technology can give a company a tremendous competitive advantage or remove a company from the market completely.

Write a reflection paper on developed countries : write a reflection paper on developed countries in their development efforts and China and India's experiences with their development efforts

Standard performance measures are way of collecting data : Standard performance measures are a way of collecting data across similar functions, processes, costs, and providers.

User Account

All Pages