Spreadsheet Design Document
(Team Leader)
Hughes, Adam R
(Testing)
King, Jason Matthew
Klancer, John C
Ko, Kenneth
(Coding)
Kolawole, Olufolajimi Abay
Kuklov, Danila S
Kwong, Kayee
Lam, Chi-Ming
CMSC435, Spring 2002, Team # 3
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Spreadsheet Program Design Document - Software Engineering | CMSC 435, Study Guides, Projects, Research of Software Engineering
Material Type: Project; Professor: Memon; Class: Software Engineering; Subject: Computer Science; University: University of Maryland; Term: Spring 2002;
Typology: Study Guides, Projects, Research
Pre 2010
1 / 67
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Spreadsheet Program Design Document - Software Engineering | CMSC 435 and more Study Guides, Projects, Research Software Engineering in PDF only on Docsity!
Spreadsheet Design Document
(Team Leader) Hughes, Adam R (Testing) King, Jason Matthew Klancer, John C Ko, Kenneth (Coding) Kolawole, Olufolajimi Abay Kuklov, Danila S Kwong, Kayee Lam, Chi-Ming CMSC435, Spring 2002, Team # 3
I. Introduction
The purpose of this document is to present the design specification for the Spreadsheet Program. The Spreadsheet program will provide functions to create, store, and print spreadsheet documents. It will allow a user to format rows, columns and individual data cells, use build in functions to analyze data, and cut/copy/paste tables.
Document Structure
The design of the software is split into: user objects, operations, and events. A user object is an interface entity that the user interacts with on the screen. An operation is an action that the software performs in response to an event. Each action has a set of preconditions associated with it, and a set of postconditions that hold true after the operation. Finally, each event can trigger an action if the preconditions for the action are true, and it has list of objects associated with it.
Assumptions
This is the list of things that always hold true in our software: Only one document can be open at a time. One or more cells are always selected. One of the selected cells is always ready for input.
II. Objects
This is the list of interface objects that our software uses.
Global Properties
Filename – the filename for the spreadsheet. “Untitled” is the default for a new document. State – this can be “dirty” if the document was modified but not saved, or “clean” if no new changes occurred in the document since it was saved.
Main Window Objects
Tool barTool bar Menu bar Menu bar Grid Grid Cell Cell Go to: Go to: Menu Bar Go to: Toolbar Go to: Grid Go to: Cell Go to: Clipboard
Main Window
Description The main window is the main object in the program. From this object a user has access to all of the functions that the spreadsheet program provides. Properties (Attributes) Grid – 50x50 grid of cells for input. Toolbar – the tool bar with shortcuts. Menu bar – list of all the menus. Text field – text field that is used to input data into the selected cell in the grid.
Cell
Description The cell is a single entity that can contain user data. Properties (Attributes) Font size Font style Font decoration – italic, bold, underline, or none. Foreground color – font color Background color Border style – inner or outer. Border thickness Content type – string, number, or function Input content – content that was entered by the user Display content – content that is displayed on the screen if this cell in not the input cell.
Menu Objects
File Menu File Menu Edit Menu Edit Menu Format Menu Format Menu Right Click Shortcut Menu Right Click Shortcut Menu Functions Menu Functions Menu Go to: File Menu Go to: Edit Menu Go to: Format Menu Go to: Function Menu Go to: Right Click Shortcut Menu
File Menu
Description File menu allows you to perform file operations Properties (Attributes) New option Open option Print option Save option Save as option
Open Dialog objects
Open Dialog Box Open Dialog Box Go to: Open Dialog box
Open Dialog box
Description Open dialog box pops up on open file operation. Properties (Attributes) File tree Text area – allows to enter or select the name of the file. Ok button Cancel button
Save As Dialog objects
Save Dialog Box Save Dialog Box Go to: Save As Dialog box
Save As Dialog box
Description Save As dialog box pops when the file needs to be saved with a new filename. Properties (Attributes) File tree Text area – allows to enter or select the name of the file
Save button Cancel button
Print Dialog objects
Print Dialog box
Description Print dialog box pops up when a user requests a spreadsheet to be printed. Properties (Attributes) Printer selection Number of copies Ok button Cancel button
Column and Row setting objects
Row Height Dialog Box Row Height Dialog Box Column Width Dialog Box Column Width Dialog Box Go to: Row Height Dialog box Go to: Column Width Dialog box
Column Width Dialog box
Description Column Width dialog box pops up on set column width operation. Properties (Attributes) Text area – allows entering the width size. Ok button Cancel button
Miscellaneous objects
Save Question Dialog Box Save Question Dialog Box Error Dialog Box Error Dialog Box Go to: Save Question dialog box Go to: Error Dialog box
Save Question dialog box
Description Save Question dialog box pops up when the current document is being closed and it is not in a clean state. Properties (Attributes) Previous action - ex. close or new. Yes button No button
Error Dialog box
Description Error Dialog box pop up when an illegal operation is performed. Properties (Attributes) Previous action Ok button
III. Operations
This is the list of all the operations that the spreadsheet can perform. Every Operation can be performed when its preconditions are met.
Select Cell
Parameters: None. Preconditions: Main window is active, and none of the menus are open. Postconditions: The cell becomes the selected group of cells. It is also the current input cell for the grid. The cell displays its input value. The Equation bar in the tool bar displays cell’s input value. Font Style selection on the toolbar displays cell’s Font Style. Font Size selection on the toolbar displays cell’s Font Size. Font Decoration Buttons on the toolbar reflect cell’s font decoration.
Select Multiple Cells
Parameters: None. Preconditions: Main window is active, and none of the menus are open. Postconditions: The group of cell becomes the selected group of cells. The top right cell becomes the current input cell for the grid. The input cell displays its input value. The Bar in the tool bar displays input cell’s input value.
Enter Data into Cell
Parameters: Data Preconditions: Main window is active, and none of the menus are open. Postconditions: The entered data is displayed in the cell. The data becomes the cell’s input value. The cell calculates the type of the data, and the output value. The function bar displays the cell’s new input value. Document is not clean.
Deselect Menu
Parameters: “Menu” Preconditions: Main window is active, and “Menu” bar is opened.
Display Print File Window
Parameters: None. Preconditions: Main window is active, and none of the menus are open. Postconditions: Print File Dialog is displayed and it is slected.
Display Font Dialog Box
Parameters: None. Preconditions: Main window is active, and none of the menus are open. Or Border Dialog box is active. Postconditions: Font Dialog box is active and selected.
Display Border Dialog Box
Parameters: None. Preconditions: Main window is active, and none of the menus are open. Or Font Dialog box is active. Postconditions: Border Dialog box is active and selected.
Display Row Height Dialog Box
Parameters: None. Preconditions: Main window is active, and none of the menus are open. Postconditions: Row Height Dialog box is active and selected.
Display Column Width Dialog Box
Parameters: None. Preconditions: Main window is active, and none of the menus are open. Postconditions: Column Width Dialog box is active and selected.
Display Save Question dialog
Parameters:
None. Preconditions: Main window is active, and none of the menus are open. The file is not clean. Postconditions: Save Question Dialog box is active and selected.
Display Error Dialog
Parameters: None. Preconditions: One of the windows, or dialogs is active. Error Occurred. Postconditions: Error Dialog box is active and selected.
New File
Parameters: None. Preconditions: Main window is active, and none of the menus are open. The current file is clean. Postconditions: An empty grid is displayed, and the filename for the current file is set to “untitled”. Main window is active and no menus are open. Document is clean.
Open File
Parameters: “Filename” Preconditions: Open file dialog is active. The current file is clean. Postconditions: A file “Filename” filename is the current spreadsheet file, and the contents of the file are loaded into the grid. Main window is active and no menus selected. Document is clean.
Save File
Parameters: None Preconditions: Main window is active and no menus are open. The file name is not “untitled”. Postconditions: The contents of the grid are saved to the current file. The document is clean. Main window is active and no menus are open.
Insert Function
Parameters: “Function” Preconditions: Main Window is active with no menus open. Postconditions: The current input cell gets the “Function” as its input value. Input value is displayed. Output value is calculated. Data type for content is set to function. The Equation bar displays the new input value.
Select Font
Parameters: “Font Style” “Font Size” “Font Decoration” “Background Color” “Foreground Color” Preconditions: Main Window is active with no menus open. Postconditions: Every cell in the selected group in the grid, received Font Style “Font Style”, Font Size “Font Size”, Font Decoration “Font Decoration”, Background Color “Background Color”, and Foreground Color “Foreground Color”.
Select Border
Parameters: “Border Style” “Border Thickness” “Border Color” Preconditions: Main Window is active with no menus open. Postconditions: Every cell in the selected group in the grid, receives Border Style “Border Style”, Border Thickness “Border Thickness”, and Border Color “Border Color”.
Set Column Width
Parameters: “width” Preconditions: Main Window is active with no menus open. Postconditions: The column width is set to width.
Set Row Height
Parameters: “height” Preconditions:
Main Window is active with no menus open. Postconditions: The row height is set to height.