1 2# dumper settings ============================================================ 3 4# Path to additional configuration data, relative to this file. 5include-config-file=dumperbase.ini 6include-config-file=dffdumper.ini 7include-config-file=oledumper.ini 8 9# Enable entire dumper. This option does not affect the option 'enable-import'. 10# 0=off, 1=on, missing = use setting from dumperbase.ini 11# enable-dumper=1 12 13# Enable import after dumping. Disabling this option allows to dump a file 14# without loading it. This option is independent from the 'enable-dumper' 15# option. 16# 0=off, 1=on, missing = use setting from dumperbase.ini 17# enable-import=1 18 19# BIFF record settings ------------------------------------------------------- 20 21# Merge CONTINUE records with leading record (default=on). 22# 0=off - show CONTINUE records separately (hex dump) 23# 1=on - show contents of leading record together with following CONTINUE 24merge-continue-record=1 25 26# name lists ================================================================= 27 28# common --------------------------------------------------------------------- 29 30unitconverter=CONV-PERCENT-NEG,-1,% 31unitconverter=CONV-COLWIDTH,/256,chars 32unitconverter=CONV-TINT,/327.67,% 33 34shortlist=BIFF,0,biff2,biff3,biff4,biff5,biff8 35 36constlist=ERRORCODES 37 0x00=#NULL! 38 0x07=#DIV/0! 39 0x0F=#VALUE! 40 0x17=#REF! 41 0x1D=#NAME? 42 0x24=#NUM! 43 0x2A=#N/A 44end 45 46shortlist=WINDOWS-PALETTE-0,0,black,white,red,green,blue,yellow,magenta,cyan 47shortlist=WINDOWS-PALETTE-8,8,black,white,red,green,blue,yellow,magenta,cyan 48shortlist=WINDOWS-PALETTE-16,16,dark-red,dark-green,dark-blue,dark-yellow,dark-magenta,dark-cyan,light-grey,dark-grey 49 50multilist=WINDOWS-SYSCOLORS-BIFF2 51 24=sys-window-text,sys-window-bg 52 0x7FFF=sys-window-text 53end 54 55multilist=WINDOWS-SYSCOLORS-BIFF5 56 64=sys-window-text,sys-window-bg,,sys-button-face 57 77=sys-window-text-chart,sys-window-bg-chart,auto-border-chart,sys-tooltip-bg,sys-tooltip-text 58 0x7FFF=sys-window-text 59end 60 61constlist=COLORS-BIFF2 62 include=WINDOWS-PALETTE-0 63 include=WINDOWS-SYSCOLORS-BIFF2 64end 65 66constlist=COLORS-BIFF3 67 include=WINDOWS-PALETTE-0 68 include=WINDOWS-PALETTE-8 69 include=WINDOWS-PALETTE-16 70 include=WINDOWS-SYSCOLORS-BIFF2 71end 72 73multilist=COLORS-BIFF5 74 include=WINDOWS-PALETTE-0 75 include=WINDOWS-PALETTE-8 76 include=WINDOWS-PALETTE-16 77 24=0x8080FF,0x802060,0xFFFFC0,0xA0E0E0,0x600080,0xFF8080,0x0080C0,0xC0C0FF 78 32=0x000080,0xFF00FF,0xFFFF00,0x00FFFF,0x800080,0x800000,0x008080,0x0000FF 79 40=0x00CFFF,0x69FFFF,0xE0FFE0,0xFFFF80,0xA6CAF0,0xDD9CB3,0xB38FEE,0xE3E3E3 80 48=0x2A6FF9,0x3FB8CD,0x488436,0x958C41,0x8E5E42,0xA0627A,0x624FAC,0x969696 81 56=0x1D2FBE,0x286676,0x004500,0x453E01,0x6A2813,0x85396A,0x4A3285,0x424242 82 include=WINDOWS-SYSCOLORS-BIFF5 83end 84 85multilist=COLORS-BIFF8 86 include=WINDOWS-PALETTE-0 87 include=WINDOWS-PALETTE-8 88 include=WINDOWS-PALETTE-16 89 24=0x9999FF,0x993366,0xFFFFCC,0xCCFFFF,0x660066,0xFF8080,0x0066CC,0xCCCCFF 90 32=0x000080,0xFF00FF,0xFFFF00,0x00FFFF,0x800080,0x800000,0x008080,0x0000FF 91 40=0x00CCFF,0xCCFFFF,0xCCFFCC,0xFFFF99,0x99CCFF,0xFF99CC,0xCC99FF,0xFFCC99 92 48=0x3366FF,0x33CCCC,0x99CC00,0xFFCC00,0xFF9900,0xFF6600,0x666699,0x969696 93 56=0x003366,0x339966,0x003300,0x333300,0x993300,0x993366,0x333399,0x333333 94 include=WINDOWS-SYSCOLORS-BIFF5 95end 96 97shortlist=BORDERSTYLES-BIFF3,0,none,thin,medium,dash,dot,thick,double,hair 98 99multilist=BORDERSTYLES-BIFF8 100 include=BORDERSTYLES-BIFF3 101 8=medium-dash,thin-dash-dot,medium-dash-dot,thin-dash-dot-dot,medium-dash-dot-dot,slant-dash-dot 102end 103 104multilist=FILLPATTERNS-BIFF3 105 0=no-fill,solid-fill,50%-grey,75%-grey,25%-grey 106 5=hor-stripe,ver-stripe,rev-diag-stripe,diag-stripe,diag-crosshatch 107 10=thick-diag-crosshatch,thin-hor-stripe,thin-ver-stripe,thin-rev-diag-stripe,thin-diag-stripe 108 15=thin-hor-crosshatch,thin-diag-crosshatch,12.5%-grey,6.25%-grey 109end 110 111shortlist=TEXTORIENTATION,0,horizontal,stacked,90°-ccw,90°-cw 112 113constlist=TEXTROTATION-BIFF8 114 default= 115 255=stacked 116end 117 118multilist=BUILTIN-FORMATS 119 quote-names=1 120 0=General,0,0.00,'#,##0','#,##0.00' 121 5='"$"#,##0_);\("$"#,##0\)','"$"#,##0_);[Red]\("$"#,##0\)','"$"#,##0.00_);\("$"#,##0.00\)','"$"#,##0.00_);[Red]\("$"#,##0.00\)',0% 122 10=0.00%,0.00E+00,# ?/?,# ??/??,M/D/YYYY 123 15=D-MMM-YY,D-MMM,MMM-YY,h:mm AM/PM,h:mm:ss AM/PM 124 20=h:mm,h:mm:ss,M/D/YYYY h:mm,General,General 125 25=General,General,M/D/YYYY,M/D/YYYY,M/D/YYYY 126 30=M/D/YYYY,M/D/YYYY,h:mm:ss,h:mm:ss,h:mm:ss 127 35=h:mm:ss,M/D/YYYY,'#,##0_);(#,##0)','#,##0_);[Red](#,##0)','#,##0.00_);(#,##0.00)' 128 40='#,##0.00_);[Red](#,##0.00)' 129 41='_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)' 130 42='_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_)' 131 43='_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)' 132 44='_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)' 133 45=mm:ss,[h]:mm:ss,mm:ss.0,##0.0E+0,@ 134 50=M/D/YYYY,M/D/YYYY,M/D/YYYY,M/D/YYYY,M/D/YYYY 135 55=M/D/YYYY,M/D/YYYY,M/D/YYYY,M/D/YYYY,0 136 60=0.00,'#,##0','#,##0.00','$#,##0_);($#,##0)','$#,##0_);[Red]($#,##0)' 137 65='$#,##0.00_);($#,##0.00)','$#,##0.00_);[Red]($#,##0.00)',0%,0.00%,# ?/? 138 70=# ??/??,M/D/YYYY,M/D/YYYY,D-MMM-YY,D-MMM 139 75=MMM-YY,h:mm,h:mm:ss,M/D/YYYY h:mm,mm:ss 140 80=[h]:mm:ss,mm:ss.0 141end 142 143constlist=CONSTVALUE-TYPE 144 0=empty 145 1=number 146 2=string 147 4=boolean 148 16=error 149end 150 151constlist=PIVOT-NAMELEN 152 default= 153 0xFFFF=name-in-cache 154end 155 156flagslist=FR-FLAGS 157 0x0001=has-ref 158 0x0002=alert-unsupported 159end 160 161shortlist=EXTCOLOR-TYPE,0,auto,indexed,rgb,theme,n/a 162 163combilist=EXTCOLOR-FLAGS 164 0x01=rgb-valid 165 0xFE=uint8,dec,type,EXTCOLOR-TYPE 166end 167 168shortlist=EXTGRADIENT-TYPE,0,linear,path 169 170shortlist=EXTFONT-SCHEME,-1,n/a,none,major,minor 171 172# DFF ------------------------------------------------------------------------ 173 174flagslist=DFF-CLIENTANCHOR-FLAGS 175 0x0001=pos-locked 176 0x0002=size-locked 177end 178 179# formulas ------------------------------------------------------------------- 180 181multilist=BASETOKENS-BIFF2 182 0x00=,tExp,tTbl,tAdd,tSub,tMul,tDiv,tPower 183 0x08=tConcat,tLT,tLE,tEQ,tGE,tGT,tNE,tIsect 184 0x10=tList,tRange,tUplus,tUminus,tPercent,tParen,tMissArg,tStr 185 0x18=,tAttr,tSheet,tEndSheet,tErr,tBool,tInt,tNum 186end 187 188constlist=BASETOKENS-BIFF5 189 include=BASETOKENS-BIFF2 190 exclude=0x1A,0x1B 191end 192 193constlist=BASETOKENS-BIFF8 194 include=BASETOKENS-BIFF5 195 0x18=tNlr 196end 197 198constlist=TOKENCLASSES 199 0x20=R 200 0x40=V 201 0x60=A 202end 203 204multilist=CLASSTOKENS-BIFF2 205 0x00=tArray,tFunc,tFuncVar,tName,tRef,tArea,tMemArea,tMemErr 206 0x08=tMemNoMem,tMemFunc,tRefErr,tAreaErr,tRefN,tAreaN,tMemAreaN,tMemNoMemN 207 0x18=tFuncCE 208end 209 210constlist=CLASSTOKENS-BIFF4 211 include=CLASSTOKENS-BIFF2 212 exclude=0x18 213end 214 215multilist=CLASSTOKENS-BIFF5 216 include=CLASSTOKENS-BIFF4 217 0x19=tNameX,tRef3d,tArea3d,tRefErr3d,tAreaErr3d 218end 219 220combilist=FUNCID 221 0x7FFF=uint16,dec,func-id 222 0x8000=command 223end 224 225combilist=PARAMCOUNT-CMD 226 0x7F=uint8,dec,count 227 0x80=prompt 228end 229 230combilist=REFRELFLAGS 231 0x3FFF=uint16,dec,value 232 0x4000=col-rel 233 0x8000=row-rel 234end 235 236multilist=NLRTYPES 237 0x00=,tNlrErr,tNlrRowR,tNlrColR,,,tNlrRowV,tNlrColV 238 0x08=,,tNlrRange,tNlrSRange,tNlrSRowR,tNlrSColR,tNlrSRowV,tNlrSColV 239 0x10=tNlrRangeErr,,,,,,, 240 0x18=,,,,,tNlrSxName,, 241end 242 243combilist=NLRADDFLAGS 244 0x3FFFFFFF=uint32,dec,count 245 0x80000000=rel 246end 247 248flagslist=ATTRTYPES 249 0x00=skip 250 0x01=volatile 251 0x02=if 252 0x04=choose 253 0x08=skip 254 0x10=sum 255 0x20=assign 256 0x40=space 257end 258 259shortlist=ATTRSPACETYPES,0,space-before-token,cr-before-token,space-before-open,cr-before-open,space-before-close,cr-before-close,leading-space 260 261# record names --------------------------------------------------------------- 262 263multilist=RECORD-NAMES-BIFF2 264 # worksheet records 265 0x0000=DIMENSION,BLANK,INTEGER,NUMBER,LABEL,BOOLERR,FORMULA,STRING 266 0x0008=ROW,BOF,EOF,INDEX,CALCCOUNT,CALCMODE,PRECISION,REFMODE 267 0x0010=DELTA,ITERATION,PROTECT,PASSWORD,HEADER,FOOTER,EXTERNCOUNT,EXTERNSHEET 268 0x0018=DEFINEDNAME,WINDOWPROTECT,VERTICALPAGEBREAKS,HORIZONTALPAGEBREAKS,NOTE,SELECTION,FORMAT,BUILTINFMTCOUNT 269 0x0020=COLUMNDEFAULT,ARRAY,DATEMODE,EXTERNALNAME,COLWIDTH,DEFAULTROWHEIGHT,LEFTMARGIN,RIGHTMARGIN 270 0x0028=TOPMARGIN,BOTTOMMARGIN,PRINTHEADERS,PRINTGRIDLINES,,,,FILEPASS 271 0x0030=,FONT,FONT2,PRINTSIZE,,INFOOPTS,DATATABLE,DATATABLE2 272 0x0038=WNDESK,,BEGINPREF,ENDPREF,CONTINUE,WINDOW1,WINDOW2, 273 0x0040=BACKUP,PANE,CODEPAGE,XF,IXFE,EFONT,SHOWSCROLL,SHOWFORMULA 274 0x0048=STATUSBAR,SHORTMENUS,DDEENABLED,AUTODEC,MENUKEY,PLS|ZOOM,MENUUND,MOVESEL 275 0x0050=DCON,DCONREF,DCONNAME,,,DEFCOLWIDTH,, 276 # worksheet records new in BIFF3, but supported in BIFF2 streams 277 0x0200=DIMENSION,BLANK,,NUMBER,LABEL,BOOLERR,, 278 0x0208=,,,INDEX,,,, 279 0x027E=RK 280 # BIFF5 style BOF 281 0x0809=BOF 282 # chart records 283 0x1000=,CHUNITS,CHCHART,CHSERIES,CHSOURCELINK,,CHDATAFORMAT,CHLINEFORMAT 284 0x1008=,CHMARKERFORMAT,CHAREAFORMAT,CHPIEFORMAT,CHATTACHEDLABEL,CHSTRING,, 285 0x1010=,,,,CHTYPEGROUP,CHLEGEND,CHSERIESLIST,CHBAR 286 0x1018=CHLINE,CHPIE,CHAREA,CHSCATTER,CHCHARTLINE,CHAXIS,CHTICK,CHVALUERANGE 287 0x1020=CHLABELRANGE,CHAXISLINE,CHFORMATLINK,,CHDEFAULTTEXT,CHTEXT,CHFONT,CHOBJECTLINK 288 0x1028=,,,,,CHARROW,,CHARROWHEAD 289 0x1030=,,CHFRAME,CHBEGIN,CHEND,CHPLOTFRAME,CHCHARTSIZE,CHRELPOSITION 290 0x1038=CHARROWRELPOS,,CHCHART3D,,,,, 291end 292 293multilist=RECORD-NAMES-BIFF3 294 include=RECORD-NAMES-BIFF2 295 # worksheet records 296 exclude=0x0006,0x0008,0x0009,0x000B,0x0018,0x0020,0x0023,0x0024,0x0025,0x0031,0x0036,0x0037,0x003E,0x0043,0x0044,0x0045 297 0x0050=,,,,,,BUILTINFMTCOUNT, 298 0x0058=TOOLBAR,XCT,CRN,FILESHARING,WRITEACCESS,OBJ,UNCALCED,SAFERECALC 299 0x0060=TEMPLATE,INTL,,OBJECTPROTECT,,,, 300 0x0068=,,,,,,, 301 0x0070=,,,,,,, 302 0x0078=,,,,,COLINFO,,IMGDATA 303 0x0080=GUTS,SHEETPR,GRIDSET,HCENTER,VCENTER,,WRITEPROT,ADDIN 304 0x0088=EDG,PUB,NOTEOFF,LH,COUNTRY,HIDEOBJ,, 305 0x0090=SORT,SUB,PALETTE,,LHRECORD,LHNGRAPH,, 306 0x0200=,,,,,,FORMULA,STRING 307 0x0208=ROW,BOF,,,,,, 308 0x0218=DEFINEDNAME 309 0x0221=ARRAY 310 0x0223=EXTERNALNAME 311 0x0225=DEFAULTROWHEIGHT 312 0x0231=FONT 313 0x0236=DATATABLE 314 0x023E=WINDOW2 315 0x0243=XF 316 0x0293=STYLE 317 # chart records 318 0x103C=CHPICFORMAT 319end 320 321multilist=RECORD-NAMES-BIFF4 322 include=RECORD-NAMES-BIFF3 323 # worksheet/workbook records 324 exclude=0x0206,0x0209,0x001E,0x0243 325 0x0085=SHEET 326 0x0088=,,,,,,SHEETSOFFSET,SHEETHEADER 327 0x0090=,,,,,,NOTESOUND,SYNC 328 0x0098=LPR,STANDARDWIDTH,FNGROUPNAME,,FNGROUPCOUNT,,, 329 0x00A0=SCL,PAGESETUP,FNPROTO,PROJEXTSHEET,,,, 330 0x00A8=DRAGDROP,COORDLIST,,GCW,,,, 331 0x0406=FORMULA 332 0x0409=BOF 333 0x041E=FORMAT 334 0x0443=XF 335 # chart records 336 0x1038=,,,CHMULTILINK,,CHDROPBAR,CHRADARLINE,CHSURFACE 337end 338 339multilist=RECORD-NAMES-BIFF5 340 include=RECORD-NAMES-BIFF4 341 # worksheet/workbook records 342 exclude=0x0409,0x0218,0x0223,0x0231,0x0443 343 0x0006=FORMULA 344 0x0018=DEFINEDNAME 345 0x0023=EXTERNALNAME 346 0x0031=FONT 347 0x0098=,,,FILTERMODE,,AUTOFILTER,FILTERCOLUMN, 348 0x00A8=,,,,,,SCENARIOS,SCENARIO 349 0x00B0=PTDEFINITION,PTFIELD,PTFITEM,,PTROWCOLFIELDS,PTROWCOLITEMS,PTPAGEFIELDS, 350 0x00B8=DOCROUTE,RECIPNAME,,,,MULTRK,MULTBLANK,TOOLBARHDR 351 0x00C0=TOOLBAREND,MMS,ADDMENU,DELMENU,,PTDATAFIELD,PCDEFINITION,PCDFIELD 352 0x00C8=PCITEM_INDEXLIST,PCITEM_DOUBLE,PCITEM_BOOL,PCITEM_ERROR,PCITEM_INTEGER,PCITEM_STRING,PCITEM_DATE,PCITEM_MISSING 353 0x00D0=SXTBL,SXTBRGITEM,SXTBPG,VBAPROJECT,,PIVOTCACHE,RSTRING,DBCELL 354 0x00D8=PCDFRANGEPR,PCDFDISCRETEPR,BOOKBOOL,REVERT,DBORPARAMQUERY,SCENPROTECT,OLESIZE,UDDESC 355 0x00E0=XF,INTERFACEHDR,INTERFACEEND,PCDSOURCE,,,, 356 0x0206=FORMULA 357 0x04BC=SHAREDFMLA 358 # chart records 359 exclude=0x1004,0x102D,0x102F,0x1036,0x1037,0x1038,0x103B 360 0x1040=CHRADARAREA,CHAXESSET,,CHLEGENDENTRY,CHPROPERTIES,CHSERGROUP,CHUSEDAXESSETS, 361 0x1048=CHPIVOTRANGE,,CHSERPARENT,CHSERTRENDLINE,,,CHFORMAT,CHFRAMEPOS 362 0x1050=CHFORMATRUNS,CHSOURCELINK,,,,,, 363 0x1058=,,,CHSERERRORBAR,,CHSERIESFORMAT,, 364end 365 366multilist=RECORD-NAMES-BIFF8 367 include=RECORD-NAMES-BIFF5 368 # worksheet/workbook records 369 0x00E0=,,,,,CELLMERGING,, 370 0x00E8=,IMGDATA,,MSODRAWINGGROUP,MSODRAWING,MSODRAWINGSELECTION,,PHONETICPR 371 0x00F0=,PTDEFINITION2,,,,,, 372 0x00F8=,PCDFORMULAFIELD,,,SST,LABELSST,,EXTSST 373 0x0100=PTFIELD2,,,PCDFIELDINDEX,,,, 374 0x0120=,,PCDEFINITION2,,,,, 375 0x0130=,,,,,,,CHTRINSERT 376 0x0138=CHTRINFO,,,CHTRCELLCONTENT,,TABID,, 377 0x0140=CHTRMOVERANGE,,,,,,, 378 0x0148=,,,,,CHTRINSERTTAB,, 379 0x0158=,,,,,,,LABELRANGES 380 0x0160=USESELFS,DSF,XL5MODIFY,,,,, 381 0x0190=,,,,,,CHTRHEADER, 382 0x01A8=,USERBVIEW,USERSVIEWBEGIN,USERSVIEWEND,,QUERYTABLE,EXTERNALBOOK,PROT4REV 383 0x01B0=CFHEADER,CFRULE,DATAVALIDATIONS,,,DCONBINAME,TXO,REFRESHALL 384 0x01B8=HYPERLINK,NLRDELNAME,CODENAME,PCDFSQLTYPE,PROT4REVPASS,VBAPROJECTEMPTY,DATAVALIDATION, 385 0x01C0=XL9FILE,RECALCID,INTCACHEDDATA,,,,, 386 # future records 387 0x0800=SCREENTIP,,QUERYTABLEREFRESH,QUERYTABLESETTINGS,QUERYTABLESTRING,,, 388 0x0850=CHFRINFO,CHFRWRAPPER,CHFRBLOCKBEGIN,CHFRBLOCKEND,,,CHFRCATEGORYPROPS,CHFRUNITPROPS 389 0x0858=CHPIVOTREF,CHPIVOTFLAGS,,,,,, 390 0x0860=,,SHEETEXT,BOOKEXT,,,,SHAREDFEATHEAD 391 0x0868=,,,CHFRLABELPROPS,,,, 392 0x0870=,,,,,,CONNECTION, 393 0x0878=,,CFRULE12,CFRULEEXT,XFCRC,XFEXT,FILTERCOLUMN12,CONTINUE12 394 0x0888=,,,PAGELAYOUTVIEW,CHECKCOMPAT,DXF,TABLESTYLES, 395 0x0890=,,STYLEEXT,,,,THEME, 396 0x0898=,,MTHREADSETTINGS,COMPRESSPICS,HEADERFOOTER,CHFRLAYOUT,CHFREXTPROPS,CHFREXTPROPSCONT 397 0x08A0=,,,FORCEFULLCALC,CHFRSHAPEPROPS,CHFRTEXTPROPS,,CHFRPLOTAREALAYOUT 398 # chart records 399 0x1058=,,,,,,,CH3DDATAFORMAT 400 0x1060=CHFONTBASE,CHPIEEXT,CHDATERANGE,CHDATATABLE,CHPLOTGROWTH,CHSERINDEX,CHESCHERFORMAT,CHPIEEXTSETT 401end 402 403# simple records ------------------------------------------------------------- 404 405constlist=SIMPLE-RECORDS-BIFF2 406 0x000C=uint16,dec,max-iterations 407 0x000D=int16,dec,calc-mode,CALCMODE 408 0x000E=uint16,bool,calc-precise 409 0x000F=uint16,dec,ref-mode,REFMODE 410 0x0010=double,dec,epsilon 411 0x0011=uint16,bool,iterate-recursive 412 0x0012=uint16,bool,contents-protected 413 0x0013=uint16,hex,password-hash 414 0x0016=uint16,dec,externsheets 415 0x0019=uint16,bool,window-protected 416 0x001F=uint16,dec,builtin-fmt-count 417 0x0022=uint16,dec,null-date,DATEMODE 418 0x0025=uint16,hex,rowheight-flags,DEFROWHEIGHT-FLAGS 419 0x0026=double,dec,left-margin,CONV-INCH-TO-CM 420 0x0027=double,dec,right-margin,CONV-INCH-TO-CM 421 0x0028=double,dec,top-margin,CONV-INCH-TO-CM 422 0x0029=double,dec,bottom-margin,CONV-INCH-TO-CM 423 0x002A=uint16,bool,print-sheet-headers 424 0x002B=uint16,bool,print-gridlines 425 0x0040=uint16,bool,backup-on-save 426 0x0044=uint16,dec,xf-idx 427 0x0045=uint16,dec,font-color-idx,COLORS 428 0x0055=uint16,dec,base-col-width 429 0x100B=uint16,dec,extrusion,CONV-PERCENT 430 0x100C=uint16,hex,flags,CHATTACHEDLABEL-FLAGS 431 0x1018=uint16,hex,flags,CHLINE-FLAGS 432 0x101A=uint16,hex,flags,CHAREA-FLAGS 433 0x101C=uint16,dec,line-type,CHCHARTLINE-TYPE 434 0x1021=uint16,dec,axisline-id,CHAXISLINE-ID 435 0x1024=uint16,dec,text-idx 436 0x1026=uint16,dec,font-idx,FONTNAMES 437 0x1045=uint16,dec,group-idx 438 0x1046=uint16,dec,used-axessets 439 0x104A=uint16,dec,series-idx 440 0x104E=uint16,dec,fmt-idx,FORMATS 441end 442 443constlist=SIMPLE-RECORDS-BIFF3 444 include=SIMPLE-RECORDS-BIFF2 445 0x0056=uint16,dec,builtin-fmt-count 446 0x005E=uint16,unused 447 0x005F=uint16,bool,recalc-on-save 448 0x0063=uint16,bool,objects-protected 449 0x0081=uint16,hex,flags,SHEETPR-FLAGS 450 0x0082=uint16,bool,print-gridlines-changed 451 0x0083=uint16,bool,horizontal-centered 452 0x0084=uint16,bool,vertical-centered 453 0x008D=uint16,dec,object-mode,HIDEOBJ 454end 455 456constlist=SIMPLE-RECORDS-BIFF4 457 include=SIMPLE-RECORDS-BIFF3 458 0x008E=uint32,hex,stream-pos,CONV-DEC 459 0x0099=uint16,dec,default-col-width,CONV-COLWIDTH 460 0x009C=uint16,dec,func-group-count 461 0x103D=uint16,dec,bar-dist 462 0x103E=uint16,hex,flags,CHRADAR-FLAGS 463 0x103F=uint16,hex,flags,CHSURFACE-FLAGS 464end 465 466constlist=SIMPLE-RECORDS-BIFF5 467 include=SIMPLE-RECORDS-BIFF4 468 0x009D=uint16,dec,column-count 469 0x00C9=double,dec,value 470 0x00CA=uint16,bool,value 471 0x00CB=uint16,hex,error-code,ERRORCODES 472 0x00CC=int16,dec,value 473 0x00D5=uint16,hex,cache-id 474 0x00D8=uint16,hex,flags,PCDFRANGEPR-FLAGS 475 0x00DA=uint16,bool,strip-cached-values 476 0x00DD=uint16,bool,scenarios-protected 477 0x00E3=uint16,dec,source-type,PCDSOURCE-TYPE 478 0x1040=uint16,hex,flags,CHRADAR-FLAGS 479 0x105D=uint16,hex,flags,CHSERIESFORMAT-FLAGS 480end 481 482constlist=SIMPLE-RECORDS-BIFF8 483 include=SIMPLE-RECORDS-BIFF5 484 0x00E1=uint16,dec,codepage,CODEPAGES 485 0x0160=uint16,bool,use-nat-lang-refs 486 0x0161=uint16,bool,double-stream 487 0x01AF=uint16,bool,revlog-protected 488 0x01B7=uint16,bool,refresh-all 489 0x01BB=uint16,dec,sql-data-type,PCDFSQLTYPE-DATATYPE 490 0x01BC=uint16,hex,password-hash 491 0x1065=uint16,dec,series-idx 492end 493 494# ARRAY ---------------------------------------------------------------------- 495 496flagslist=ARRAY-FLAGS-BIFF2 497 0x0001=recalc-always 498end 499 500flagslist=ARRAY-FLAGS-BIFF3 501 include=ARRAY-FLAGS-BIFF2 502 0x0002=recalc-onload 503end 504 505# BOF ------------------------------------------------------------------------ 506 507constlist=BOF-BIFFTYPE 508 0x0000=from-id 509 0x0007=biff2 510 0x0200=biff2 511 0x0300=biff3 512 0x0400=biff4 513 0x0500=biff5 514 0x0600=biff8 515end 516 517constlist=BOF-SHEETTYPE 518 0x0005=globals 519 0x0006=vb-module 520 0x0010=sheet 521 0x0020=chart 522 0x0040=macro 523 0x0100=workspace 524end 525 526shortlist=BOF-EXCELVERSION,0,excel-97,excel-2000,excel-2002,excel-2003,excel-2007,,excel-2010 527shortlist=BOF-LOWESTVERSION-BIFF,6,biff8 528 529combilist=BOF-HISTORY-FLAGS 530 ignore=0x000000C0 531 0x00000001=windows 532 0x00000002=risc 533 0x00000004=beta 534 0x00000008=win-any 535 0x00000010=mac-any 536 0x00000020=beta-any 537 0x00000100=risc-any 538 0x00000200=out-of-mem 539 0x00000400=out-of-mem-renderer 540 0x00002000=font-limit-255 541 0x0003C000=uint8,dec,max-version-saved,BOF-EXCELVERSION 542end 543 544combilist=BOF-LOWESTVERSION-FLAGS 545 0x000000FF=uint8,dec,biff-version,BOF-LOWESTVERSION-BIFF 546 0x00000F00=uint8,dec,version-saved,BOF-EXCELVERSION 547end 548 549# BOOKEXT -------------------------------------------------------------------- 550 551combilist=BOOKEXT-FLAGS1 552 0x00000001=no-auto-recover 553 0x00000002=hide-pivot-list 554 0x00000004=filter-privacy 555 0x00000008=embed-smarttags 556 0x00000030=uint8,dec,display-smarttags,BOOKEXT-DISPLAY-SMARTTAGS 557 0x00000040=saved-on-recovery 558 0x00000080=minimal-save 559 0x00000100=opened-on-recovery 560 0x00000200=opened-in-save-mode 561end 562 563shortlist=BOOKEXT-DISPLAY-SMARTTAGS,0,button-and-indicator,button,nothing 564 565flagslist=BOOKEXT-FLAGS2 566 0x01=warn-smart-doc-manifest 567 0x02=show-inc-annotations 568end 569 570flagslist=BOOKEXT-FLAGS3 571 0x02=!all-published!selected-items-published 572 0x04=show-pivot-chart-filter 573end 574 575# CALCMODE ------------------------------------------------------------------- 576 577shortlist=CALCMODE,-1,automatic-no-table,manual,automatic 578 579# CFHEADER ------------------------------------------------------------------- 580 581combilist=CFHEADER-FLAGS 582 0x0001=complex 583 0xFFFE=uint16,dec,id 584end 585 586# CFRULE --------------------------------------------------------------------- 587 588shortlist=CFRULE-TYPE,1,value,formula 589shortlist=CFRULE-OPERATOR,0,none,between,not-between,equal,not-equal,greater-than,less-than,greater-equal,less-equal 590 591flagslist=CFRULE-FLAGS1 592 ignore=0x00200000 593 0x00000001=!hor-align-used 594 0x00000002=!vert-align-used 595 0x00000004=!text-wrap-used 596 0x00000008=!rotation-used 597 0x00000010=!justify-lastline-used 598 0x00000020=!indent-used 599 0x00000040=!shrinktofit-used 600 0x00000080=!cell-merged-used 601 0x00000100=!cell-locked-used 602 0x00000200=!cell-hidden-used 603 0x00000400=!left-border-used 604 0x00000800=!right-border-used 605 0x00001000=!top-border-used 606 0x00002000=!bottom-border-used 607 0x00004000=!tl-to-br-used 608 0x00008000=!bl-to-tr-used 609 0x00010000=!fill-pattern-used 610 0x00020000=!fg-color-idx-used 611 0x00040000=!bg-color-idx-used 612 0x00080000=!fmt-idx-used 613 0x00100000=!def-font-used 614 0x02000000=numfmt-block 615 0x04000000=font-block 616 0x08000000=alignment-block 617 0x10000000=border-block 618 0x20000000=pattern-block 619 0x40000000=protection-block 620 0x80000000=!text-dir-used 621end 622 623flagslist=CFRULE-FLAGS2 624 ignore=0x0002 625 0x0001=!numfmt-id!numfmt-string 626 0x0004=outline-border 627 0x8000=use-text-dir 628end 629 630combilist=CFRULE-ALIGNMENT 631 0x07=uint8,dec,hor-align,XF-HORALIGN 632 0x08=text-wrap 633 0x70=uint8,dec,ver-align,XF-VERALIGN 634 0x80=justify-lastline 635end 636 637combilist=CFRULE-INDENT 638 0x000F=uint8,dec,indent 639 0x0010=shrink-to-fit 640 0x0020=cell-merged 641 0x00C0=uint8,dec,text-dir,XF-TEXTDIRECTION 642end 643 644flagslist=CFRULE-FONTFLAGS 645 0x00000002=italic 646 0x00000008=outline 647 0x00000010=shadow 648 0x00000020=condense 649 0x00000040=extend 650 0x00000080=strikeout 651end 652 653constlist=CFRULE-FONTWEIGHT 654 include=FONT-WEIGHT 655 -1=unused 656end 657 658constlist=CFRULE-FONTESCAPEMENT 659 include=FONT-ESCAPEMENT 660 -1=unused 661end 662 663constlist=CFRULE-FONTUNDERLINE 664 include=FONT-UNDERLINE 665 -1=unused 666end 667 668constlist=CFRULE-FONTCOLOR 669 include=COLORS-BIFF8 670 -1=unused 671end 672 673flagslist=CFRULE-FONTUSEDFLAGS 674 ignore=0xFFFFFF00 675 0x00000002=!italic-used 676 0x00000008=!outline-used 677 0x00000010=!shadow-used 678 0x00000020=!condense-used 679 0x00000040=!extend-used 680 0x00000080=!strikeout-used 681end 682 683constlist=CFRULE-FONTUSED 684 0=used 685 1=not-used 686end 687 688combilist=CFRULE-BORDERCOLOR2 689 0x0000007F=uint8,dec,top-color,COLORS 690 0x00003F80=uint8,dec,bottom-color,COLORS 691 0x001FC000=uint8,dec,diag-color,COLORS 692 0x01E00000=uint8,dec,diag-style,BORDERSTYLES 693end 694 695combilist=CFRULE-FILLBLOCK 696 0x0000FC00=uint8,dec,fill-pattern,FILLPATTERNS 697 0x007F0000=uint8,dec,fg-color-idx,COLORS 698 0x3F800000=uint8,dec,bg-color-idx,COLORS 699end 700 701flagslist=CFRULE-PROTECTION-FLAGS 702 0x0001=locked 703 0x0002=formula-hidden 704end 705 706# CFRULE12 ------------------------------------------------------------------- 707 708shortlist=CFRULE12-TYPE,1,cell-is,expression,color-scale,data-bar,top-ten,icon-set 709 710flagslist=CFRULE12-FLAGS 711 0x0002=stop-if-true 712end 713 714multilist=CFRULE12-SUBTYPE 715 0=cell-is,expression,color-scale,data-bar,icon-set,top-ten,,unique-values,contains-text,contains-blanks 716 10=not-contains-blanks,contains-errors,not-contains-errors,,,today,tomorrow,yesterday,last-7-days,last-month 717 20=next-month,this-week,next-week,last-week,this-month,above-average,below-average,duplicate-values,,equal-above-average 718 30=equal-below-average 719end 720 721flagslist=CFRULE12-TOP10-FLAGS 722 0x01=!bottom!top 723 0x02=percent 724end 725 726shortlist=CFRULE12-TEXT-OPERATOR,0,contains,not-contains,begins-with,ends-with 727shortlist=CFRULE12-DATE-OPERATOR,0,today,yesterday,last-7-days,this-week,last-week,last-month,tomorrow,next-week,next-month,this-month 728 729# CFRULEEXT ------------------------------------------------------------------ 730 731flagslist=CFRULEEXT-FLAGS 732 0x0001=active 733 0x0002=stop-if-true 734end 735 736# CH3DDATAFORMAT ------------------------------------------------------------- 737 738shortlist=CH3DDATAFORMAT-BASE,0,rectangular,circular 739shortlist=CH3DDATAFORMAT-TOP,0,straight,sharp,trunc 740 741# CHAREA --------------------------------------------------------------------- 742 743flagslist=CHAREA-FLAGS 744 0x0001=stacked 745 0x0002=percent 746 0x0004=shadow 747end 748 749# CHAREAFORMAT --------------------------------------------------------------- 750 751flagslist=CHAREAFORMAT-FLAGS 752 0x0001=auto 753 0x0002=swap-negative 754end 755 756# CHATTACHEDLABEL ------------------------------------------------------------ 757 758flagslist=CHATTACHEDLABEL-FLAGS 759 0x0001=show-value 760 0x0002=show-percent 761 0x0004=show-categ-percent 762 0x0008=smoothed 763 0x0010=show-categ 764 0x0020=show-bubble 765end 766 767# CHAXESSET ------------------------------------------------------------------ 768 769shortlist=CHAXESSET-ID,0,primary,secondary 770 771# CHAXIS --------------------------------------------------------------------- 772 773shortlist=CHAXIS-TYPE,0,x-axis,y-axis,z-axis 774 775# CHAXISLINE ----------------------------------------------------------------- 776 777shortlist=CHAXISLINE-ID,0,axisline,major-grid,minor-grid,wall 778 779# CHBAR ---------------------------------------------------------------------- 780 781flagslist=CHBAR-FLAGS 782 0x0001=horizontal 783 0x0002=stacked 784 0x0004=percent 785 0x0008=shadow 786end 787 788# CHCHART3D ------------------------------------------------------------------ 789 790flagslist=CHCHART3D-FLAGS 791 ignore=0x0010 792 0x0001=real3d 793 0x0002=clustered 794 0x0004=auto-height 795 0x0020=2d-plotarea 796end 797 798# CHTYPEGROUP ---------------------------------------------------------------- 799 800flagslist=CHTYPEGROUP-FLAGS 801 0x0001=varied-colors 802end 803 804# CHCHARTLINE ---------------------------------------------------------------- 805 806shortlist=CHCHARTLINE-TYPE,0,drop-line,hi-lo-line,series-connector 807 808# CHDATAFORMAT --------------------------------------------------------------- 809 810constlist=CHDATAFORMAT-POINTIDX 811 default= 812 -1=all-points 813end 814 815constlist=CHDATAFORMAT-FORMATIDX 816 default= 817 -3=axesset-global 818end 819 820flagslist=CHDATAFORMAT-FLAGS 821 0x0001=excel4-colors 822end 823 824# CHDATERANGE ---------------------------------------------------------------- 825 826shortlist=CHDATERANGE-UNIT,0,days,months,years 827 828flagslist=CHDATERANGE-FLAGS 829 0x0001=auto-minimum 830 0x0002=auto-maximum 831 0x0004=auto-major 832 0x0008=auto-minor 833 0x0010=date-axis 834 0x0020=auto-base 835 0x0040=auto-axis-cross 836 0x0080=auto-date 837end 838 839# CHFRAME -------------------------------------------------------------------- 840 841shortlist=CHFRAME-FORMAT,0,standard,,,,shadow 842 843flagslist=CHFRAME-FLAGS 844 0x0001=auto-size 845 0x0002=auto-pos 846end 847 848# CHFRAMEPOS ----------------------------------------------------------------- 849 850shortlist=CHFRAMEPOS-POSMODE,0,rel-points,abssize-points,parent-dependent,offset-plotarea-size,,chartsize 851 852# CHFRBLOCKBEGIN, CHFRBLOCKEND ----------------------------------------------- 853 854shortlist=CHFRBLOCK-TYPE,0,axes-set,,text,,axis,type-group,data-table,frame,,legend,legend-exception,,series,chart,data-format,drop-bar 855 856# CHFRCATEGORYPROPS ---------------------------------------------------------- 857 858shortlist=CHFRCATEGORYPROPS-ALIGN,1,top-left,center,bottom-right 859 860flagslist=CHFRCATEGORYPROPS-FLAGS 861 ignore=0xFFFE 862 0x0001=auto-label-frequency 863end 864 865# CHFREXTPROPS --------------------------------------------------------------- 866 867constlist=CHFREXTPROPS-PARENT 868 0x0001=log-scaling 869 0x0002=style 870 0x0004=category-scaling 871 0x0005=chart-props 872 0x000F=legend 873 0x0013=marker 874 0x0016=plot-area 875 0x0019=chart-title 876 0x0037=3d-props 877end 878 879constlist=CHFREXTPROPS-TYPE 880 0=start 881 1=end 882 2=bool 883 3=double 884 4=int32 885 5=string 886 6=uint16 887 7=blob 888end 889 890constlist=CHFREXTPROPS-TAG 891 0x0000=log-base 892 0x0003=style 893 0x001E=chart-formatting 894 0x0020=text-formatting 895 0x0022=symbol-type 896 0x002E=no-multi-level 897 0x002F=overlay 898 0x0033=theme-override 899 0x0034=color-mapping-override 900 0x0035=backwall-thickness 901 0x0036=floor-thickness 902 0x004D=perspective 903 0x004E=rotation-x 904 0x004F=rotation-y 905 0x0050=right-angled-axes-off 906 0x0052=tick-mark-skip 907 0x0051=tick-label-skip 908 0x0053=major-unit 909 0x0054=minor-unit 910 0x0055=max 911 0x0056=min 912 0x0059=side-wall 913 0x005B=show-data-labels-over-max 914 0x005C=tick-label-pos 915 0x005E=pie-combination 916 0x005F=basetime-unit 917 0x0064=format-code 918 0x0065=height-percent 919 0x0066=display-blanks-as 920 0x006A=major-unit-type 921 0x006B=minor-unit-type 922 0x0076=edit-language 923end 924 925constlist=CHFREXTPROPS-TAG-NAMELIST 926 default= 927 0x0022=CHFREXTPROPS-SYMBOLTYPE 928 0x0035=CONV-PERCENT 929 0x0036=CONV-PERCENT 930 0x004E=CONV-DEG 931 0x004F=CONV-DEG 932 0x005C=CHFREXTPROPS-TICKLABELPOS 933 0x005F=CHFREXTPROPS-TIMEUNIT 934 0x0065=CONV-PERCENT 935 0x0066=CHFREXTPROPS-DISPBLANKSAS 936 0x006A=CHFREXTPROPS-TIMEUNIT 937 0x006B=CHFREXTPROPS-TIMEUNIT 938end 939 940shortlist=CHFREXTPROPS-DISPBLANKSAS,0x0067,gap,,spanned 941shortlist=CHFREXTPROPS-SYMBOLTYPE,0x0023,none,diamond,square,triangle,x,star,dot,dash,circle,plus 942shortlist=CHFREXTPROPS-TICKLABELPOS,0x005D,center 943shortlist=CHFREXTPROPS-TIMEUNIT,0x0060,days,months,years 944 945# CHFRINFO ------------------------------------------------------------------- 946 947shortlist=CHFRINFO-APPVERSION,9,excel-2000,excel-xp-2003,,excel-2007 948 949# CHFRLABELPROPS ------------------------------------------------------------- 950 951flagslist=CHFRLABELPROPS-FLAGS 952 0x0001=show-series 953 0x0002=show-categ 954 0x0004=show-value 955 0x0008=show-percent 956 0x0010=show-bubble 957end 958 959# CHFRLAYOUT ----------------------------------------------------------------- 960 961combilist=CHFRLAYOUT-FLAGS 962 0x001E=uint8,dec,legend-pos,CHFRLAYOUT-LEGENDPOS 963end 964 965shortlist=CHFRLAYOUT-LEGENDPOS,0,bottom,top-right,top,right,left 966 967shortlist=CHFRLAYOUT-MODE,0,auto,factor,egde 968 969# CHFRPLOTAREALAYOUT --------------------------------------------------------- 970 971flagslist=CHFRPLOTAREALAYOUT-FLAGS 972 0x0001=!outer!inner 973end 974 975shortlist=CHFRLAYOUT-LEGENDPOS,0,bottom,top-right,top,right,left 976 977shortlist=CHFRLAYOUT-MODE,0,auto,factor,egde 978 979# CHFRUNITPROPS -------------------------------------------------------------- 980 981shortlist=CHFRUNITPROPS-PRESET,-1,manual,none,hundred,thousand,10000,100000,million,10-million,100-million,billion,trillion 982 983flagslist=CHFRUNITPROPS-FLAGS 984 0x0002=show-unit 985end 986 987# CHLABELRANGE --------------------------------------------------------------- 988 989flagslist=CHLABELRANGE-FLAGS 990 0x0001=cross-between-categ 991 0x0002=maximum-axis-cross 992 0x0004=reverse-order 993end 994 995# CHLEGEND ------------------------------------------------------------------- 996 997shortlist=CHLEGEND-DOCKPOS,0,bottom,top-right,top,right,left,,,manual 998shortlist=CHLEGEND-SPACING,0,close,medium,open 999 1000flagslist=CHLEGEND-FLAGS 1001 0x0001=docked 1002 0x0002=auto-series 1003 0x0004=auto-pos-x 1004 0x0008=auto-pos-y 1005 0x0010=stacked 1006 0x0020=data-table 1007end 1008 1009# CHLINE --------------------------------------------------------------------- 1010 1011flagslist=CHLINE-FLAGS 1012 0x0001=stacked 1013 0x0002=percent 1014 0x0004=shadow 1015end 1016 1017# CHLINEFORMAT --------------------------------------------------------------- 1018 1019shortlist=CHLINEFORMAT-LINETYPE,0,solid,dash,dot,dash-dot,dash-dot-dot,none,25%-pattern,50%-pattern,75%-pattern 1020shortlist=CHLINEFORMAT-LINEWEIGHT,-1,hair,thin,medium,thick 1021 1022flagslist=CHLINEFORMAT-FLAGS 1023 0x0001=auto 1024 0x0004=axis-enabled 1025 0x0008=system-color 1026end 1027 1028# CHMARKERFORMAT ------------------------------------------------------------- 1029 1030shortlist=CHMARKERFORMAT-TYPE,0,none,square,diamond,triangle,cross,star,dow-jones,std-dev,circle,plus 1031 1032flagslist=CHMARKERFORMAT-FLAGS 1033 0x0001=auto 1034 0x0010=no-fill 1035 0x0020=no-border 1036end 1037 1038# CHOBJECTLINK --------------------------------------------------------------- 1039 1040shortlist=CHOBJECTLINK-TARGET,0,none,title,y-axis,x-axis,datapoint,legend,none,z-axis,,,,,axis-unit 1041 1042constlist=CHOBJECTLINK-POINT 1043 default= 1044 -2=unknown 1045 -1=all-points 1046end 1047 1048# CHPICFORMAT ---------------------------------------------------------------- 1049 1050shortlist=CHPICFORMAT-BITMAP-MODE,1,stretched,stacked,stacked-scaled 1051 1052combilist=CHPICFORMAT-FLAGS 1053 0x0200=top-bottom 1054 0x0400=front-back 1055 0x0800=left-right 1056end 1057 1058# CHPIE ---------------------------------------------------------------------- 1059 1060flagslist=CHPIE-FLAGS 1061 0x0001=shadow 1062 0x0002=connectors 1063end 1064 1065# CHPIVOTFLAGS --------------------------------------------------------------- 1066 1067flagslist=CHPIVOTFLAGS-FLAGS 1068 0x0001=hide-field-captions 1069end 1070 1071# CHRADAR, CHRADARAREA ------------------------------------------------------- 1072 1073flagslist=CHRADAR-FLAGS 1074 0x0001=axis-labels 1075 0x0002=shadow 1076end 1077 1078# CHPROPERTIES --------------------------------------------------------------- 1079 1080shortlist=CHPROPERTIES-EMPTYCELLS,0,do-not-plot,as-zero,interpolated 1081 1082flagslist=CHPROPERTIES-FLAGS 1083 0x0001=manual-series 1084 0x0002=plot-visible-only 1085 0x0004=fixed-size 1086 0x0008=manual-plotarea 1087 0x0010=apply-plotarea-pos 1088end 1089 1090# CHSCATTER ------------------------------------------------------------------ 1091 1092shortlist=CHSCATTER-SIZETYPE,0,none,area,width 1093 1094flagslist=CHSCATTER-FLAGS 1095 0x0001=bubbles 1096 0x0002=show-negative 1097 0x0004=shadow 1098end 1099 1100# CHSERERRORBAR -------------------------------------------------------------- 1101 1102shortlist=CHSERERRORBAR-TYPE,1,x-plus,x-minus,y-plus,y-minus 1103shortlist=CHSERERRORBAR-SOURCE,1,percent,fixed,std-deviation,custom,std-error 1104 1105# CHSERIES ------------------------------------------------------------------- 1106 1107shortlist=CHSERIES-TYPE,0,date,numeric,sequence,text 1108 1109# CHSERIESFORMAT ------------------------------------------------------------- 1110 1111flagslist=CHSERIESFORMAT-FLAGS 1112 0x0001=spline 1113 0x0002=bubbles-3d 1114 0x0004=shadow 1115end 1116 1117# CHSERTRENDLINE ------------------------------------------------------------- 1118 1119shortlist=CHSERTRENDLINE-TYPE,0,poynomial,exponential,logarithmic,power,moving-average 1120 1121# CHSOURCELINK --------------------------------------------------------------- 1122 1123shortlist=CHSOURCELINK-TARGET,0,title,values,category,bubbles 1124shortlist=CHSOURCELINK-TYPE,0,default,constant,sheet-link 1125 1126flagslist=CHSOURCELINK-FLAGS 1127 0x0001=custom-numfmt 1128end 1129 1130# CHSTRING ------------------------------------------------------------------- 1131 1132shortlist=CHSTRING-TYPE,0,text,category-default,value-default,x-prefix,x-postfix,y-prefix,y-postfix,comment 1133 1134# CHSURFACE ------------------------------------------------------------------ 1135 1136flagslist=CHSURFACE-FLAGS 1137 0x0001=filled 1138 0x0002=shadow 1139end 1140 1141# CHTEXT --------------------------------------------------------------------- 1142 1143shortlist=CHTEXT-HORALIGN,1,left,center,right,block,distribute 1144shortlist=CHTEXT-VERALIGN,1,top,center,bottom,block,distribute 1145shortlist=CHTEXT-FILLMODE,1,transparent,opaque 1146 1147flagslist=CHTEXT-FLAGS1-BIFF2 1148 0x0001=auto-color 1149 0x0002=show-symbol 1150 0x0004=show-value 1151 0x0008=vertical 1152 0x0010=auto-text 1153 0x0020=default-format 1154 0x0040=deleted 1155 0x0080=auto-fill 1156end 1157 1158combilist=CHTEXT-FLAGS1-BIFF3 1159 include=CHTEXT-FLAGS1-BIFF2 1160 0x0700=uint8,dec,orientation,TEXTORIENTATION 1161end 1162 1163combilist=CHTEXT-FLAGS1-BIFF5 1164 include=CHTEXT-FLAGS1-BIFF3 1165 0x0800=show-categ-percent 1166 0x1000=show-percent 1167end 1168 1169combilist=CHTEXT-FLAGS1-BIFF8 1170 include=CHTEXT-FLAGS1-BIFF5 1171 0x2000=show-bubble-size 1172 0x4000=show-categ 1173end 1174 1175combilist=CHTEXT-FLAGS2 1176 ignore=0x3FF0 1177 0x000F=uint8,dec,placement,CHTEXT-PLACEMENT 1178 0xC000=uint8,dec,text-dir,XF-TEXTDIRECTION 1179end 1180 1181shortlist=CHTEXT-PLACEMENT,0,context,outside,inside,center,axis,above,below,left,right,auto,manual 1182 1183# CHTICK --------------------------------------------------------------------- 1184 1185shortlist=CHTICK-TYPE,0,none,inside,outside,both 1186# TODO: really different label positions in BIFF2-BIFF4? 1187shortlist=CHTICK-LABELPOS-BIFF2,0,none,near,below,above 1188shortlist=CHTICK-LABELPOS-BIFF5,0,none,below,above,near 1189 1190flagslist=CHTICK-FLAGS-BIFF2 1191 0x0001=auto-color 1192 0x0002=auto-fill 1193end 1194 1195combilist=CHTICK-FLAGS-BIFF3 1196 include=CHTICK-FLAGS-BIFF2 1197 0x001C=uint8,dec,orientation,TEXTORIENTATION 1198 0x0020=auto-rotation 1199end 1200 1201# CHVALUERANGE --------------------------------------------------------------- 1202 1203flagslist=CHVALUERANGE-FLAGS 1204 ignore=0x0100 1205 0x0001=auto-minimum 1206 0x0002=auto-maximum 1207 0x0004=auto-major 1208 0x0008=auto-minor 1209 0x0010=auto-axis-cross 1210 0x0020=logarithmic 1211 0x0040=reverse-order 1212 0x0080=maximum-axis-cross 1213end 1214 1215# COLINFO -------------------------------------------------------------------- 1216 1217combilist=COLINFO-FLAGS 1218 0x0001=hidden 1219 0x0002=custom-width 1220 0x0004=best-fit 1221 0x0008=show-phonetic 1222 0x0700=uint8,dec,outline-level 1223 0x1000=outline-collapsed 1224end 1225 1226# CONNECTION ----------------------------------------------------------------- 1227 1228shortlist=CONNECTION-SOURCETYPE,1,odbc,dao,file,html,ole-db,text,ado,dsp 1229 1230flagslist=CONNECTION-FLAGS 1231 0x0001=save-password 1232 0x0002=html-tables 1233 0x0004=table-names 1234 0x0008=deleted 1235 0x0010=stand-alone 1236 0x0020=only-use-conn-file 1237 0x0040=background 1238 0x0080=refresh-on-load 1239 0x0100=save-data 1240end 1241 1242shortlist=CONNECTION-RECONNECTTYPE,0,as-required,always,never 1243shortlist=CONNECTION-CREDENTIALS,0,integrated,none,stored-sso,prompt 1244shortlist=CONNECTION-LINKEDOBJECTTYPE,0,none,query-table,pivot-cache 1245 1246# DATATABLE ------------------------------------------------------------------ 1247 1248flagslist=DATATABLE-FLAGS-BIFF3 1249 0x0001=recalc-always 1250 0x0002=recalc-on-load 1251 0x0004=row-table 1252 0x0008=table-2d 1253end 1254 1255flagslist=DATATABLE-FLAGS-BIFF8 1256 include=DATATABLE-FLAGS-BIFF3 1257 0x0010=ref1-deleted 1258 0x0020=ref2-deleted 1259end 1260 1261# DATAVALIDATION ------------------------------------------------------------- 1262 1263combilist=DATAVALIDATION-FLAGS 1264 0x0000000F=uint8,dec,type,DATAVALIDATION-TYPE 1265 0x00000070=uint8,dec,error-style,DATAVALIDATION-ERRORSTYLE 1266 0x00000080=string-list 1267 0x00000100=ignore-empty 1268 0x00000200=no-dropdown 1269 0x00040000=show-input-box 1270 0x00080000=show-error-box 1271 0x00F00000=uint8,dec,operator,DATAVALIDATION-OPERATOR 1272end 1273 1274shortlist=DATAVALIDATION-TYPE,0,any,whole,decimal,list,date,time,text-length,custom 1275shortlist=DATAVALIDATION-OPERATOR,0,between,not-between,equal,not-equal,greater-than,less-than,greater-equal,less-equal 1276shortlist=DATAVALIDATION-ERRORSTYLE,0,error,warning,info 1277 1278# DATAVALIDATIONS ------------------------------------------------------------ 1279 1280flagslist=DATAVALIDATIONS-FLAGS 1281 0x0001=input-box-visible 1282 0x0002=input-box-at-cell 1283 0x0004=cached 1284end 1285 1286# DATEMODE ------------------------------------------------------------------- 1287 1288shortlist=DATEMODE,0,1899-12-31,1904-01-01 1289 1290# DBQUERY -------------------------------------------------------------------- 1291 1292combilist=DBQUERY-FLAGS 1293 0x0007=uint8,dec,source-type,CONNECTION-SOURCETYPE 1294 0x0008=odbc-connection 1295 0x0010=sql-query 1296 0x0020=server-sql 1297 0x0040=html-query 1298 0x0080=save-password 1299 0x0100=html-tables 1300end 1301 1302# DEFINEDNAME ---------------------------------------------------------------- 1303 1304flagslist=DEFINEDNAME-FLAGS-BIFF2 1305 0x02=macro 1306 0x04=complex 1307end 1308 1309shortlist=DEFINEDNAME-MACROTYPE-BIFF2,0,none,function,procedure 1310 1311flagslist=DEFINEDNAME-FLAGS-BIFF3 1312 0x0001=hidden 1313 0x0002=function 1314 0x0004=command 1315 0x0008=macro 1316 0x0010=complex 1317 0x0020=builtin 1318end 1319 1320shortlist=DEFINEDNAME-BUILTINID,0,consolidate-area,auto-open,auto-close,extract,database,criteria,print-area,print-titles,recorder,data-form,auto-activate,auto-deactivate,sheet-title,filterdatabase 1321 1322combilist=DEFINEDNAME-FLAGS-BIFF4 1323 include=DEFINEDNAME-FLAGS-BIFF3 1324 0x0FC0=uint16,dec,func-group,DEFINEDNAME-FUNCGROUP 1325end 1326 1327combilist=DEFINEDNAME-FLAGS-BIFF5 1328 include=DEFINEDNAME-FLAGS-BIFF4 1329 0x0004=vba 1330 0x1000=binary 1331end 1332 1333shortlist=DEFINEDNAME-FUNCGROUP,0,none,financial,date-time,math-trig,statistical,lookup-ref,database,text,logical,information,commands,customizing,macro-control,dde-external,user-definded 1334 1335constlist=DEFINEDNAME-SHEETIDX 1336 default= 1337 0=global 1338end 1339 1340# DEFROWHEIGHT --------------------------------------------------------------- 1341 1342combilist=DEFROWHEIGHT-FLAGS-BIFF2 1343 0x7FFF=uint16,dec,row-height,CONV-TWIP-TO-PT 1344 0x8000=unchanged 1345end 1346 1347flagslist=DEFROWHEIGHT-FLAGS-BIFF3 1348 0x0001=custom-height 1349 0x0002=hidden 1350 0x0004=thick-top 1351 0x0008=thick-bottom 1352end 1353 1354# DXF ------------------------------------------------------------------------ 1355 1356flagslist=DXF-FLAGS 1357 0x0001=!swap-fg-bg-color 1358 0x0002=use-internal-borders 1359end 1360 1361multilist=DXF-SUBREC 1362 0=FILL-PATTERN,FILL-FGCOLOR,FILL-BGCOLOR,FILL-GRADIENT,FILL-STOP 1363 5=FONT-COLOR,BORDER-TOP,BORDER-BOTTOM,BORDER-LEFT,BORDER-RIGHT 1364 10=BORDER-DIAGONAL,BORDER-VERTICAL,BORDER-HORIZONTAL,BORDER-DIAGUP,BORDER-DIAGDOWN 1365 15=ALIGN-HORIZONTAL,ALIGN-VERTICAL,ALIGN-ROTATION,ALIGN-INDENT,ALIGN-READINGORDER 1366 20=ALIGN-WRAPTEXT,ALIGN-JUSTLASTLINE,ALIGN-SHRINKTOFIT,ALIGN-MERGED,FONT-NAME 1367 25=FONT-WEIGHT,FONT-UNDERLINE,FONT-ESCAPEMENT,FONT-ITALIC,FONT-STRIKE 1368 30=FONT-OUTLINE,FONT-SHADOW,FONT-CONDENSE,FONT-EXTEND,FONT-CHARSET 1369 35=FONT-PITCHFAMILY,FONT-HEIGHT,FONT-SCHEME,NUMFMT-CODE, 1370 40=,NUMFMT-ID,ALIGN-RELINDENT,PROT-LOCKED,PROT-HIDDEN 1371end 1372 1373# EXTERNALBOOK --------------------------------------------------------------- 1374 1375constlist=EXTERNALBOOK-KEY 1376 0x0401=self-reference 1377 0x3A01=analysis-addin 1378end 1379 1380# EXTERNALNAME --------------------------------------------------------------- 1381 1382flagslist=EXTERNALNAME-FLAGS-BIFF3 1383 0x0001=builtin 1384 0x0002=automatic 1385 0x0004=pic-link 1386 0x0008=dde-stddocumentname 1387end 1388 1389combilist=EXTERNALNAME-FLAGS-BIFF5 1390 include=EXTERNALNAME-FLAGS-BIFF3 1391 0x0010=ole-link 1392 0x7FE0=uint16,dec,clipboard-format 1393 0x8000=iconified 1394end 1395 1396# EXTERNSHEET ---------------------------------------------------------------- 1397 1398constlist=EXTERNSHEET-IDX-BIFF8 1399 default= 1400 -1=deleted 1401 -2=special 1402end 1403 1404# FILEPASS ------------------------------------------------------------------- 1405 1406shortlist=FILEPASS-TYPE,0,xor,rc4 1407shortlist=FILEPASS-MAJOR,1,rc4,crypto-api-2003,crypto-api-2007 1408 1409# FILTERCOLUMN --------------------------------------------------------------- 1410 1411combilist=FILTERCOLUMN-FLAGS 1412 0x0001=!and!or 1413 0x0004=op-1-simple 1414 0x0008=op-2-simple 1415 0x0010=top-10 1416 0x0020=!bottom!top 1417 0x0040=percent 1418 0xFF80=uint16,dec,top-10-count 1419end 1420 1421constlist=FILTERCOLUMN-DATATYPE 1422 0=none 1423 2=rk 1424 4=double 1425 6=string 1426 8=boolean 1427 12=blank 1428 14=not-blank 1429end 1430 1431shortlist=FILTERCOLUMN-OPERATOR,0,none,less,equal,less-equal,greater,not-equal,greater-equal 1432 1433# FONT ----------------------------------------------------------------------- 1434 1435flagslist=FONT-FLAGS 1436 0x0001=bold 1437 0x0002=italic 1438 0x0004=underline 1439 0x0008=strikeout 1440 0x0010=outline 1441 0x0020=shadow 1442 0x0040=condense 1443 0x0080=extend 1444end 1445 1446multilist=FONT-UNDERLINE 1447 0x00=none,single,double 1448 0x21=single-acc,double-acc 1449end 1450 1451shortlist=FONT-ESCAPEMENT,0,none,superscript,subscript 1452 1453# FORMULA -------------------------------------------------------------------- 1454 1455flagslist=FORMULA-FLAGS-BIFF2 1456 0x0001=recalc-always 1457end 1458 1459flagslist=FORMULA-FLAGS-BIFF3 1460 include=FORMULA-FLAGS-BIFF2 1461 0x0002=recalc-onload 1462end 1463 1464flagslist=FORMULA-FLAGS-BIFF5 1465 include=FORMULA-FLAGS-BIFF3 1466 0x0008=shared-fmla 1467end 1468 1469shortlist=FORMULA-RESULTTYPE,0,string,boolean,error,empty 1470 1471# GUTS ----------------------------------------------------------------------- 1472 1473shortlist=GUTS-LEVELS,0,none,,1-level,2-levels,3-levels,4-levels,5-levels,6-levels,7-levels 1474 1475# HEADERFOOTER --------------------------------------------------------------- 1476 1477flagslist=HEADERFOOTER-FLAGS 1478 ignore=0xFFF0 1479 0x0001=has-even-hf 1480 0x0002=has-first-hf 1481 0x0004=scale-with-sheet 1482 0x0008=align-with-margins 1483end 1484 1485# HIDEOBJ -------------------------------------------------------------------- 1486 1487shortlist=HIDEOBJ,0,show,placeholder,hide 1488 1489# IMGDATA -------------------------------------------------------------------- 1490 1491constlist=IMGDATA-FORMAT 1492 -1=none 1493 2=wmf-pict 1494 9=dib 1495 14=native 1496end 1497 1498shortlist=IMGDATA-ENV,1,windows,apple 1499 1500# NOTE ----------------------------------------------------------------------- 1501 1502flagslist=NOTE-FLAGS-BIFF8 1503 0x0002=visible 1504 0x0080=row-hidden 1505 0x0100=col-hidden 1506end 1507 1508# NOTESOUND ------------------------------------------------------------------ 1509 1510constlist=NOTESOUND-FORMAT 1511 1=pcm 1512 3=ieee-float 1513 6=a-law 1514 7=mu-law 1515 0xFFFE=extensible 1516end 1517 1518# OBJ ------------------------------------------------------------------------ 1519 1520# object types --- 1521 1522multilist=OBJ-TYPE-BIFF3 1523 0=group,line,rectangle,oval,arc,chart,textbox,button,picture 1524end 1525 1526multilist=OBJ-TYPE-BIFF4 1527 include=OBJ-TYPE-BIFF3 1528 9=polygon 1529end 1530 1531multilist=OBJ-TYPE-BIFF5 1532 include=OBJ-TYPE-BIFF4 1533 10=,checkbox,optionbutton,edit,label,dialog,spin,scrollbar,listbox,groupbox 1534 20=dropdown 1535end 1536 1537multilist=OBJ-TYPE-BIFF8 1538 include=OBJ-TYPE-BIFF5 1539 25=note 1540 30=drawing 1541end 1542 1543# flags and constants --- 1544 1545flagslist=OBJ-FLAGS-BIFF3 1546 0x0001=selected 1547 0x0002=auto-size 1548 0x0004=auto-move 1549 0x0010=protected 1550 0x0080=grouped 1551 0x0100=hidden 1552 0x0200=visible 1553end 1554 1555flagslist=OBJ-FLAGS-BIFF4 1556 include=OBJ-FLAGS-BIFF3 1557 0x0400=printable 1558end 1559 1560flagslist=OBJ-AUTO-FLAGS 1561 0x01=auto 1562end 1563 1564multilist=OBJ-LINETYPE 1565 0=solid,dash,dot,dash-dot,dash-dot-dot,25%-pattern,50%-pattern,75%-pattern 1566 255=none 1567end 1568 1569shortlist=OBJ-LINEWEIGHT,0,hair,thin,medium,thick 1570 1571shortlist=OBJ-ARROWHEAD-TYPE,0,none,open,filled,double-end-open,double-end-filled 1572shortlist=OBJ-ARROWHEAD-WIDTH,0,narrow,medium,wide 1573shortlist=OBJ-ARROWHEAD-LENGTH,0,short,medium,long 1574 1575combilist=OBJ-LINEENDS 1576 0x000F=uint8,dec,arrowhead-type,OBJ-ARROWHEAD-TYPE 1577 0x00F0=uint8,dec,arrowhead-width,OBJ-ARROWHEAD-WIDTH 1578 0x0F00=uint8,dec,arrowhead-length,OBJ-ARROWHEAD-LENGTH 1579end 1580 1581shortlist=OBJ-LINEDIR,0,topleft-to-bottomright,topright-to-bottomleft,bottomright-to-topleft,bottomleft-to-topright 1582 1583shortlist=OBJ-ARC-QUADRANT,0,upper-right,upper-left,lower-left,lower-right 1584 1585combilist=OBJ-FRAMESTYLE-FLAGS 1586 0x0001=rounded 1587 0x0002=shadow 1588 0x03FC=uint16,dec,rounded-diameter 1589end 1590 1591shortlist=OBJ-HORALIGN,0,none,left,center,right,justify 1592shortlist=OBJ-VERALIGN,0,none,top,center,bottom,justify 1593 1594combilist=OBJ-TEXT-FLAGS 1595 0x000E=uint16,dec,hor-align,OBJ-HORALIGN 1596 0x0070=uint16,dec,ver-align,OBJ-VERALIGN 1597 0x0080=auto-size 1598 0x0200=text-locked 1599 0x0400=selected 1600end 1601 1602flagslist=OBJ-PICTURE-FLAGS 1603 0x0001=auto-size 1604 0x0002=linked 1605 0x0008=symbol 1606end 1607 1608flagslist=OBJ-POLYGON-FLAGS 1609 0x0100=closed 1610end 1611 1612flagslist=OBJ-CHART-FLAGS-BIFF5 1613 0x0001=linked-to-sheet 1614end 1615 1616flagslist=OBJ-BUTTON-FLAGS-BIFF5 1617 0x0001=default-btn 1618 0x0002=help-btn 1619 0x0004=cancel-btn 1620 0x0008=close-btn 1621end 1622 1623shortlist=OBJ-CHECKBOX-STATE-BIFF5,0,unchecked,checked,tristate 1624 1625flagslist=OBJ-CHECKBOX-FLAGS-BIFF5 1626 0x0001=flat 1627 0x0002=box-only 1628end 1629 1630shortlist=OBJ-EDIT-TYPE-BIFF5,0,text,integer,double,reference,formula 1631 1632flagslist=OBJ-SCROLLBAR-FLAGS-BIFF5 1633 0x0001=visible 1634 0x0002=slider-only 1635 0x0004=tracking 1636 0x0008=flat 1637end 1638 1639combilist=OBJ-LISTBOX-FLAGS-BIFF5 1640 0x0004=linked-edit 1641 0x0008=flat 1642 0x0030=uint8,dec,selection-type,OBJ-LISTBOX-SELTYPE-BIFF5 1643end 1644 1645shortlist=OBJ-LISTBOX-SELTYPE-BIFF5,0,single,multi,range 1646 1647flagslist=OBJ-GROUPBOX-FLAGS-BIFF5 1648 0x0001=flat 1649end 1650 1651combilist=OBJ-DROPDOWN-FLAGS-BIFF5 1652 0x0003=uint8,dec,type,OBJ-DROPDOWN-TYPE-BIFF5 1653 0x0008=filtered 1654end 1655 1656shortlist=OBJ-DROPDOWN-TYPE-BIFF5,0,listbox,combobox,simple,max 1657 1658multilist=OBJ-RECNAMES-BIFF8 1659 0x0000=OBJEND,,,,OBJMACRO,,OBJGMO,OBJCF 1660 0x0008=OBJFLAGS,OBJPICTFMLA,OBJCBLS,OBJRBO,OBJSBS,OBJNTS,OBJSBSFMLA,OBJGBODATA 1661 0x0010=OBJEDODATA,OBJRBODATA,OBJCBLSDATA,OBJLBSDATA,OBJCBLSFMLA,OBJCMO,, 1662end 1663 1664flagslist=OBJFLAGS-FLAGS 1665 0x0001=manual-size 1666 0x0002=linked 1667 0x0004=update-on-print 1668 0x0008=symbol 1669 0x0010=control 1670 0x0020=ctls-stream 1671 0x0080=camera-pic 1672 0x0100=default-size 1673 0x0200=auto-load 1674end 1675 1676flagslist=OBJCMO-FLAGS 1677 0x0001=locked 1678 0x0004=default-size 1679 0x0008=published 1680 0x0010=printable 1681 0x0080=disabled 1682 0x0100=auxiliary 1683 0x0200=recalc-on-load 1684 0x1000=recalc-always 1685 0x2000=auto-line 1686 0x4000=auto-area 1687end 1688 1689# PAGELAYOUTVIEW ------------------------------------------------------------- 1690 1691flagslist=PAGELAYOUTVIEW-FLAGS 1692 ignore=0xFFF8 1693 0x0001=page-layout-view 1694 0x0002=show-ruler 1695 0x0004=hide-margins 1696end 1697 1698# PAGESETUP ------------------------------------------------------------------ 1699 1700multilist=PAGESETUP-PAPERSIZE 1701 0=undefined,letter,letter-small,tabloid,ledger,legal,statement,executive,a3,a4 1702 10=a4-small,a5,b4,b5,folio,quarto,10x14,11x17,note,envelope-9 1703 20=envelope-10,envelope-11,envelope-12,envelope-14,c,d,e,envelope-dl,envelope-c5,envelope-c3 1704 30=envelope-c4,envelope-c6,envelope-c65,envelope-b4,envelope-b5,envelope-b6,envelope-italy,envelope-monarch,envelope-6-3/4,us-standard-fanfold 1705 40=german-standard-fanfold,german-legal-fanfold,b4,japanese-dbl-postcaed,9x11,10x11,15x11,, 1706 50=envelope-invite,letter-extra,legal-extra,tabloid-extra,a4-extra,letter-transverse,a4-transverse,letter-extra-transverse,super-a-a4,super-b-a3,letter-plus 1707 60=a4-plus,a5-transverse,jis-b5-transverse,a3-extra,a5-extra,b5-extra,a2,a3-transverse,a3-extra-transverse 1708end 1709 1710constlist=PAGESETUP-SCALETOPAGES 1711 default= 1712 0=automatic 1713end 1714 1715flagslist=PAGESETUP-FLAGS-BIFF4 1716 0x0001=print-in-rows 1717 0x0002=portrait 1718 0x0004=uninitialized 1719 0x0008=black-and-white 1720end 1721 1722flagslist=PAGESETUP-FLAGS-BIFF5 1723 include=PAGESETUP-FLAGS-BIFF4 1724 0x0010=draft-quality 1725 0x0020=print-notes 1726 0x0040=default-orientation 1727 0x0080=use-first-page 1728end 1729 1730combilist=PAGESETUP-FLAGS-BIFF8 1731 include=PAGESETUP-FLAGS-BIFF5 1732 0x0200=print-notes-at-end 1733 0x0C00=uint8,dec,print-errors,PAGESETUP-PRINTERRORS 1734end 1735 1736shortlist=PAGESETUP-PRINTERRORS,0,displayed,none,as-dashes,as-na 1737 1738unitconverter=PAGESETUP-DPI,1,dpi 1739 1740# PANE ----------------------------------------------------------------------- 1741 1742shortlist=PANE-ID,0,bottom-right,top-right,bottom-left,top-left 1743 1744# PCDEFINITION --------------------------------------------------------------- 1745 1746flagslist=PCDEFINITION-FLAGS 1747 0x0001=save-data 1748 0x0002=invalid 1749 0x0004=refresh-on-load 1750 0x0008=optimize-memory 1751 0x0010=background-query 1752 0x0020=enable-refresh 1753end 1754 1755# PCDFIELD ------------------------------------------------------------------- 1756 1757flagslist=PCDFIELD-FLAGS 1758 0x0001=has-items 1759 0x0002=has-unshared-items 1760 0x0004=calculated 1761 0x0008=has-parent 1762 0x0010=range-group 1763 0x0020=is-numeric 1764 0x0040=is-integer 1765 0x0080=has-semi-mixed-types 1766 0x0100=has-min-max 1767 0x0200=16bit-indexes 1768 0x0400=has-non-date 1769 0x0800=has-date 1770end 1771 1772# PCDFRANGEPR ---------------------------------------------------------------- 1773 1774combilist=PCDFRANGEPR-FLAGS 1775 ignore=0xFFE0 1776 0x0001=auto-start 1777 0x0002=auto-end 1778 0x001C=uint8,dec,group-by,PCDFRANGEPR-GROUPBY 1779end 1780 1781shortlist=PCDFRANGEPR-GROUPBY,0,numeric,seconds,minutes,hours,days,months,quarters,years 1782 1783# PCDFSQLTYPE ---------------------------------------------------------------- 1784 1785shortlist=PCDFSQLTYPE-DATATYPE,0,unknown,char,numeric,decimal,int32,int16,float,real,double,,,datetime,var-char 1786 1787# PCDSOURCE ------------------------------------------------------------------ 1788 1789flagslist=PCDSOURCE-TYPE 1790 0x0001=spreadsheet 1791 0x0002=extern 1792 0x0004=consolidation-area 1793 0x0010=scenario 1794end 1795 1796# PHONETICPR ----------------------------------------------------------------- 1797 1798shortlist=PHONETICPR-TYPE,0,halfwidth-katakana,fullwidth-katakana,hiragana,no-conversion 1799shortlist=PHONETICPR-ALIGNMENT,0,no-control,left,center,distributed 1800 1801combilist=PHONETICPR-FLAGS 1802 ignore=0xFFF0 1803 0x0003=uint8,dec,type,PHONETICPR-TYPE 1804 0x000C=uint8,dec,alignment,PHONETICPR-ALIGNMENT 1805end 1806 1807# PROJEXTSHEET --------------------------------------------------------------- 1808 1809shortlist=PROJEXTSHEET-TYPE,0,sheet,macro,chart 1810 1811# PTDATAFIELD ---------------------------------------------------------------- 1812 1813shortlist=PTDATAFIELD-SUBTOTAL,0,sum,count-all,average,max,min,product,count-num,std-dev,std-dev-p,variance,variance-p 1814shortlist=PTDATAFIELD-SHOWDATAAS,0,normal,diff-from,percent-of,percent-diff-from,running-total-in,percent-of-row,percent-of-column,percent-of-total,index 1815 1816multilist=PTDATAFIELD-BASEITEM 1817 default= 1818 0x7FFB=previous-item,next-item 1819end 1820 1821# PTDEFINITION --------------------------------------------------------------- 1822 1823flagslist=PTDEFINITION-FLAGS 1824 0x0001=row-grandtotals 1825 0x0002=column-grandtotals 1826 0x0008=auto-format 1827 0x0010=size-auto-format 1828 0x0020=font-auto-format 1829 0x0040=align-auto-format 1830 0x0080=border-auto-format 1831 0x0100=pattern-auto-format 1832 0x0200=number-auto-format 1833end 1834 1835constlist=PTDEFINITION-DATAFIELD-POS 1836 default= 1837 -1=append 1838end 1839 1840# PTDEFINITION2 -------------------------------------------------------------- 1841 1842combilist=PTDEFINITION2-FLAGS 1843 0x00000001=page-over-then-down 1844 0x000001FE=dec,uint8,page-wrap 1845 0x00010000=enable-wizard 1846 0x00020000=enable-drill 1847 0x00040000=enable-field-props 1848 0x00080000=preserve-formatting 1849 0x00100000=merge-labels 1850 0x00200000=show-error 1851 0x00400000=show-missing 1852 0x00800000=multiple-page-items 1853end 1854 1855# PTFIELD -------------------------------------------------------------------- 1856 1857flagslist=PTFIELD-AXISTYPE 1858 0x0001=row 1859 0x0002=column 1860 0x0004=page 1861 0x0008=data 1862end 1863 1864flagslist=PTFIELD-SUBTOTALS 1865 0x0001=default 1866 0x0002=sum 1867 0x0004=count-all 1868 0x0008=average 1869 0x0010=max 1870 0x0020=min 1871 0x0040=product 1872 0x0080=count-num 1873 0x0100=std-dev 1874 0x0200=std-dev-p 1875 0x0400=variance 1876 0x0800=variance-p 1877end 1878 1879# PTFIELD2 ------------------------------------------------------------------- 1880 1881combilist=PTFIELD2-FLAGS 1882 0x00000001=show-all-items 1883 0x00000002=drag-to-row 1884 0x00000004=drag-to-column 1885 0x00000008=drag-to-page 1886 0x00000010=drag-to-hide 1887 0x00000080=server-based 1888 0x00000200=autosort 1889 0x00000400=ascend-sort 1890 0x00000800=autoshow 1891 0x00001000=autoshow-top 1892 0x00002000=calculated 1893 0x00200000=outline 1894 0x00400000=insert-blank-row 1895 0x00800000=subtotal-top 1896 0xFF000000=uint8,dec,autoshow-item-count 1897end 1898 1899# PTFITEM -------------------------------------------------------------------- 1900 1901multilist=PTFITEM-ITEMTYPE 1902 0=data,default,sum,count-all,average,max,min,product,count-num,std-dev,std-dev-p,variance,variance-p,grandtotal 1903 254=page,none 1904end 1905 1906flagslist=PTFITEM-FLAGS 1907 0x0001=hidden 1908 0x0002=hide-detail 1909 0x0008=calculated 1910 0x0010=missing 1911end 1912 1913constlist=PTFITEM-CACHEIDX 1914 default= 1915 -1=no-cache-item 1916end 1917 1918# PTPAGEFIELDS --------------------------------------------------------------- 1919 1920constlist=PTPAGEFIELDS-ITEM 1921 default= 1922 0x7FFD=all 1923end 1924 1925# PTROWCOLITEMS -------------------------------------------------------------- 1926 1927shortlist=PTROWCOLITEMS-ITEMTYPE,0,data,default,sum,count-all,average,max,min,product,count-num,std-dev,std-dev-p,variance,variance-p,grandtotal,blank-line 1928 1929combilist=PTROWCOLITEMS-FLAGS 1930 ignore=0xC000 1931 0x0001=field-name 1932 0x01FE=uint16,dec,data-field-idx 1933 0x0200=subtotal 1934 0x0400=blocktotal 1935 0x0800=grandtotal 1936 0x1000=multi-data 1937end 1938 1939# QUERYTABLE ----------------------------------------------------------------- 1940 1941combilist=QUERYTABLE-FLAGS 1942 0x0001=headers 1943 0x0002=row-numbers 1944 0x0004=disable-refresh 1945 0x0008=background 1946 0x0010=first-background 1947 0x0020=refresh-on-load 1948 0x0040=delete-unused 1949 0x0080=fill-formulas 1950 0x0100=adjust-column-width 1951 0x0200=save-data 1952 0x0400=disable-edit 1953 0x2000=overwrite-existing 1954end 1955 1956combilist=QUERYTABLE-AUTOFORMAT-FLAGS 1957 0x0001=apply-num-fmt 1958 0x0002=apply-font 1959 0x0004=apply-alignment 1960 0x0008=apply-border 1961 0x0010=apply-fill 1962 0x0020=apply-protection 1963end 1964 1965# QUERYTABLEREFRESH ---------------------------------------------------------- 1966 1967flagslist=QUERYTABLEREFRESH-FLAGS 1968 0x0001=enable-refresh 1969 0x0002=pivot-cache-invalid 1970 0x0004=olap-pivot-table 1971end 1972 1973flagslist=QUERYTABLEREFRESH-PTFLAGS 1974 0x00000001=disable-draw-drop 1975 0x00000002=hide-totals-annotation 1976 0x00000008=include-empty-rows 1977 0x00000010=include-empty-columns 1978end 1979 1980flagslist=QUERYTABLEREFRESH-QTFLAGS 1981 0x00000001=preserve-formatting 1982 0x00000002=adjust-column-width 1983 0x00000010=ext-data-list 1984 0x00000040=create-table-list 1985 0x00000080=create-dummy-list 1986end 1987 1988# QUERYTABLESETTINGS --------------------------------------------------------- 1989 1990flagslist=QUERYTABLESETTINGS-FLAGS 1991 0x0001=keep-alive 1992 0x0002=new 1993 0x0004=source-data 1994 0x0008=web-based-prov 1995 0x0010=reinit-list 1996 0x0080=xml 1997end 1998 1999flagslist=QUERYTABLESETTINGS-HTML-FLAGS 2000 0x0001=parse-pre 2001 0x0002=consecutive-delimiters 2002 0x0004=first-row 2003 0x0008=xl97-created 2004 0x0010=text-dates 2005 0x0020=xl2000-refreshed 2006end 2007 2008combilist=QUERYTABLESETTINGS-OLEDB-FLAGS 2009 0x0007=uint8,dec,command-type,QUERYTABLESETTINGS-OLEDB-COMMANDTYPE 2010 0x0008=alt-connection-string 2011 0x0010=no-refresh-cube 2012 0x0020=olap-has-locale 2013 0x0040=server-num-fmt 2014 0x0080=server-fill-color 2015 0x0100=server-font-color 2016 0x0200=server-font-format 2017 0x0400=olap-member-l10n 2018end 2019 2020shortlist=QUERYTABLESETTINGS-OLEDB-COMMANDTYPE,0,none,cube,sql,table,default,list 2021 2022flagslist=QUERYTABLESETTINGS-ADO-FLAGS 2023 0x0100=ado-refreshable 2024end 2025 2026flagslist=QUERYTABLESETTINGS-EXT-FLAGS 2027 0x0001=text-query 2028 0x0002=table-names 2029end 2030 2031unitconverter=QUERYTABLESETTINGS-INTERVAL,60,sec 2032shortlist=QUERYTABLESETTINGS-HTMLFORMAT,1,none,rtf,all 2033 2034# REFMODE -------------------------------------------------------------------- 2035 2036shortlist=REFMODE,0,R1C1,A1 2037 2038# ROW ------------------------------------------------------------------------ 2039 2040combilist=ROW-HEIGHT 2041 0x7FFF=uint16,dec,height,CONV-TWIP-TO-PT 2042 0x8000=default-height 2043end 2044 2045combilist=ROW-FLAGS 2046 ignore=0x00000100 2047 0x00000007=uint8,dec,outline-level 2048 0x00000010=outline-collapsed 2049 0x00000020=hidden 2050 0x00000040=custom-height 2051 0x00000080=custom-format 2052 0x0FFF0000=uint16,dec,custom-xf-idx 2053 0x10000000=thick-top 2054 0x20000000=thick-bottom 2055 0x40000000=show-phonetic 2056end 2057 2058# SHAREDFEATHEAD ------------------------------------------------------------- 2059 2060shortlist=SHAREDFEATHEAD-TYPE,2,protection,ignored-formula-errors,smarttag,table 2061 2062flagslist=SHAREDFEATHEAD-PROT-FLAGS 2063 0x00000001=edit-object 2064 0x00000002=edit-scenario 2065 0x00000004=format-cell 2066 0x00000008=format-column 2067 0x00000010=format-row 2068 0x00000020=insert-column 2069 0x00000040=insert-row 2070 0x00000080=insert-hyperlink 2071 0x00000100=delete-column 2072 0x00000200=delete-row 2073 0x00000400=select-locked 2074 0x00000800=sort 2075 0x00001000=use-autofilter 2076 0x00002000=pivottable-report 2077 0x00004000=select-unlocked 2078end 2079 2080# SHEET ---------------------------------------------------------------------- 2081 2082shortlist=SHEET-STATE,0,visible,hidden,very-hidden 2083shortlist=SHEET-TYPE,0,worksheet,macrosheet,chartsheet,,,,vb-module 2084 2085# SHEETEXT ------------------------------------------------------------------- 2086 2087combilist=SHEETEXT-FLAGS1 2088 0x0000007F=uint8,dec,color-idx,SHEETEXT-COLOR 2089end 2090 2091constlist=SHEETEXT-COLOR 2092 include=COLORS 2093 0x7F=undefined 2094end 2095 2096combilist=SHEETEXT-FLAGS2 2097 include=SHEETEXT-FLAGS1 2098 0x00000080=eval-cond-formats 2099 0x00000100=!published!unpublished 2100end 2101 2102# SHEETPR -------------------------------------------------------------------- 2103 2104shortlist=SHEETPR-WINDOWPOS,0,tiled,horizontal,vertical,cascaded 2105 2106flagslist=SHEETPR-FLAGS-BIFF3 2107 0x0001=show-autopagebreaks 2108 0x0020=outline-auto-style 2109 0x0040=outline-symbols-below 2110 0x0080=outline-symbols-right 2111 0x0100=fit-to-pages 2112 0x0200=skip-linked-values 2113 0x0400=show-row-outline 2114 0x0800=show-column-outline 2115end 2116 2117flagslist=SHEETPR-FLAGS-BIFF4 2118 include=SHEETPR-FLAGS-BIFF3 2119 0x3000=uint8,dec,window-pos,SHEETPR-WINDOWPOS 2120 0x4000=lotus-expr-eval 2121 0x8000=lotus-formula-edit 2122end 2123 2124flagslist=SHEETPR-FLAGS-BIFF5 2125 include=SHEETPR-FLAGS-BIFF4 2126 exclude=0x0200,0x3000 2127 0x0010=dialog-sheet 2128end 2129 2130# STYLE ---------------------------------------------------------------------- 2131 2132combilist=STYLE-FLAGS 2133 0x0FFF=uint16,dec,xf-idx 2134 0x8000=builtin 2135end 2136 2137shortlist=STYLE-BUILTIN,-1,user-defined,normal,rowlevel,collevel,comma,currency,percent,comma-0,currency-0,hyperlink,followed-hyperlink 2138 2139# STYLEEXT ------------------------------------------------------------------- 2140 2141flagslist=STYLEEXT-FLAGS 2142 0x01=builtin 2143 0x02=hidden 2144 0x04=custom 2145end 2146 2147shortlist=STYLEEXT-CATEGORY,0,custom,good-bad-neutral,data-model,title-heading,themed,number-format 2148 2149multilist=STYLEEXT-BUILTIN 2150 include=STYLE-BUILTIN 2151 10=note,warning-text,,,,title,heading-1,heading-2,heading-3,heading-4 2152 20=input,output,calculation,check-cell,linked-cell,total,good,bad,neutral,accent1 2153 30=20%-accent1,40%-accent1,60%-accent1,accent2,20%-accent2,40%-accent2,60%-accent2,accent3,20%-accent3,40%-accent3 2154 40=60%-accent3,accent4,20%-accent4,40%-accent4,60%-accent4,accent5,20%-accent5,40%-accent5,60%-accent5,accent6 2155 50=20%-accent6,40%-accent6,60%-accent6,explanatory-text 2156end 2157 2158# THEME ---------------------------------------------------------------------- 2159 2160constlist=THEME-VERSION 2161 0=custom 2162 123820=default 2163 124226=default 2164end 2165 2166# TXO ------------------------------------------------------------------------ 2167 2168combilist=TXO-FLAGS 2169 0x000E=uint16,dec,hor-align,OBJ-HORALIGN 2170 0x0070=uint16,dec,ver-align,OBJ-VERALIGN 2171 0x0200=text-locked 2172end 2173 2174# WINDOW1 -------------------------------------------------------------------- 2175 2176flagslist=WINDOW1-FLAGS 2177 0x0001=hidden 2178 0x0002=minimized 2179 0x0008=show-horizontal-scroll 2180 0x0010=show-vertical-scroll 2181 0x0020=show-tabbar 2182end 2183 2184unitconverter=WINDOW1-TABBARRATIO,/10,% 2185 2186# WINDOW2 -------------------------------------------------------------------- 2187 2188flagslist=WINDOW2-FLAGS-BIFF3 2189 0x0001=show-formulas 2190 0x0002=show-gridlines 2191 0x0004=show-headings 2192 0x0008=frozen-panes 2193 0x0010=show-zeros 2194 0x0020=default-gridcolor 2195 0x0040=right-to-left 2196 0x0080=show-outline-symbols 2197 0x0100=remove-split-with-freeze 2198end 2199 2200flagslist=WINDOW2-FLAGS-BIFF5 2201 include=WINDOW2-FLAGS-BIFF3 2202 0x0200=sheet-selected 2203 0x0400=sheet-active 2204end 2205 2206flagslist=WINDOW2-FLAGS-BIFF8 2207 include=WINDOW2-FLAGS-BIFF5 2208 0x0800=pagebreak-mode 2209end 2210 2211# XF ------------------------------------------------------------------------- 2212 2213shortlist=XF-HORALIGN,0,general,left,center,right,fill,block,center-across-sel,distribute 2214shortlist=XF-VERALIGN,0,top,center,bottom,justify,distribute 2215shortlist=XF-TEXTDIRECTION,0,context,left-to-right,right-to-left 2216 2217flagslist=XF-PROTECTION-FLAGS 2218 0x01=locked 2219 0x02=formula-hidden 2220 0x04=style-xf 2221 0x08=apostroph-quote 2222end 2223 2224flagslist=XF-USEDATTRIBS-FLAGS 2225 0x04=format 2226 0x08=font 2227 0x10=alignment 2228 0x20=border 2229 0x40=area 2230 0x80=protection 2231end 2232 2233combilist=XF-STYLEFLAGS-BIFF2 2234 0x07=uint8,dec,hor-align,XF-HORALIGN 2235 0x08=left-border 2236 0x10=right-border 2237 0x20=top-border 2238 0x40=bottom-border 2239 0x80=fill 2240end 2241 2242combilist=XF-TYPEFLAGS-BIFF2 2243 0x3F=uint8,dec,fmt-idx,FORMATS 2244 0x40=locked 2245 0x80=formula-hidden 2246end 2247 2248flagslist=XF-TYPEFLAGS-BIFF3 2249 include=XF-PROTECTION-FLAGS 2250end 2251 2252combilist=XF-TYPEFLAGS-BIFF4 2253 include=XF-TYPEFLAGS-BIFF3 2254 0xFFF0=uint16,dec,parent-xf-idx 2255end 2256 2257combilist=XF-ALIGNMENT-BIFF3 2258 0x0007=uint8,dec,hor-align,XF-HORALIGN 2259 0x0008=text-wrap 2260 0xFFF0=uint16,dec,parent-xf-idx 2261end 2262 2263combilist=XF-ALIGNMENT-BIFF4 2264 0x07=uint8,dec,hor-align,XF-HORALIGN 2265 0x08=text-wrap 2266 0x30=uint8,dec,ver-align,XF-VERALIGN 2267 0xC0=uint8,dec,orientation,TEXTORIENTATION 2268end 2269 2270combilist=XF-ALIGNMENT-BIFF5 2271 0x07=uint8,dec,hor-align,XF-HORALIGN 2272 0x08=text-wrap 2273 0x70=uint8,dec,ver-align,XF-VERALIGN 2274 0x80=justify-lastline 2275end 2276 2277combilist=XF-ORIENTATTRIBS-BIFF5 2278 include=XF-USEDATTRIBS-FLAGS 2279 0x03=uint8,dec,orientation,TEXTORIENTATION 2280end 2281 2282combilist=XF-TEXTFLAGS-BIFF8 2283 0x0F=uint8,dec,indent 2284 0x10=shrink-to-fit 2285 0xC0=uint8,dec,text-dir,XF-TEXTDIRECTION 2286end 2287 2288combilist=XF-FILL-BIFF3 2289 0x003F=uint8,dec,fill-pattern,FILLPATTERNS 2290 0x07C0=uint8,dec,fg-color-idx,COLORS 2291 0xF800=uint8,dec,bg-color-idx,COLORS 2292end 2293 2294combilist=XF-BORDER-BIFF3 2295 0x00000007=uint8,dec,top-style,BORDERSTYLES 2296 0x000000F8=uint8,dec,top-color,COLORS 2297 0x00000700=uint8,dec,left-style,BORDERSTYLES 2298 0x0000F800=uint8,dec,left-color,COLORS 2299 0x00070000=uint8,dec,bottom-style,BORDERSTYLES 2300 0x00F80000=uint8,dec,bottom-color,COLORS 2301 0x07000000=uint8,dec,right-style,BORDERSTYLES 2302 0xF8000000=uint8,dec,right-color,COLORS 2303end 2304 2305combilist=XF-FILL-BIFF5 2306 0x0000007F=uint8,dec,fg-color-idx,COLORS 2307 0x00003F80=uint8,dec,bg-color-idx,COLORS 2308 0x003F0000=uint8,dec,fill-pattern,FILLPATTERNS 2309 0x01C00000=uint8,dec,bottom-style,BORDERSTYLES 2310 0xFE000000=uint8,dec,bottom-color,COLORS 2311end 2312 2313combilist=XF-BORDER-BIFF5 2314 0x00000007=uint8,dec,top-style,BORDERSTYLES 2315 0x00000038=uint8,dec,left-style,BORDERSTYLES 2316 0x000001C0=uint8,dec,right-style,BORDERSTYLES 2317 0x0000FE00=uint8,dec,top-color,COLORS 2318 0x007F0000=uint8,dec,left-color,COLORS 2319 0x3F800000=uint8,dec,right-color,COLORS 2320end 2321 2322combilist=XF-BORDERSTYLE-BIFF8 2323 0x000F=uint8,dec,left-style,BORDERSTYLES 2324 0x00F0=uint8,dec,right-style,BORDERSTYLES 2325 0x0F00=uint8,dec,top-style,BORDERSTYLES 2326 0xF000=uint8,dec,bottom-style,BORDERSTYLES 2327end 2328 2329combilist=XF-BORDERCOLOR1-BIFF8 2330 0x007F=uint8,dec,left-color,COLORS 2331 0x3F80=uint8,dec,right-color,COLORS 2332 0x4000=diag-tl-to-br 2333 0x8000=diag-bl-to-tr 2334end 2335 2336combilist=XF-BORDERCOLOR2-BIFF8 2337 0x0000007F=uint8,dec,top-color,COLORS 2338 0x00003F80=uint8,dec,bottom-color,COLORS 2339 0x001FC000=uint8,dec,diag-color,COLORS 2340 0x01E00000=uint8,dec,diag-style,BORDERSTYLES 2341 0xFC000000=uint8,dec,fill-pattern,FILLPATTERNS 2342end 2343 2344combilist=XF-FILLCOLOR-BIFF8 2345 0x007F=uint8,dec,fg-color-idx,COLORS 2346 0x3F80=uint8,dec,bg-color-idx,COLORS 2347end 2348 2349# BIFF2 cell records ---------------------------------------------------------- 2350 2351constlist=XFINDEX-BIFF2 2352 default= 2353 63=from-ixfe 2354end 2355 2356combilist=CELL-XFINDEX-BIFF2 2357 0x3F=uint8,dec,xf-idx,XFINDEX-BIFF2 2358 0x40=locked 2359 0x80=formula-hidden 2360end 2361 2362combilist=CELL-XFFORMAT-BIFF2 2363 0x3F=uint8,dec,fmt-idx,FORMATS 2364 0xC0=uint8,dec,font-idx,FONTNAMES 2365end 2366 2367combilist=CELL-XFSTYLE-BIFF2 2368 include=XF-STYLEFLAGS-BIFF2 2369end 2370 2371# XFEXT ---------------------------------------------------------------------- 2372 2373multilist=XFEXT-SUBREC 2374 0=,,,,FILL-FGCOLOR 2375 5=FILL-BGCOLOR,FILL-GRADIENT,BORDER-TOP-COLOR,BORDER-BOTTOM-COLOR,BORDER-LEFT-COLOR 2376 10=BORDER-RIGHT-COLOR,BORDER-DIAG-COLOR,,TEXT-COLOR,FONT-SCHEME 2377 15=INDENT 2378end 2379 2380# ============================================================================ 2381