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;
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. |
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. |
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 |
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 |
Questions:
file: /Techref/os/win/api/win32/struc/src/str20_8.htm, 18KB, , updated: 2004/12/1 11:57, local time: 2024/11/3 09:09,
3.233.242.216:LOG IN ©2024 PLEASE DON'T RIP! THIS SITE CLOSES OCT 28, 2024 SO LONG AND THANKS FOR ALL THE FISH!
|
©2024 These pages are served without commercial sponsorship. (No popup ads, etc...).Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE. Questions? <A HREF="http://www.piclist.com/techref/os/win/api/win32/struc/src/str20_8.htm"> SODATACELL</A> |
Did you find what you needed? |
PICList 2024 contributors:
o List host: MIT, Site host massmind.org, Top posters @none found - Page Editors: James Newton, David Cary, and YOU! * Roman Black of Black Robotics donates from sales of Linistep stepper controller kits. * Ashley Roll of Digital Nemesis donates from sales of RCL-1 RS232 to TTL converters. * Monthly Subscribers: Gregg Rew. on-going support is MOST appreciated! * Contributors: Richard Seriani, Sr. |
Welcome to www.piclist.com! |
.