The exported file should be a reasonable representation of the spreadsheet rendered in the Control, retaining features similar to those provided by the Import operations.

Items not preserved items include:

Individual values are trimmed to remove leading and trailing spaces.

Unprotect Sheet

Individual cells (and ranges of cells) can be made editable using the "Cell → Unlock" menu item.

This menu item removes the currently displayed spreadsheet. One spreadsheet must always be visible in the control. Accordingly, the user is blocked from trying to remove the final spreadsheet.

Behavior of the format dialog is similar to the Excel format dialog. Different formatting styles are available for different data types.

The "Custom" mode allows custom formats to be defined. This uses formatting codes similar to those provided by Excel.

Unmerge

Splits merged cells back into single cells.

The rendered HTML exhibits this behavior:

Unlock Cell

For your convenience, if a spreadsheet is not currently protected, locking the first cell will automatically mark the sheet as "Protected".

"Unlock Cell" makes that cell fully editable.

For convenience, the functions are grouped by category and can be filtered as such using the dropdown at the top of the page.

Hovering over functions provides additional information, including the list of parameters.

Selecting a function and clicking "OK" inserts the function into the selected cell in the spreadsheet.

For more information concerning specific functions,, see Microsoft's Excel documentation (most of these are Excel functions), or from the SpreadJS site at http://sphelp.grapecity.com/webhelp/SpreadJSWeb/webframe.html#FormulaFunctions.html.

To use this feature, select a range of cells (below left), then use these guidelines:

Above/Below n Std Dev

Duplicate/Unique Items

Cell values meeting the selected criteria are highlighted with a specific color (see Configuration Properties to define the color).

Highlighting options:

Dynamic Formatting is not visible when the spreadsheet is rendered in the Worksheet or exported to Word/PDF.

Three Color Heatmap

A three-color heatmap is also available when a third color is used for the middle range between upper and lower colors. All other cells then have a color gradient between the lower and middle (or middle and upper) colors.

The choice of colors for the two heatmaps is defined in the Configuration Properties.

Freeze First Column

Select the cell that should appear in the top-left of the scollable region, then select "Freeze Panes". All rows above and to the left of the selected cell are frozen.

Edit Pie Chart

Sparklines are displayed in a single cell, but that cell is often a merged cell in order to achieve a bigger chart (see the example below).

An example PIESPARKLINE function is:

=PIESPARKLINE(C3:C7;"#CCFF99";"#66CCFF";"#FFFF66";"#CC66FF";"#FF0066")

After selecting the menu item, a dialog shows the list of available options for the chart. If editing an existing chart, the chart's values are displayed (rather than default values).

The "Data Range" property expresses the range of cells whose values will be used to build the Pie Chart. To populate this field, place the cursor in the field, then select the cells in the spreadsheet behind the dialog.

The list of default colors for the Pie Chart can be defined in the Configuration Properties.

Edit Line Chart

An example LINESPARKLINE function is:

=LINESPARKLINE(B3:F3;1)

A more complex example is:

=LINESPARKLINE(B3:F3;1;;;"{displayEmptyCellsAs:0,displayXAxis:true,showMarkers:true,showFirst:true,showLast:true,showLow:true,showHigh:true,lineWeight:3,seriesColor:'#FF66CC',axisColor:'#FFFF66''}")

After selecting the menu item, a dialog shows the list of available options for the chart. If editing an existing chart, the chart's values are displayed (rather default values).

Property	Description
Data Range	Range of cells that contain the values to be plotted (on the vertical axis). To populate this field, place the cursor in the field, then select the cells in the spreadsheet behind the dialog.
Data Orientation	Determines whether the selected range of values contains values expressed horizontally or vertically within the range. When you drag-select the data range, the Data Orientation is automatically set depending on whether the range is horizontal or vertical.
Date Axis Range (Optional)	Range of cells that define the values to plot on the horizontal axis. If this value is blank, evenly-spaced data points will be plotted. The values within this range can be either dates or numbers.
Date Axis Range Orientation	Determines whether the selected range of date axis values contains values expressed horizontally or vertically within the range. When you drag-select the data range, the Data Axis Range Orientation is automatically set depending on whether the range is horizontal or vertical.
Display Empty Cells As	If the range contains an empty cell, this describes how those empty cells should be treated:
Show X-Axis	If the data values include negative numbers, this displays an x-axis showing the "zero" value.
Line Weight	Defines the thickness of the line.
Marker Properties	Options for displaying data points on the line: Option Shows a marker: Show First At the beginning of the line. Show Last At the end of the line. Show High On the maximum data value. Show Low On the minimum data value. Show All Markers For all data points.
Colors	Properties that define colors for the lines and markers. Default values for these properties can be defined in the Configuration Properties.

Edit Column Chart

An example COLUMNSPARKLINE function is:

=COLUMNSPARKLINE(B3:F3;1;;;"{displayXAxis:false,showNegative:false,showFirst:false,showLast:false,showLow:false,showHigh:false,seriesColor:'#FF6666'}")

After selecting the menu item, a dialog shows the list of available options for the chart. If editing an existing chart, the chart's values are displayed (rather than default values).

Property	Description
Data Range	Range of cells that contain values corresponding to the bar height. To populate this field, place the cursor in the field, then select the cells in the spreadsheet behind the dialog.
Data Orientation	Determines whether the selected range of values contains values expressed horizontally or vertically within the range.
Date Axis Range (Optional)	The range of cells that define the separation of the bars on the horizontal-axis. If this value is blank, evenly-spaced bars will be displayed. Values within this range can be either dates or numbers. Columns spaced according to data/number values are evenly-spaced.
Date Axis Range Orientation	Determines whether the selected range of date axis values contains values expressed horizontally or vertically within the range.
Show X-Axis	If the data values include negative numbers, this displays an x-axis showing the "zero" value.
Highlight Properties	Options for displaying bars in different colors: Option Shows: Highlight First The first bar in its own color. Highlight Last The last bar in its own color. Highlight High The bar with the highest value in its own color. Highlight Low The bar with the lowest value in its own color. Highlight Negative Bars with negative values in their own colors.
Colors	Defines colors for lines and markers. Default values for these properties can be defined in the Configuration Properties.