SODATACELL
Contains information about the data to be placed in a cell of a spreadsheet.
typedef struct SODATACELLtag {
WORD wStructSize; //see below
WORD wStorage; //see below
WORD wDisplay; //see below
DWORD dwSubDisplay; //see below
WORD wPrecision; //see below
WORD wAlignment; //see below
WORD wAttribute; //see below
union {
SOINT32S Int32S; //see below
SOINT32U Int32U; //see below
BYTE IEEE4[4]; //see below
BYTE IEEE8[8]; //see below
BYTE IEEE10[10]; //see below
BYTE BCD8[8]; //see below
} uStorage;
} SODATACELL, VWPTR * PSODATACELL;
Members
wStructSize
Size, in bytes, of the structure.
wStorage
Storage type. This member can be one of these values:
SO_CELLBCD8I
| Packed BCD excess-63.
|
SO_CELLEMPTY
| The cell is empty.
|
SO_CELLERROR
| The cell has an error condition.
|
SO_CELLIEEE4I
| IEEE 4-byte in Intel® (PC) ordering.
|
SO_CELLIEEE8I
| IEEE 8-byte in Intel (PC) ordering.
|
SO_CELLIEEE10I
| IEEE 10-byte in Intel (PC) ordering.
|
SO_CELLINT32S
| 32-bit signed integer.
|
SO_CELLINT32U
| 32-bit unsigned integer.
|
wDisplay
Display type. This member can be one of these values:
SO_CELLBOOL
| Boolean (0 = FALSE and 1 = TRUE).
|
SO_CELLDATE
| Julian Days since the base date. wStorage may be either an IEEE or integer value.
|
SO_CELLDATETIME
| Julian Days since the base date. wStorage may be either an IEEE or integer value.
|
SO_CELLDECIMAL
| Decimal notation.
|
SO_CELLDOLLARS
| Dollar sign.
|
SO_CELLEXPONENT
| Exponential notation.
|
SO_CELLNUMBER
| General number format.
|
SO_CELLPERCENT
| Percent (not constrained to 0  100).
|
SO_CELLTIME
| Decimal part of a day if wStorage is an IEEE value or seconds since 00:00 if wStorage is an integer value.
|
dwSubDisplay
Display subtype. The values depend on
wDisplay value.
For SO_CELLNUMBER and SO_CELLDOLLARS, this member can be a combination of one
negative-number format, thousands separator, and cell multiplier.
Negative Number Format
|
|
SO_CELLNEG_MINUS
| Negative numbers have a minus sign.
|
SO_CELLNEG_MINUSRED
| Negative numbers have a minus sign and are red.
|
SO_CELLNEG_PAREN
| Negative numbers have parentheses.
|
SO_CELLNEG_PARENRED
| Negative numbers have parentheses and are red.
|
Thousands Separator
|
|
SO_CELL1000SEP_COMMA
| Commas as 1,000s separator.
|
SO_CELL1000SEP_NONE
| No 1000s separator.
|
Cell Multiplier
|
|
SO_CELLMULT_1
| Used for all file parsers.
|
SO_CELLMULT_01
| Used only for Microsoft® Excel viewer.
|
SO_CELLMULT_05
| Used only for Lotus viewer.
|
SO_CELLMULT_005
| Used only for Lotus viewer.
|
SO_CELLMULT_0005
| Used only for Lotus viewer.
|
SO_CELLMULT_00005
| Used only for Lotus viewer.
|
SO_CELLMULT_500
| Used only for Lotus viewer.
|
SO_CELLMULT_5000
| Used only for Lotus viewer.
|
SO_CELLMULT_0625
| Used only for Lotus viewer.
|
SO_CELLMULT_015625
| Used only for Lotus viewer.
|
For SO_CELLDATETIME, SO_CELLDATE, and SO_CELLTIME, this member can be a
combination of one date separator, day format, month format, year format, day of week
format, and time format.
Date Separator
|
|
SO_CELLDATESEP_MINUS
|
|
SO_CELLDATESEP_NONE
|
|
SO_CELLDATESEP_PERIOD
|
|
SO_CELLDATESEP_SPACE
|
|
Day Format
|
|
SO_CELLDAY_NONE
|
|
SO_CELLDAY_NUMBER
|
|
Month Format
|
|
SO_CELLMONTH_ABBREV
|
|
SO_CELLMONTH_FULL
|
|
SO_CELLMONTH_NONE
|
|
SO_CELLMONTH_NUMBER
|
|
Year Format
|
|
SO_CELLYEAR_ABBREV
|
|
SO_CELLYEAR_FULL
|
|
SO_CELLYEAR_NONE
|
|
Day of Week Format
|
|
SO_CELLDAYOFWEEK_ABBREV
|
|
SO_CELLDAYOFWEEK_FULL
|
|
SO_CELLDAYOFWEEK_NONE
|
|
Time Format
|
|
SO_CELLTIME_HHMM24
|
|
SO_CELLTIME_HHMMAM
|
|
SO_CELLTIME_HHMMHMS
| For example, 14h45m
|
SO_CELLTIME_HHMMSS24
|
|
SO_CELLTIME_HHMMSSAM
|
|
SO_CELLTIME_HHMMSSHMS
| For example, 14h45m34s
|
SO_CELLTIME_NONE
|
|
wPrecision
Precision or positioning value, depending on the
wDisplay value.
For SO_CELLNUMBER and SO_CELLDOLLARS, this member specifies the number of
places to the right of the decimal point.
For SO_CELLDATETIME, SO_CELLDATE, and SO_CELLTIME, this member specifies the
position in the date time string of each element. It must be a combination of
one value for each of the day of week position, month position, day position,
year position, and time position.
Day of Week Position
|
|
SO_CELLDAYOFWEEK_1
|
|
SO_CELLDAYOFWEEK_2
|
|
SO_CELLDAYOFWEEK_3
|
|
SO_CELLDAYOFWEEK_4
|
|
SO_CELLDAYOFWEEK_5
|
|
Month Position
|
|
SO_CELLMONTH_1
|
|
SO_CELLMONTH_2
|
|
SO_CELLMONTH_3
|
|
SO_CELLMONTH_4
|
|
SO_CELLMONTH_5
|
|
Day Position
|
|
SO_CELLDAY_1
|
|
SO_CELLDAY_2
|
|
SO_CELLDAY_3
|
|
SO_CELLDAY_4
|
|
SO_CELLDAY_5
|
|
Year Position
|
|
SO_CELLYEAR_1
|
|
SO_CELLYEAR_2
|
|
SO_CELLYEAR_3
|
|
SO_CELLYEAR_4
|
|
SO_CELLYEAR_5
|
|
Time Position
|
|
SO_CELLTIME_1
|
|
SO_CELLTIME_2
|
|
SO_CELLTIME_3
|
|
SO_CELLTIME_4
|
|
SO_CELLTIME_5
|
|
wAlignment
Alignment of data in the cell. This member can be the SO_CELLLEFT,
SO_CELLRIGHT, or SO_CELLCENTER value.
wAttribute
Attribute of data in the cell. This member can be a combination of the
SO_CELLBOLD, SO_CELLITALIC, SO_CELLUNDERLINE, and SO_CELLSTRIKEOUT values.
Int32S
Signed 32-bit integer.
Int32U
Unsigned 32-bit integer.
IEEE4
Four-byte array representing an IEEE 4-byte floating-point number.
IEEE8
Eight-byte array representing an IEEE 8-byte floating-point number.
IEEE10
Ten-byte array representing an IEEE 10-byte floating-point number.
BCD8
Eight-byte array representing an excess-63 floating-point packed BCD.
- Software for developers
-
Delphi Components
.Net Components
Software for Android Developers
- More information resources
-
MegaDetailed.Net
Unix Manual Pages
Delphi Examples
- Databases for Amazon shops developers
-
Amazon Categories Database
Browse Nodes Database
