In this step, you begin by selecting the range of cells, or the "Display Area", that will be displayed in the web application. Here you can also decide if you want to preserve cell formatting, charts, images and form controls. This will determine whether or not they are converted from the Excel file into the finalized web application.
>> How to select the Display Area
>> Convert PivotTables®, charts, images and form controls
>> Hide worksheet in worksheet tab bar
To select the range of cells that you want to include in your web page, click the 
button. A pop-up window will appear and you will be asked to make a selection of cells - just like in Excel.
The Display Range will determine the area of the Excel worksheet that will be
viewable by the end-user in the web application.
Note: do not select more than you want your end-user to be able to see. The more display area, the longer the loading times in the browser.
By default, SpreadsheetWEB is set to convert all formatting features displayed in the worksheet. If you want to disable a specific formatting option, then simply deactivate the respective checkbox.
A PivotTable® is a reporting tool that sorts and sums values while remaining independent of the original data layout in the spreadsheet. SpreadsheetWEB has the ability to convert PivotTables® embedded in a spreadsheet. If you would like to convert a PivotTable® that appears in your Excel file, then simply leave the checkbox next to PivotTable® option activated.
Most common PivotTable® features are supported.
This option will render images that are embedded in the spreadsheet into the finalized web application. All images that are compatible with Excel are also supported by SpreadsheetWEB.
At the date of the release of SpreadsheetWEB 1.2, the following chart options, formatting and types were supported. Since chart support depends mainly on the server side engine, new chart types and features are added continuously without requiring SpreadsheetWEB Wizard updates. If you use an unsupported chart type, a web application will still be built and hosted but no chart will be displayed.
Column Charts
Column Clustered 
Column Stacked 
Column Stacked 100%
Column 3-D 
Column 3-D Stacked
Bar Chart
Bar Clustered 
Bar Stacked 
Bar Stacked 100%
Line Chart
Line 
Line Stacked 
Line Markers
Line Markers Stacked
Pie Charts
Pie 
Pie Exploded 
Pie 3-D
Pie 3-D Exploded
Area Charts
Area 
Area Stacked 
Area Stacked 100%
Scatter Charts
Scatter 
Line Scatter 
Line Marker Scatter
Smooth Line Scatter 
Smooth Line Marker Scatter
Doughnut Charts
Doughnut
Bubble Charts
Bubble
Stock Charts (HOC Layer, CandleStickLayers)
High-Low-Close 
Open-High-Low-Close 
Volume-High-Low-Close
Volume-Open-High-Low-Close
Radar Charts
Radar 
Radar with Markers 
Filled Radar
Form Controls - The Excel built-in form controls listed below are currently supported (i.e. can be converted automatically).
Combo Box
Check Box
Option Button
List Box
Simply activate the check boxes next to each option in the Wizard menu to convert cell formatting. The options for preserving cell formatting are:
Alignment - Preserves the cell alignments found in the spreadsheet.
Font - Preserves font formatting found in the spreadsheet, as well as used fonts. The most common font types are supported.
Border - Applies border formatting found in the spreadsheet to the web application.
Background Color - Applies background formatting found in the spreadsheet to the web application (default background color is white).
This options allows you to hide a worksheet conditionally. This will be based on the value of a cell in the Excel spreadsheet. The
accepted value can either be FALSE or TRUE. This option can be used to hide
worksheet tabs from customers or clients while keeping them active for the
company's workers.
For example: In the linked cell, you
can enter an "if-statement" such as
=if(c1 > 1, TRUE, FALSE)
If the value of cell C1 is greater than 1, then the cell link returns TRUE and the link to the worksheet will be excluded from the worksheet tab bar. This means that the active viewer will not be able to see the hidden worksheet. If the value of C1 is less than 1, then linked cell returns FALSE and the link to the worksheet will be displayed in the worksheet tab bar, allowing the active user to open the hidden worksheet.
For Example:
Let's say you have a worksheet that contains sensitive information. You only want your Admin user accounts to be able to view this particular tab. SpreadsheetWEB offers a function calls "SpreadsheetWEBUserRole" which returns type of user role to a cell in the worksheet. This cell can be within the display range or outside of it. Generally, it would be placed outside of the display range because it is a "behind-the-scenes" operation. If cell C30 is outside of the display range, you could enter
=SpreadsheetWEBUserRole
into cell C30. After the application is uploaded to the server, this cell will relay the name of the user role. For example, if the user accessing the web page is Anonymous, meaning that they don't have a user role mandated through the SpreadsheetWEB Control Panel, then the cell will read "Anonymous".
Now, in another cell that was outside of the display range, let's say C31, you would enter
=IF(C30=Admin, FALSE, TRUE)
This means that if the value in C30 showed that the user viewing the webpage was an Administrator, then cell C31 would show "FALSE". Otherwise, for any other viewer, it would show "TRUE". You can direct the setting "Disable worksheet by value of a cell" to the cell C31. Therefore, when someone other than the Admin viewed this particular application, this worksheet would not show up in the tab bar up top.