Cut
Copy
Paste
-
Insert
Delete
-
Merge
UnMerge
Selected Color:
Line Style:
Empty
Thin
Medium
Dashed
Dotted
Thick
Double
Hair
MediumDashed
DashDot
MediumDashDot
DashDotDot
MediumDashDotDot
SlantedDashDot
Line Color:
Black
White
Red
Blue
Maroon
Green
Olive
Navy
Purple
Teal
Silver
Gray
Red
Lime
Yellow
Blue
Magenta
Cyan
Top Side
Text
Text
Text
Text
Horizontal
Bottom Side
Left Side
Vertical
Right Side
Settings
Input Message
Error Alert
Validation criteria
Allow:
Any value
Number
List
FormulaList
Date
Text length
Custom
IgnoreBlank
Data:
Between
NotBetween
EqualTo
NotEqualTo
GreaterThan
LessThan
GreaterThanOrEqualTo
LessThanOrEqualTo
Is Time
Is Integer
Show input message when cell is selected.
When cell is selected,show this input message:
Title:
Message:
show error alert after invalid data is entered
When the user enters invalid data,show this error alert:
Stop
Warning
Information
Title:
Message:
Format only cells with:
Style:
Cell Value
Specific Text
Dates Occurring
Formula
Top10
Unique
Duplicate
Average
2-Color Scale
3-Color Scale
EqualsTo
NotEqualsTo
GreaterThan
GreaterThanOrEqualsTo
LessThan
LessThanOrEqualsTo
Between
NotBetween
and
Minimum
Midpoint
Maximum
Type:
Number
LowestValue
Percent
Percentile
Formula
Number
Percent
Percentile
Formula
Number
HighestValue
Percent
Percentile
Formula
Value:
Color:
Value
Minimum
Maximum
Type:
Number
LowestValue
Percent
Percentile
Automin
Formula
Number
HighestValue
Percent
Percentile
Formula
Automax
Values:
Appearance
Show Bar Only
Gradient
Color:
Show Border
Border Color:
Bar Direction:
Left-to-Right
Right-to-Left
Use Negative Fill Color
Negative Fill Color:
Use Negative Border Color
Negative Border Color:
Axis Position:
Automatic
CellMidPoint
None
Axis Color:
Icon Style:
ThreeArrowsColored
ThreeArrowsGray
ThreeTriangles
ThreeStars
ThreeFlags
ThreeTrafficLightsUnrimmed
ThreeTrafficLightsRimmed
ThreeSigns
ThreeSymbolsCircled
ThreeSymbolsUncircled
FourArrowsColored
FourArrowsGray
FourRedToBlack
FourRatings
FourTrafficLights
FiveArrowsColored
FiveArrowsGray
FiveRatings
FiveQuarters
FiveBoxes
Show Icon Only
Reverse Icon Order
Display each icon according to these rules:
EditorValueType:
Text
Index
Value
Items Text:
Items Value:
caption:
textTrue:
textIndeterminate:
textFalse:
textAlign:
top
bottom
left
right
isThreeState
margin-left:
margin-top:
margin-right:
margin-bottom:
text:
backColor:
linkColor:
visitedLinkColor:
text:
linkToolTip:
FrozenColumnCount:
FrozenRowCount:
FrozenTrailingColumnCount:
FrozenTrailingRowCount:
Table Style Options:
Header Row
First Column
Total Row
Last Column
Banded Row
Banded Column
Table Styles:
Light1
Light2
Light3
Light4
Light5
Light6
Light7
Light8
Light9
Light10
Light11
Light12
Light13
Light14
Light15
Light16
Light17
Light18
Light19
Light20
Light21
Medium1
Medium2
Medium3
Medium4
Medium5
Medium6
Medium7
Medium8
Medium9
Medium10
Medium11
Medium12
Medium13
Medium14
Medium15
Medium16
Medium17
Medium18
Medium19
Medium20
Medium21
Medium22
Medium23
Medium24
Medium25
Medium26
Medium27
Medium28
Dark1
Dark2
Dark3
Dark4
Dark5
Dark6
Dark7
Dark8
Dark9
Dark10
Dark11
Table Name:
Picture Options:
Image:
Picture Options:
Image:
DynamicSize
DynamicMove
BackColor:
BorderColor:
Border Width:
Border Radius:
Border Style:
solid
dotted
dashed
double
groove
ridge
inset
outset
Picture strecth:
Stretch
Center
Zoom
None
Comment Options:
Text:
Location:
Width:
Height:
Comment Options:
FontFamily:
FontStyle:
normal
italic
oblique
inherit
FontSize:
FontWeight:
BorderWidth:
BorderStyle:
none
hidden
dotted
dashed
solid
double
groove
ridge
inset
outset
BorderColor:
Padding:
TextDecoration:
none
underline
overline
linethrough
Opacity:
%
ForeColor:
BackColor:
Horizontal:
left
center
right
general
DisplayMode:
AlwaysShown
HoverShown
zIndex
dynamicSize
dynamicMove
LockText
showShadow
Type:
Line
Column
Win/Loss
Pie
Area
Scatter
Spread
Stacked
Bullet
Hbar
Vbar
Variance
BoxPlot
Cascade
Pareto
Choose the data that you want
Data Range:
Choose where you want the sparkline to be placed
Location Range:
Measure:
Target:
Maxi:
Forecast:
Good:
Bad:
Tickunit:
ColorScheme:
Vertical
Value:
ColorScheme:
Value:
ColorScheme:
Variance:
Reference:
Mini:
Maxi:
Mark:
TickUnit:
ColorPositive:
ColorNegative:
Legend
Vertical
HOME
DATA
VIEW
Paste
Cut
Copy
Clipboard
Font Name
Arial
Courier New
Garamond
Tahoma
Times New Roman
Verdana
Wingdings
Font Size
VerySmall
Smaller
Small
Medium
Large
Larger
VeryLarge
40pt
TabStop
Wrap Text
Overline
Style
Merge Cell
Alignment
Insert Column
Insert Row
Delete Column
Delete Row
Cells
Conditional Formatting
Highlight Cell Rules
Top/Bottom Rules
Data Bars
Color Scales
Icon Sets
Others
Remove Conditional Formats
Conditional Formatting
Table
Format as Table
Sort A-Z
Sort Z-A
Fitler
Sort & Filter
Group
UnGroup
Show Detail
Hide Detail
ShowRowRangeGroup
ShowColRangeGroup
Outline
Data Validation
Circle Invalid Data
Clear Validation Circles
Validation UI
Cell Type
TextBoxCellType
ComboBoxCellType
CheckBoxCellType
ButtonCellType
HyperLinkCellType
allowEditorReservedLocations
Clear CellType
Cell Type
Comment
Comment
SparklineEx
SparklineEx
Row Header
Column Header
Vertical Gridline
Horizontal Gridline
TabStrip
NewTab
HScrollbar
VScrollbar
ScrollbarMaxAlign
ScrollbarShowMax
Show/Hide
Freeze
UnFreeze
FrozenLineColor
Freeze Setting
Viewport
Not UseWijmoTheme
TabStripColor
SpreadBackColor
GrayAreaBackColor
SelectionBorderColor
SelectionBackColor
Color