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.