This spreadsheet project was made for CS3500 - Software Practice I. This was a team-based project with two people, my programming partner and I. It was created using Visual Studio Community, MAUI, XAML, XML, .NET and C#
For the style of the spreadsheet, my partner and I decided to go for a pastel look to make it more colorful.
This spreadsheet has the capabilities to save spreadsheets, load spreadsheets, clear spreadsheets, compute formulas,
reference other cells, and hold any type of variable. It also tells the user if the equation they submitted doesn't follow
specific rules and throws an error. A small feature we added into the spreadsheet is the ability to change the spreadsheet's font.
UML diagram for each aspect of the program
For saving and loading files in the spreadsheet application, we use XML to record and store spreadsheet data.
In the image shown, you can see a comparison between what was written in the spreadsheet and what was saved in the text file.
XML makes it easy to serialize and deserialize spreadsheet data!
Error handling is important in this application. If a user were to insert the equation "0/0" or "hi + 1" it wouldn't be able to compute.
There is an error handler implmented into the spreadsheet that alerts users if any error is present. Cells with errors are highlighted in red and show a prompt at the top of
the spreadsheet explaining what error was thrown.
recorded using OBS and edited using Premiere Pro