Series in
Rows
Columns
Type
Linear
Growth
Date
AutoFill
Date unit
Day
Weekday
Month
Year
Trend
Step Value Stop Value
SortBy SortOn SortOrder
Orientation
Sort top to bottom
Sort left to right

- General
- ScrollBars
- Tab Strip
- Clipboard

Settings
Allow Drag and Drop
Allow Drag and Fill
Allow Undo
Allow Drag and Merge
Allow User to Enter Formulas
Allow Zoom
Allow Overflow
Visibility
Vertical ScrollBar
ScrollBar ShowMax
Horizontal ScrollBar
ScrollBar MaxAlign
Setting
Tab Strip Visible
New Tab Visible
Tab Strip Editable
Tab Strip Ratio(as percentage) %
Settings
Allow Copy Paste Excel Style
Allow Paste Extend Range
Header Options:
No Headers
All Headers
Row Headers
Column Headers

- General
- Grid Lines
- Calculation
- Headers
- SheetTab

Column Count:
Row Count:
Frozen Column Count:
Frozen Row Count:
Trailing Frozen Column Count:
Trailing Frozen Row Count:
Selection Policy
Single Select
Range Select
MultiRange Select
Protect
Horizontal GridLine
Vertical GridLine
GridLine Color:
Reference Style:
A1
R1C1

- Column Headers
- Row Headers

Column Header Row Count:
Column Header Auto Text:
Blank Numbers Letters
Column Header Auto Index:
Default Row Height:
Column Header Visible
Row Header Column Count:
Row Header Auto Text:
Blank Numbers Letters
Row Header Auto Index:
Default Column Width:
Row Header Visible
Sheet Tab Color:

- Settings
- Input Message
- Error Alert

Validation criteria
Allow:
Data:
Ignore blank
In-cell dropdown
Show input message when cell is selected
When cell is selected, show this input message:
Title:
Input message:
Show error alert after invalid data is entered
When user enters invalid data, show this error alert:
Style:
Title:
Error message:
Direction
Summary rows below detail
Summary columns to right of detail
Magnification
200%
100%
75%
50%
25%
Fit selection
Custom: %
Choose the data that you want Data Range:
Choose where you want the sparkline to be placed Location Range:
IsFormulaSparkline
Enter the Sparkline weight(pt)
Negative Points:
Markers:
High Point:
Low Point:
First Point:
Last Point:
Percentage
Line 1: Line 2:
Minimum Value: Maximum Value:
Points:
Positive Color
Negative Color
Points1 Points2
MinX MinY
MaxX MaxY
HLine VLine
XMinZone YMinZone
XMaxZone YMaxZone
Color 1:
Color 2:
Tags Draw Symbol Draw Lines Dash Line
Data
Data: DataOrientation:
DateAxisData: DateAxisOrientation:
DisplayEmptyCellsAs:
Show First Show Last Show High
Show Low Show Negative Show Markers
RightToLeft
Negative:
Markers:
Axis:
Series:
High Marker:
Low Marker:
First Marker:
Last Marker:
Line Weight:
Measure: Target:
Maxi: Forecast:
Good: Bad:
Tickunit: ColorScheme:
Vertical
Points: Style:
ScaleStart: ScaleEnd:
ColorScheme:
ShowAverage Vertical
Points: ColorRange:
LabelRange: Maximum:
TargetRed: TargetGreen:
TargetBlue: TargetYellow:
Color:
HighlightPosition:
TextOrientation:
TextSize: px
Vertical
Value:
ColorScheme:
Variance: Reference:
Mini: Maxi:
Mark: TickUnit:
ColorPositive:
ColorNegative:
Legend Vertical
Points: BoxPlotClass:
ScaleStart: ScaleEnd:
AcceptableStart: AcceptableEnd:
ColorScheme:
Style:
Show Average Vertical
PointsRange: PointIndex:
Minimum: Maximum:
ColorPositive:
ColorNegative:
LabelsRange: Vertical
Points: PointIndex:
ColorRange: HighlightPosition:
Target: Target2:
Label:
Vertical
Data Range:
Empty Color:
Location Range:
Start Color:
Year:
Middle Color:
Month:
End Color:
Range Color
Location Reference:
value:
Barcode Type:
Color:
Background Color:
quietZoneLeft:
quietZoneRight:
quietZoneTop:
quietZoneBottom:

Where is the data for your table?
Name:
Table Element:
Preview
Select the new data range for your table:
Note: The headers must remain in the same row,
and the resulting table range must overlap
the original table range.
Style Name:
Copies:
Scaling Type:
Duplex Mode:
Choose paper source by pdf page size
Print ranges Index: Count:

Index | Count

- Font
- Alignment
- Colors and Lines
- Size
- Protection
- Properties

Text alignment
Horizontal:
Automatic size
Internal margin
Automatic
Left: Top:
Right: Bottom:
Fill
Transparency
%
Line
Color:
Style:
Width:
Height:
Width:
Locked
Lock text
Object positioning
Allow all users of this worksheet to:
Source Name: Column
Name:
Header
Display header
Caption:
Item Sorting and Filtering
Ascending(A to Z)
Descending(Z to A)
Hide item with no data
Visually indicate items with no data
Show items with no data last
Name:
Table Element:
Preview

- POSITION AND LAYOUT
- SIZE
- PROPERTIES

Position
Horizontal:
Vertial:
Disable resizing and moving
Layout
Number of columns:
Button Height:
Button Width:
Height
Width
Scale Height
%
Scale Width
%
Move and size with cells
Move and don't size with cells
Don't move and size with cells
Locked