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 pics/WIN3200090000.gif 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