You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
Version 1
Next »
You can copy and paste styles from Spread.Sheets to Excel. You can also copy some styles from Excel to Spread.Sheets.
Set the allowCopyPasteExcelStyle property to true to allow copying and pasting styles. For example (spread.options.allowCopyPasteExcelStyle = true
.
The following table displays the style options that are copied from Excel and pasted into Spread.Sheets.
|
Google Chrome |
Mozilla Firefox |
Microsoft Edge |
Microsoft Internet Explorer |
Safari on Mac |
|
Chrome on Mac |
|
backColor |
Supported |
|
Supported |
|
|
Supported |
|
Supported |
|
foreColor |
Supported |
|
Supported |
|
|
Supported |
|
Supported |
|
font |
Supported |
|
Supported |
|
|
Supported |
|
Supported |
|
vAlign |
top -> top
center -> center
bottom -> bottom
justify -> bottom
distributed -> bottom |
|
top -> center
center -> center
bottom -> center
justify -> center
distributed -> center |
|
|
top -> top
center -> center
bottom -> bottom
justify -> bottom
distributed -> bottom |
|
top -> top
center -> center
bottom -> bottom
justify -> bottom
distributed -> bottom |
|
hAlign |
left -> left
center -> center
right -> right
general -> general
fill -> general
justify -> general
center across selection -> general
distributed -> general |
|
left -> left
center -> left
right -> left
general -> left
fill -> left
justify -> left
center across selection -> center
distributed -> left |
|
|
left -> left
center -> center
right -> right
general -> general
fill -> general
justify -> general
center across selection -> general
distributed -> general |
|
left -> left
center -> center
right -> right
general -> general
fill -> general
justify -> general
center across selection -> general
distributed -> general |
|
borderLeft |
thin -> medium
medium -> medium
dashed -> mediumDashed
dotted -> dotted
thick -> medium
double -> double
hair -> None
mediumDashed -> mediumDashed
dashDot -> None
mediumDashDot -> None
dashDotDot -> None
mediumDashDotDot -> None
slantedDashDot -> None |
|
thin -> medium
medium -> medium
dashed -> mediumDashed
dotted -> dotted
thick -> medium
double -> double
hair -> None
mediumDashed -> mediumDashed
dashDot -> None
mediumDashDot -> None
dashDotDot -> None
mediumDashDotDot -> None
slantedDashDot -> None |
|
|
thin -> medium
medium -> medium
dashed -> mediumDashed
dotted -> dotted
thick -> medium
double -> double
hair -> None
mediumDashed -> mediumDashed
dashDot -> None
mediumDashDot -> None
dashDotDot -> None
mediumDashDotDot -> None
slantedDashDot -> None |
|
thin -> medium
medium -> medium
dashed -> mediumDashed
dotted -> dotted
thick -> medium
double -> double
hair -> None
mediumDashed -> mediumDashed
dashDot -> None
mediumDashDot -> None
dashDotDot -> None
mediumDashDotDot -> None
slantedDashDot -> None |
|
borderRight |
|
|
|
|
|
|
|
|
|
borderTop |
|
|
|
|
|
|
|
|
|
borderBottom |
|
|
|
|
|
|
|
|
|
textDecoration |
strikethrough -> lineThrough
single -> underline
double -> underline
single accounting -> underline
double accounting -> underline |
|
strikethrough -> lineThrough
single -> underline
double -> underline
single accounting -> underline
double accounting -> underline |
|
|
strikethrough -> lineThrough
single -> underline
double -> underline
single accounting -> underline
double accounting -> underline |
|
strikethrough -> lineThrough
single -> underline
double -> underline
single accounting -> underline
double accounting -> underline |
|
The following table displays the style options that are copied from Spread.Sheets and pasted to Excel.
|
Chrome |
Firefox |
Edge |
Internet Explorer |
Safari on Mac |
Chrome on Mac |
backColor |
Supported |
|
Supported |
|
Not Supported |
Not Supported |
foreColor |
Supported |
|
Supported |
|
Not Supported |
Supported |
font |
Supported |
|
Supported |
|
Not Supported |
Supported |
vAlign |
top -> top
center -> center
bottom -> bottom |
|
top -> top
center -> center
bottom -> bottom |
|
Not Supported |
Not Supported |
hAlign |
left -> left
center -> center
right -> right
general -> general |
|
left -> left
center -> center
right -> right
general -> general |
|
Not Supported |
Not Supported |
borderLeft |
thin -> medium
medium -> medium
dashed -> mediumDashed
dotted -> dotted
thick -> medium
double -> double
hair -> dotted
mediumDashed -> mediumDashed
dashDot -> mediumDashed
mediumDashDot -> mediumDashed
dashDotDot -> mediumDashed
mediumDashDotDot -> mediumDashed
slantedDashDot -> mediumDashed |
|
thin -> medium
medium -> medium
dashed -> mediumDashed
dotted -> dotted
thick -> medium
double -> double
hair -> dotted
mediumDashed -> mediumDashed
dashDot -> mediumDashed
mediumDashDot -> mediumDashed
dashDotDot -> mediumDashed
mediumDashDotDot -> mediumDashed
slantedDashDot -> mediumDashed |
|
Not Supported |
Not Supported |
borderRight |
|
|
|
|
|
|
borderTop |
|
|
|
|
|
|
borderBottom |
|
|
|
|
|
|
textDecoration |
underline -> single
lineThrough -> strikethrough
overline -> None |
|
underline -> single
lineThrough -> strikethrough
overline -> None |
|
Not Supported |
underline -> single
lineThrough -> strikethrough
overline -> None |
See Also
Using Clipboard Operations
options Field