SODATACELLSODATACELL*
*Contents  *Index  *Topic Contents
*Previous Topic: SOCPTEXTATPOINT
*Next Topic: SOEMBEDDEDGRAPHIC

SODATACELL

Contains information about the data to be placed in a cell of a spreadsheet.

Syntax 

typedef struct SODATACELLtag {
    WORD wStructSize; 
    WORD wStorage; 
    WORD wDisplay; 
    DWORD dwSubDisplay; 
    WORD wPrecision; 
    WORD wAlignment; 
    WORD wAttribute; 
    union {
        SOINT32S Int32S; 
        SOINT32U Int32U; 
        BYTE IEEE4[4]; 
        BYTE IEEE8[8]; 
        BYTE IEEE10[10]; 
        BYTE BCD8[8]; 
    } uStorage;
} SODATACELL, VWPTR * PSODATACELL;

Members

wStructSize
Size, in bytes, of the structure.
wStorage
Storage type. This member can be one of these values:
SO_CELLBCD8IPacked BCD excess-63. See BCD8 for more information.
SO_CELLEMPTYThe cell is empty.
SO_CELLERRORThe cell has an error condition.
SO_CELLIEEE4IIEEE 4-byte in Intel® (PC) ordering. See IEEE4 for more information.
SO_CELLIEEE8IIEEE 8-byte in Intel (PC) ordering. See IEEE8 for more information.
SO_CELLIEEE10IIEEE 10-byte in Intel (PC) ordering. See IEEE10 for more information.
SO_CELLINT32S32-bit signed integer. See Int32S for more information.
SO_CELLINT32U32-bit unsigned integer. See Int32U for more information.
wDisplay
Display type. This member can be one of these values:
SO_CELLBOOLBoolean (0 = FALSE and 1 = TRUE).
SO_CELLDATEJulian days since the base date. wStorage may be either an IEEE or integer value.
SO_CELLDATETIMEJulian days since the base date. wStorage may be either an IEEE or integer value.
SO_CELLDECIMALDecimal notation.
SO_CELLDOLLARSDollar sign.
SO_CELLEXPONENTExponential notation.
SO_CELLNUMBERGeneral number format.
SO_CELLPERCENTPercent (not constrained to 0–100).
SO_CELLTIMEDecimal 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_MINUSNegative numbers have a minus sign.
SO_CELLNEG_MINUSREDNegative numbers have a minus sign and are red.
SO_CELLNEG_PARENNegative numbers have parentheses.
SO_CELLNEG_PARENREDNegative numbers have parentheses and are red.
Thousands Separator
SO_CELL1000SEP_COMMAComma as thousands separator.
SO_CELL1000SEP_NONENo thousands separator.
Cell Multiplier
SO_CELLMULT_1Used for all file parsers.
SO_CELLMULT_01Used only for Microsoft® Excel viewer.
SO_CELLMULT_05Used only for Lotus viewer.
SO_CELLMULT_005Used only for Lotus viewer.
SO_CELLMULT_0005Used only for Lotus viewer.
SO_CELLMULT_00005Used only for Lotus viewer.
SO_CELLMULT_500Used only for Lotus viewer.
SO_CELLMULT_5000Used only for Lotus viewer.
SO_CELLMULT_0625Used only for Lotus viewer.
SO_CELLMULT_015625Used 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_HHMMHMSFor example, 14h45m
SO_CELLTIME_HHMMSS24
SO_CELLTIME_HHMMSSAM
SO_CELLTIME_HHMMSSHMSFor 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 contain one value for each of these: 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
4-byte array representing an IEEE 4-byte floating-point number.
IEEE8
8-byte array representing an IEEE 8-byte floating-point number.
IEEE10
10-byte array representing an IEEE 10-byte floating-point number.
BCD8
8-byte array representing an excess-63 floating-point packed BCD.

Up Top of Page
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.