SpreadsheetWEB's Display Area and formatting options
In this step, you will select the range of cells, or the 'Display Area', that is going to be displayed on the web application. You can also decide if you wish cell formatting to be preserved and whether charts, images and form controls will be converted or not.
Selecting a display area, identical selection tool as in Excel
To select the range of cells that you want to include in your web page, click on the button. A pop-up window will appear and you will be asked to make a selection of cells - just like in Excel.
By default, SpreadsheetWEB converts all functions and formatting of a worksheet. If you want to disable a specific function or format, then simply deactivate the respective checkbox.
A PivotTable is a reporting tool that sorts and sums independent of the original data layout in the spreadsheet. SpreadsheetWEB can convert PivotTables embedded in the spreadsheet, simply leave the check box next to 'PivotTable' activated. Most common PivotTable features are supported.
When checked, all images displayed within the selection grid will be brought into the web application. All images that function within Excel are supported by SpreadsheetWEB.
Most chart options, formatting and types are supported in SpreadsheetWEB. Since chart support depends mainly on the server side engine, new chart types and features are added continuously without requiring any updates of the SpreadsheetWEB Wizard. If you use an unsupported chart type, a web application will still be built and hosted but no chart will be displayed.
Following chart types are supported:
- Column Charts
- Stacked 100%
- 3D Stacked
- Bar Charts
- Stacked 100%
- Line Chart
- Markers Stacked
- Area Charts
- Stacked 100%
- Radar Charts
- Filled Radar
- Scatter Charts
- Smooth Line
- Smooth Line Marker
- Pie Charts
- 3D Exploded
- Stock Charts
- Doughnut Charts
List of a few form controls.
The listed Excel built-in form controls below are currently supported and will be converted automatically.
Simply activate the check boxes to convert cell formatting.
Alignment - Preserves the cell alignments in the spreadsheet.
Font - Preserves font formatting as well as used fonts; the most common font types are supported.
Border - Conserves border formatting from the spreadsheet to the web page.
Background Color - Conserves background formatting from the spreadsheet to the web page (except for input cells, the default background color is white).
To hide a worksheet based on the value of a cell in the Excel spreadsheet, an if-statement must be used where the accepted value can either be FALSE or TRUE. In the linked cell, enter an if-statement such as:
=if(c1 > 1, TRUE, FALSE)
If the value of cell C1 is greater than 1, the cell link will return TRUE and the link to the worksheet will be excluded from the worksheet tab bar. If the value of C1 is less than 1, the linked cell will returns FALSE and the link to the worksheet will be displayed in the worksheet tab bar.
OR Check out the online video!