|
Excel Formatting,
Chart Types & Functions
Supported at Runtime
|
 |
FORMATTING
| |
OfficeWriter
Enterprise Edition |
OfficeWriter
Standard Edition |
| NUMERIC
FORMATTING |
| GENERAL |
 |
|
| NUMBER |
|
|
| CURRENCY |
|
|
| ACCOUNTING |
|
|
| DATE |
|
|
| TIME |
|
|
| PERCENTAGE |
|
|
| FRACTION |
|
|
| SCIENTIFIC |
|
|
| TEXT |
|
|
| SPECIAL |
|
|
| CUSTOM |
|
|
| STYLISTIC
FORMATTING |
| FONT |
| FONT TYPE |
|
|
| FONT STYLE (REGULAR,
BOLD, OR ITALIC) |
|
|
| FONT SIZE |
|
|
| FONT UNDERLINE (NONE,
SINGLE) |
|
|
| FONT COLOR |
|
|
| FONT EFFECTS (STRIKETHROUGH,
SUPERSCRIPT, SUBSCRIPT) |
|
|
| CELL HEIGHT AND
WIDTH |
| ROW HEIGHT |
|
|
| AUTOFIT ROW HEIGHT |
|
|
| COLUMN WIDTH |
|
|
| AUTOFIT COLUMN WIDTH |
|
|
| MERGE CELLS |
|
|
| ALIGNMENT |
| HORIZONTAL (GENERAL,
LEFT, CENTER, RIGHT, FILL, JUSTIFY, CENTER ACROSS SELECTION) |
|
|
| VERTICAL (TOP, CENTER,
BOTTOM, JUSTIFY) |
|
|
| TEXT CONTROL (WRAP TEXT) |
|
|
| ORIENTATION |
|
|
| BORDER |
| BORDER OUTLINE (NONE,
OUTLINE) |
|
|
| BORDER LINE STYLE |
|
|
| BORDER LINE COLOR |
|
|
| CELL SHADING COLOR |
|
|
| CELL BACKGROUND PATTERN |
|
|
| BREAK |
| HORIZONTAL PAGE BREAK |
|
|
| PROTECTION |
| LOCKED |
|
|
| HIDDEN |
|
|
| HYPERLINK |
| NON-RELATIVE: HTTP,
HTTPS, FTP, MAILTO, UNC PATH |
|
|
CHARTING
| |
OfficeWriter
Enterprise Edition |
OfficeWriter
Standard Edition |
| STANDARD
CHARTING |
| COLUMN: Clustered
column, Stacked column, 100% stacked column, 3D clustered
column, 3D stacked column, 3D 100% stacked column, 3D column |
|
|
| BAR: Clustered bar,
Stacked bar, 100% stacked bar, 3D clustered bar, 3D stacked
bar, 3D 100% stacked bar |
|
|
| LINE: Line, Stacked
line, 100% stacked line, Line with data markers, Stacked line
with data markers, 100% stacked line with data markers,
3D line |
|
|
| PIE: Pie, 3D Pie,
Exploded Pie, 3D Exploded Pie |
|
|
| XY (Scatter): Scatter,
Scatter connected by curves, with data markers, Scatter connected
by curves, without data markers, Scatter connected by lines,
with data markers, Scatter connected by lines, without
data markers |
|
|
| AREA: Area, Stacked
area, 100% stacked area, 3D area, 3D stacked area, 3D 100%
stacked area |
|
|
| DOUGHNUT: Doughnut,
Exploded doughnut |
|
|
| RADAR: Radar, Radar
with data markers, Filled radar |
|
|
| SURFACE: 3D surface,
Wireframe 3D surface, Contour, Wireframe contour |
|
|
| BUBBLE: 3D 3D Bubble |
|
|
| CYLINDER: 3D All
types of column charts with cylindrical shape |
|
|
| CONE: 3D All types
of column charts with cone shape |
|
|
| PYRAMID: 3D All
types of column charts with pyramid shape |
|
|
| CUSTOM CHARTING |
| LINE-COLUMN: Clustered
column, stacked column, 100% stacked column (with line) |
|
|
| LINE-COLUMN
2 AXES: Clustered column, stacked column, 100% stacked
column (with line) |
|
|
EXCEL FUNCTIONS
| |
OfficeWriter
Enterprise Edition |
OfficeWriter
Standard Edition |
| MATH FUNCTIONS |
| ABS worksheet function |
|
|
| EXP worksheet function |
|
|
| INT worksheet function |
|
|
| MOD worksheet function |
|
|
| ROUND worksheet function |
|
|
| SUBTOTAL worksheet function |
|
|
| SUM worksheet function |
|
|
| SUMIF worksheet function |
|
|
| STRING FUNCTIONS |
| LEN worksheet function |
|
|
| MID worksheet function |
|
|
| REPLACE worksheet function |
|
|
| VALUE worksheet function |
|
|
| BOOLEAN
FUNCTIONS (AKA logical functions) |
| FALSE worksheet function |
|
|
| TRUE worksheet function |
|
|
| IF worksheet function |
|
|
| TIME FUNCTIONS |
| DATE worksheet function |
|
|
| DAY worksheet function |
|
|
| HOUR worksheet function |
|
|
| MINUTE worksheet function |
|
|
| MONTH worksheet function |
|
|
| NOW worksheet function |
|
|
| SECOND worksheet function |
|
|
| TIME worksheet function |
|
|
| TODAY worksheet function |
|
|
| WEEKDAY worksheet function |
|
|
| YEAR worksheet function |
|
|
| STATISTICAL
FUNCTIONS |
| AVERAGE worksheet function |
|
|
| COUNT worksheet function |
|
|
| COUNTA worksheet function |
|
|
| MAX worksheet function |
|
|
| MEDIAN worksheet function |
|
|
| MIN worksheet function |
|
|
| PERCENTILE worksheet
function |
|
|
| STDEV worksheet function |
|
|
| STDEVP worksheet function |
|
|
| ISNUMBER worksheet function |
|
|
| DATABASE
FUNCTIONS |
| DAVERAGE worksheet function |
|
|
| DCOUNT worksheet function |
|
|
| DCOUNTA worksheet function |
|
|
| DGET worksheet function |
|
|
| DMAX worksheet function |
|
|
| DMIN worksheet function |
|
|
| DPRODUCT worksheet function |
|
|
| DSTDEV worksheet function |
|
|
| DSTDEVP worksheet function |
|
|
| DSUM worksheet function |
|
|
| DVAR worksheet function |
|
|
| DVARP worksheet function |
|
|
| LOOKUP and
REFERENCE FUNCTIONS |
| ROW worksheet function |
|
|
| COLUMN worksheet function |
|
|
| ROWS worksheet function |
|
|
| COLUMNS worksheet function |
|
|
| HLOOKUP worksheet function |
|
|
| VLOOKUP worksheet function |
|
|
|
| | | | |
|
