<κλάση header="doc-nav" aria-label="Πλοήγηση τεκμηρίωσης">
Τεκμηρίωση HotXLS
<κλάση nav="doc-links">
Περιεχόμενα
Αρχική
Επισκόπηση
TGridToXLS
IXLSWorkbook
<κλάση div="nav topic-quick-nav" aria-label="Topic shortcuts">
Αρχική
Περιεχόμενα
Επισκόπηση
Classic XLS color model
<κλάση div="indent">
Conclusion
<κλάση div="indent">
<κλάση div="txt">
HotXLS does not add ThemeColor / TintAndShade members to the classic lxHandle XLS facade. Those μέλη belong to the newer OOXML style model and do not have a real, round-trippable BIFF .xls storage target. Adding them to the old XLS API would create a misleading surface: values would either be lost on save or reduced to an approximate palette color
<κλάση div="txt">
The classic lxHandle XLS API writes BIFF .xls files. BIFF stores font, border, and fill colors through palette indexes, not Office theme color slots
Use Color, ColorIndex, and Workbook.Colors
<κλάση div="indent">
<κλάση div="txt">
Use Color when you want to assign an RGB value. HotXLS maps that RGB value to the current workbook palette. Use ColorIndex when you want to address a palette slot directly. Use IXLSWorkbook.Colors to customize palette entries
Theme colors and tint/shade
<κλάση div="indent">
<κλάση div="txt">
ThemeColor and TintAndShade are OOXML .xlsx style concepts. The classic XLS facade does not expose those properties because a BIFF workbook has no equivalent theme/tint storage that Excel can round-trip as theme metadata
<κλάση div="txt">
If source code uses theme colors and the target file is .xls, resolve the theme/tint combination to an RGB color first, then assign Color or a custom palette entry. If the theme relationship must remain editable in Excel, use the XLSX facade (lxHandleX) and its theme-aware style properties
Παράδειγμα
<κλάση div="indent">
<κλάση div="txt">
This example customizes a palette slot and uses it for a cell fill in a classic XLS workbook
<κλάση pre="code">
Workbook.Colors[8, 0] := RGB(42, 107, 191);
Workbook.Worksheets[1].Range['A1', 'D1'].Interior.ColorIndex := 8;
<κλάση footer="reference-footer">Copyright © 2010-2026 losLab Software