SpreadsheetServer Tour

The following 30 screenshots illustrates what SpreadsheetServer is all about.

SpreadsheetConverter converts an Excel spreadsheet into a web page. The web page is a standard web form and it still calculates just like the original spreadsheet. This web page can be accessed by a modern browser from many different operating systems: Windows, Apple OSX, Linux.

In the following text spreadsheet and form are the same thing, since the form was created from a spreadsheet.

SpreadsheetServer is a complete application built using the same technology as SpreadsheetConverter. You do not need SpreadsheetConverter to use SpreadsheetServer.

SpreadsheetServer stores the content of the forms into a database,

  • data can be searched, sorted, filtered just as in Microsoft Excel,
  • data can be imported and exported to Excel,
  • users are authentificated to make sure they do not access or change things they shouldn’t change.
  • anynomous users, called Guests, can fill in a form.

Fill in a form anonymously

SpreadsheetServer contains an advanced authentification system, but we start the tour with a form that we have configured so that anonymous users can fill in them.

Click at the link

School Store order form

and the School Store order form is opened.

0001_400x

Login not required for School Store

We order 2 adjustable base cap and 2 short polo sleeve, and as usual, the totals are updated immediately.

0002_400x

Totals are recalculated immediately

We press ‘Save’ and the input cells are locked and the data is saved into the database. If we want to edit the form pres ‘Edit’, edit some values and press ‘Save’.

0004_400x

Save locks the form

Log in before we can fill in a form

The form Expense report can only be used by users that have logged in. When you click on the link

Expense report

you will have to sign in first. Use ‘demo’ as user name and ‘demo’ as password.

0005_400x

Forms can be protected by login

Next, the form will be opened and you can fill in your last trip.

0006_400x

An online expense report

We had a meeting over lunch with a guy a Ford.

0008_400x

Fill in the facts

We press ‘Save’ and the input cells are locked and the data is saved into the database.

0009_400x

Save data into DB

Press ‘List’ and you will see all expense reports. We configured the system to allow every one that is logged in to see all expense reports. An alternative is to let the user only see his own expense report, and only let a few users see all expense reports. You decide this type of configuration on per-form basis.

There were 2 expense reports in the system.

0011_400x

List all expense reports

The List view works exactly like Excel’s filters. You can sort the rows on a column, and filter them. We selected to sort the expense reports on the first name.

0012_400x

Use Excel’s sorting and filtering online

The rows are sorted. You can see the active filters and sorting at the bottom. Click on ‘Show’ to show the row as a form

0013_400x

Click on ‘Show’ to show the row as a form

And an old expense report is opened.

0015_400x

Open existing expense report

Press ‘Edit’ and fill in the second row.

0017_400x

Edit old expense report

And press Save.

0018_400x

The expense report is updated

Forms can have comments and attached documents

We can add comments to a filled in form. Press ‘Comment/Attach’ and write a comment. You can comment both your own forms, and other users forms.

0021_400x

Add a note to a expense report

The comment is shown at the bottom of the form. A form can have many comments.

0022_400x

Comments shown at the bottom

We can also attach files to forms. These files are stored in the database and are accessable by everyone who is authenticated to see the form and who has logged in.

We attach a spreadsheet called erf.xls.

0023_400x

Files and Microsoft Office documents can be attached

The comment is shown at the bottom of the form. A form can have many attached files.

0024_400x

File links at the bottom

Click on the link to download the document. You can either save the document to disk or open it directly in the relevant program.

0025_400x

Download documents by clicking on the link

A simple To Do list

SpreadsheetConverter supports two different kinds of spreadsheets: forms and databases. A database spreadsheet contains one record per row, and form spreadsheet contain one record per spreadsheet.

A to do list is an example of a spreadsheet database.

Press ‘List’ and select ‘To Do list’ from the select form drop down list.

0026_400x

Switch to another form

The to do list has 5 columns: Priority, Date In, Assigned, Date close, and Description.

0027_400x

To Do List

Press ‘Edit’ to make the grid editable. You can either edit existing rows, or add new rows at the bottom.

0028_400x

Edit makes the whole grid editable

You can edit as many rows as you want. Changed cells are marked with an orange background. The disk icon means that these rows need to be saved.

0029_400x

Edit several rows at once

When you press ‘Save’ all rows are saved.

0030_400x

Saved

Press ‘Lock’ to prevent further editing.

0031_400x

Lock prevents editing

Custom filters work just as in Excel. We want to find all rows which are assigned to ‘dc’. Select ‘Custom’ from the ‘Assigned’ menu.

0032_400x

Custom filters

Select ‘Equals’ and enter ‘dc’

0033_400x

Find all rows assigned to dc

And press OK

0034_400x

Press OK to apply filter

In our database, we had 4 rows assigned to dc.

0035_400x

Only show the rows assigned to dc

Save as Excel

The data is not locked in into SpreadsheetServer. You can very easily export it to Excel.

Press ‘Save as Excel’ and all rows, with the current filter applied, are exported to Excel.

0036_400x

Export to Excel

The browser asks if you want to open the Excel file directly or save them to disk.

0037_400x

Where should the file be saved

The 4 rows that were assigned to dc are now opened in Excel. Use Excel’s autofilter as usual. The formatting of the cells are also correct.

0039_400x (1)

Rows opened in Excel

Just as Excel!

As you saw in this tour, we have created an online web-based system for handling forms and databases. As much as possible, things are done as in Excel, for example filtering and sorting.

Build live website calculators and web forms now!

conversion imageconversion imageconversion image

Just download, install and test the Excel add-on now. Or let us convert a spreadsheet for you, for free.