oox/source/dump/biffdumper.ini

   1
   2 # dumper settings ============================================================
   3
   4 # Path to additional configuration data, relative to this file.
   5 include-config-file=dumperbase.ini
   6 include-config-file=dffdumper.ini
   7 include-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
  24 merge-continue-record=1
  25
  26 # name lists =================================================================
  27
  28 # common ---------------------------------------------------------------------
  29
  30 unitconverter=CONV-PERCENT-NEG,-1,%
  31 unitconverter=CONV-COLWIDTH,/256,chars
  32
  33 shortlist=BIFF,0,biff2,biff3,biff4,biff5,biff8
  34
  35 constlist=ERRORCODES
  36   0x00=#NULL!
  37   0x07=#DIV/0!
  38   0x0F=#VALUE!
  39   0x17=#REF!
  40   0x1D=#NAME?
  41   0x24=#NUM!
  42   0x2A=#N/A
  43 end
  44
  45 shortlist=EGA-COLORS,0,ega-black,ega-white,ega-red,ega-green,ega-blue,ega-yellow,ega-magenta,ega-cyan
  46
  47 constlist=COLORS-BIFF2
  48   include=EGA-COLORS
  49   default=
  50   24=sys-window-text
  51   25=sys-window-bg
  52   0x7FFF=sys-window-text
  53 end
  54
  55 constlist=COLORS-BIFF5
  56   include=EGA-COLORS
  57   default=
  58   64=sys-window-text
  59   65=sys-window-bg
  60   67=sys-button-face
  61   77=sys-window-text-chart
  62   78=sys-window-bg-chart
  63   79=auto-border-chart
  64   80=sys-tooltip-bg
  65   81=sys-tooltip-text
  66   0x7FFF=sys-window-text
  67 end
  68
  69 shortlist=BORDERSTYLES-BIFF3,0,none,thin,medium,dash,dot,thick,double,hair
  70
  71 multilist=BORDERSTYLES-BIFF8
  72   include=BORDERSTYLES-BIFF3
  73   8=medium-dash,thin-dash-dot,medium-dash-dot,thin-dash-dot-dot,medium-dash-dot-dot,slant-dash-dot
  74 end
  75
  76 multilist=FILLPATTERNS-BIFF3
  77   0=no-fill,solid-fill,50%-grey,75%-grey,25%-grey
  78   5=hor-stripe,ver-stripe,rev-diag-stripe,diag-stripe,diag-crosshatch
  79   10=thick-diag-crosshatch,thin-hor-stripe,thin-ver-stripe,thin-rev-diag-stripe,thin-diag-stripe
  80   15=thin-hor-crosshatch,thin-diag-crosshatch,12.5%-grey,6.25%-grey
  81 end
  82
  83 shortlist=TEXTORIENTATION,0,horizontal,stacked,90°-ccw,90°-cw
  84
  85 constlist=TEXTROTATION-BIFF8
  86   default=
  87   255=stacked
  88 end
  89
  90 multilist=BUILTIN-FORMATS
  91   quote-names=1
  92   0=General,0,0.00,'#,##0','#,##0.00'
  93   5='"$"#,##0_);\("$"#,##0\)','"$"#,##0_);[Red]\("$"#,##0\)','"$"#,##0.00_);\("$"#,##0.00\)','"$"#,##0.00_);[Red]\("$"#,##0.00\)',0%
  94   10=0.00%,0.00E+00,# ?/?,# ??/??,M/D/YYYY
  95   15=D-MMM-YY,D-MMM,MMM-YY,h:mm AM/PM,h:mm:ss AM/PM
  96   20=h:mm,h:mm:ss,M/D/YYYY h:mm,General,General
  97   25=General,General,M/D/YYYY,M/D/YYYY,M/D/YYYY
  98   30=M/D/YYYY,M/D/YYYY,h:mm:ss,h:mm:ss,h:mm:ss
  99   35=h:mm:ss,M/D/YYYY,'#,##0_);(#,##0)','#,##0_);[Red](#,##0)','#,##0.00_);(#,##0.00)'
 100   40='#,##0.00_);[Red](#,##0.00)'
 101   41='_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)'
 102   42='_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_)'
 103   43='_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)'
 104   44='_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)'
 105   45=mm:ss,[h]:mm:ss,mm:ss.0,##0.0E+0,@
 106   50=M/D/YYYY,M/D/YYYY,M/D/YYYY,M/D/YYYY,M/D/YYYY
 107   55=M/D/YYYY,M/D/YYYY,M/D/YYYY,M/D/YYYY,0
 108   60=0.00,'#,##0','#,##0.00','$#,##0_);($#,##0)','$#,##0_);[Red]($#,##0)'
 109   65='$#,##0.00_);($#,##0.00)','$#,##0.00_);[Red]($#,##0.00)',0%,0.00%,# ?/?
 110   70=# ??/??,M/D/YYYY,M/D/YYYY,D-MMM-YY,D-MMM
 111   75=MMM-YY,h:mm,h:mm:ss,M/D/YYYY h:mm,mm:ss
 112   80=[h]:mm:ss,mm:ss.0
 113 end
 114
 115 constlist=CONSTVALUE-TYPE
 116   0=empty
 117   1=number
 118   2=string
 119   4=boolean
 120   16=error
 121 end
 122
 123 constlist=PIVOT-NAMELEN
 124   default=
 125   0xFFFF=name-in-cache
 126 end
 127
 128 flagslist=FR-FLAGS
 129   0x0001=has-ref
 130   0x0002=alert-unsupported
 131 end
 132
 133 # DFF ------------------------------------------------------------------------
 134
 135 flagslist=DFF-CLIENTANCHOR-FLAGS
 136   0x0001=pos-locked
 137   0x0002=size-locked
 138 end
 139
 140 # formulas -------------------------------------------------------------------
 141
 142 multilist=BASETOKENS-BIFF2
 143   0x00=,tExp,tTbl,tAdd,tSub,tMul,tDiv,tPower
 144   0x08=tConcat,tLT,tLE,tEQ,tGE,tGT,tNE,tIsect
 145   0x10=tList,tRange,tUplus,tUminus,tPercent,tParen,tMissArg,tStr
 146   0x18=,tAttr,tSheet,tEndSheet,tErr,tBool,tInt,tNum
 147 end
 148
 149 constlist=BASETOKENS-BIFF5
 150   include=BASETOKENS-BIFF2
 151   exclude=0x1A,0x1B
 152 end
 153
 154 constlist=BASETOKENS-BIFF8
 155   include=BASETOKENS-BIFF5
 156   0x18=tNlr
 157 end
 158
 159 constlist=TOKENCLASSES
 160   0x20=R
 161   0x40=V
 162   0x60=A
 163 end
 164
 165 multilist=CLASSTOKENS-BIFF2
 166   0x00=tArray,tFunc,tFuncVar,tName,tRef,tArea,tMemArea,tMemErr
 167   0x08=tMemNoMem,tMemFunc,tRefErr,tAreaErr,tRefN,tAreaN,tMemAreaN,tMemNoMemN
 168   0x18=tFuncCE
 169 end
 170
 171 constlist=CLASSTOKENS-BIFF4
 172   include=CLASSTOKENS-BIFF2
 173   exclude=0x18
 174 end
 175
 176 multilist=CLASSTOKENS-BIFF5
 177   include=CLASSTOKENS-BIFF4
 178   0x19=tNameX,tRef3d,tArea3d,tRefErr3d,tAreaErr3d
 179 end
 180
 181 combilist=FUNCID
 182   0x7FFF=uint16,dec,func-id
 183   0x8000=command
 184 end
 185
 186 combilist=PARAMCOUNT-CMD
 187   0x7F=uint8,dec,count
 188   0x80=prompt
 189 end
 190
 191 combilist=REFRELFLAGS
 192   0x3FFF=uint16,dec,value
 193   0x4000=col-rel
 194   0x8000=row-rel
 195 end
 196
 197 multilist=NLRTYPES
 198   0x00=,tNlrErr,tNlrRowR,tNlrColR,,,tNlrRowV,tNlrColV
 199   0x08=,,tNlrRange,tNlrSRange,tNlrSRowR,tNlrSColR,tNlrSRowV,tNlrSColV
 200   0x10=tNlrRangeErr,,,,,,,
 201   0x18=,,,,,tNlrSxName,,
 202 end
 203
 204 combilist=NLRADDFLAGS
 205   0x3FFFFFFF=uint32,dec,count
 206   0x80000000=rel
 207 end
 208
 209 flagslist=ATTRTYPES
 210   0x01=volatile
 211   0x02=if
 212   0x04=choose
 213   0x08=skip
 214   0x10=sum
 215   0x20=assign
 216   0x40=space
 217 end
 218
 219 shortlist=ATTRSPACETYPES,0,space-before-token,cr-before-token,space-before-open,cr-before-open,space-before-close,cr-before-close,leading-space
 220
 221 # record names ---------------------------------------------------------------
 222
 223 multilist=RECORD-NAMES-BIFF2
 224   # worksheet records
 225   0x0000=DIMENSION,BLANK,INTEGER,NUMBER,LABEL,BOOLERR,FORMULA,STRING
 226   0x0008=ROW,BOF,EOF,INDEX,CALCCOUNT,CALCMODE,PRECISION,REFMODE
 227   0x0010=DELTA,ITERATION,PROTECT,PASSWORD,HEADER,FOOTER,EXTERNCOUNT,EXTERNSHEET
 228   0x0018=DEFINEDNAME,WINDOWPROTECT,VERTICALPAGEBREAKS,HORIZONTALPAGEBREAKS,NOTE,SELECTION,FORMAT,BUILTINFMTCOUNT
 229   0x0020=COLUMNDEFAULT,ARRAY,DATEMODE,EXTERNALNAME,COLWIDTH,DEFAULTROWHEIGHT,LEFTMARGIN,RIGHTMARGIN
 230   0x0028=TOPMARGIN,BOTTOMMARGIN,PRINTHEADERS,PRINTGRIDLINES,,,,FILEPASS
 231   0x0030=,FONT,FONT2,PRINTSIZE,,INFOOPTS,DATATABLE,DATATABLE2
 232   0x0038=WNDESK,,BEGINPREF,ENDPREF,CONTINUE,WINDOW1,WINDOW2,
 233   0x0040=BACKUP,PANE,CODEPAGE,XF,IXFE,EFONT,SHOWSCROLL,SHOWFORMULA
 234   0x0048=STATUSBAR,SHORTMENUS,DDEENABLED,AUTODEC,MENUKEY,PLS|ZOOM,MENUUND,MOVESEL
 235   0x0050=DCON,DCONREF,DCONNAME,,,DEFCOLWIDTH,,
 236   # worksheet records new in BIFF3, but supported in BIFF2 streams
 237   0x0200=DIMENSION,BLANK,,NUMBER,LABEL,BOOLERR,,
 238   0x0208=,,,INDEX,,,,
 239   0x027E=RK
 240   # BIFF5 style BOF
 241   0x0809=BOF
 242   # chart records
 243   0x1000=,CHUNITS,CHCHART,CHSERIES,CHSOURCELINK,,CHDATAFORMAT,CHLINEFORMAT
 244   0x1008=,CHMARKERFORMAT,CHAREAFORMAT,CHPIEFORMAT,CHATTACHEDLABEL,CHSTRING,,
 245   0x1010=,,,,CHTYPEGROUP,CHLEGEND,CHSERIESLIST,CHBAR
 246   0x1018=CHLINE,CHPIE,CHAREA,CHSCATTER,CHCHARTLINE,CHAXIS,CHTICK,CHVALUERANGE
 247   0x1020=CHLABELRANGE,CHAXISLINE,CHFORMATLINK,,CHDEFAULTTEXT,CHTEXT,CHFONT,CHOBJECTLINK
 248   0x1028=,,,,,CHARROW,,CHARROWHEAD
 249   0x1030=,,CHFRAME,CHBEGIN,CHEND,CHPLOTFRAME,CHCHARTSIZE,CHRELPOSITION
 250   0x1038=CHARROWRELPOS,,CHCHART3D,,,,,
 251 end
 252
 253 multilist=RECORD-NAMES-BIFF3
 254   include=RECORD-NAMES-BIFF2
 255   # worksheet records
 256   exclude=0x0006,0x0008,0x0009,0x000B,0x0018,0x0020,0x0021,0x0023,0x0024,0x0025,0x0031,0x0036,0x0037,0x003E,0x0043,0x0044,0x0045
 257   0x0050=,,,,,,BUILTINFMTCOUNT,
 258   0x0058=TOOLBAR,XCT,CRN,FILESHARING,WRITEACCESS,OBJ,UNCALCED,SAFERECALC
 259   0x0060=TEMPLATE,INTL,,OBJECTPROTECT,,,,
 260   0x0068=,,,,,,,
 261   0x0070=,,,,,,,
 262   0x0078=,,,,,COLINFO,,IMGDATA
 263   0x0080=GUTS,SHEETPR,GRIDSET,HCENTER,VCENTER,,WRITEPROT,ADDIN
 264   0x0088=EDG,PUB,NOTEOFF,LH,COUNTRY,HIDEOBJ,,
 265   0x0090=SORT,SUB,PALETTE,,LHRECORD,LHNGRAPH,,
 266   0x0200=,,,,,,FORMULA,STRING
 267   0x0208=ROW,BOF,,INDEX,,,,
 268   0x0218=DEFINEDNAME
 269   0x0221=ARRAY
 270   0x0223=EXTERNALNAME
 271   0x0225=DEFAULTROWHEIGHT
 272   0x0231=FONT
 273   0x0236=DATATABLE
 274   0x023E=WINDOW2
 275   0x0243=XF
 276   0x0293=STYLE
 277   # chart records
 278   0x103C=CHPICFORMAT
 279 end
 280
 281 multilist=RECORD-NAMES-BIFF4
 282   include=RECORD-NAMES-BIFF3
 283   # worksheet/workbook records
 284   exclude=0x0206,0x0209,0x001E,0x0243
 285   0x0085=SHEET
 286   0x0088=,,,,,,SHEETSOFFSET,SHEETHEADER
 287   0x0090=,,,,,SOUND,SYNC
 288   0x0098=LPR,STANDARDWIDTH,FNGROUPNAME,,FNGROUPCOUNT,,,
 289   0x00A0=SCL,PAGESETUP,FNPROTO,PROJEXTSHEET,,,,
 290   0x00A8=DRAGDROP,COORDLIST,,GCW,,,,
 291   0x0406=FORMULA
 292   0x0409=BOF
 293   0x041E=FORMAT
 294   0x0443=XF
 295   # chart records
 296   0x1038=,,,CHMULTILINK,,CHDROPBAR,CHRADARLINE,CHSURFACE
 297 end
 298
 299 multilist=RECORD-NAMES-BIFF5
 300   include=RECORD-NAMES-BIFF4
 301   # worksheet/workbook records
 302   exclude=0x0409,0x0218,0x0223,0x0231,0x0443
 303   0x0006=FORMULA
 304   0x0018=DEFINEDNAME
 305   0x0023=EXTERNALNAME
 306   0x0031=FONT
 307   0x0098=,,,FILTERMODE,,AUTOFILTERINFO,AUTOFILTER,
 308   0x00A8=,,,,,,SCENARIOS,SCENARIO
 309   0x00B0=PTDEFINITION,PTFIELD,PTFITEM,,PTROWCOLFIELDS,PTROWCOLITEMS,PTPAGEFIELDS,
 310   0x00B8=DOCROUTE,RECIPNAME,,,SHAREDFMLA,MULTRK,MULTBLANK,
 311   0x00C0=,MMS,ADDMENU,DELMENU,,PTDATAFIELD,PCDEFINITION,PCDFIELD
 312   0x00C8=PCITEM_INDEXLIST,PCITEM_DOUBLE,PCITEM_BOOL,PCITEM_ERROR,PCITEM_INTEGER,PCITEM_STRING,PCITEM_DATE,PCITEM_MISSING
 313   0x00D0=SXTBL,SXTBRGITEM,SXTBPG,OBPROJ,,PIVOTCACHE,RSTRING,DBCELL
 314   0x00D8=PCDFRANGEPR,PCDFDISCRETEPR,BOOKBOOL,REVERT,SXEXT|PARAMQRY,SCENPROTECT,OLESIZE,UDDESC
 315   0x00E0=XF,INTERFACEHDR,INTERFACEEND,PCDSOURCE,,,,
 316   0x0206=FORMULA
 317   # chart records
 318   exclude=0x1004,0x102D,0x102F,0x1036,0x1037,0x1038,0x103B
 319   0x1040=CHRADARAREA,CHAXESSET,,CHLEGENDENTRY,CHPROPERTIES,CHSERGROUP,CHUSEDAXESSETS,
 320   0x1048=CHPIVOTREF,,CHSERPARENT,CHSERTRENDLINE,,,CHFORMAT,CHPOS
 321   0x1050=CHFORMATRUNS,CHSOURCELINK,,,,,,
 322   0x1058=,,,CHSERERRORBAR,,CHSERIESFORMAT,,
 323 end
 324
 325 multilist=RECORD-NAMES-BIFF8
 326   include=RECORD-NAMES-BIFF5
 327   # worksheet/workbook records
 328   0x00E0=,,,,,CELLMERGING,,
 329   0x00E8=,IMGDATA,,MSODRAWINGGROUP,MSODRAWING,MSODRAWINGSELECTION,,PHONETICPR
 330   0x00F0=,PTDEFINITION2,,,,,,
 331   0x00F8=,PCDFORMULAFIELD,,,SST,LABELSST,,EXTSST
 332   0x0100=PTFIELD2,,,PCDFIELDINDEX,,,,
 333   0x0120=,,PCDEFINITION2,,,,,
 334   0x0130=,,,,,,,CHTRINSERT
 335   0x0138=CHTRINFO,,,CHTRCELLCONTENT,,TABID,,
 336   0x0140=CHTRMOVERANGE,,,,,,,
 337   0x0148=,,,,,CHTRINSERTTAB,,
 338   0x0158=,,,,,,,LABELRANGES
 339   0x0160=USESELFS,DSF,XL5MODIFY,,,,,
 340   0x0190=,,,,,,CHTRHEADER,
 341   0x01A8=,USERBVIEW,USERSVIEWBEGIN,USERSVIEWEND,,QSI,EXTERNALBOOK,PROT4REV
 342   0x01B0=CFHEADER,CFRULE,DATAVALIDATIONS,,,DCONBINAME,TXO,REFRESHALL
 343   0x01B8=HYPERLINK,NLRDELNAME,CODENAME,PCDFSQLTYPE,PROT4REVPASS,,DATAVALIDATION,
 344   0x0800=SCREENTIP,,,WEBQRYSETTINGS,WEBQRYTABLES,,,
 345   0x0850=CHFRINFO,CHFRWRAPPER,CHFRBLOCKBEGIN,CHFRBLOCKEND,,,,CHFRUNITPROPS
 346   0x0858=CHPIVOTREF,,,,,,,
 347   0x0860=,,SHEETLAYOUT,,,,,SHEETPROTECTION
 348   0x0868=,,,CHFRLABELPROPS,,,,
 349   # chart records
 350   0x1058=,,,,,,,CH3DDATAFORMAT
 351   0x1060=CHFONTBASE,CHPIEEXT,CHLABELRANGE2,CHDATATABLE,CHPLOTGROWTH,CHSERINDEX,CHESCHERFORMAT,CHPIEEXTSETT
 352 end
 353
 354 # simple records -------------------------------------------------------------
 355
 356 constlist=SIMPLE-RECORDS-BIFF2
 357   0x000C=uint16,dec,max-iterations
 358   0x000D=int16,dec,calc-mode,CALCMODE
 359   0x000E=uint16,bool,calc-precise
 360   0x000F=uint16,dec,ref-mode,REFMODE
 361   0x0010=double,dec,epsilon
 362   0x0011=uint16,bool,iterate-recursive
 363   0x0012=uint16,bool,contents-protected
 364   0x0013=uint16,hex,password-hash
 365   0x0016=uint16,dec,externsheets
 366   0x0019=uint16,bool,window-protected
 367   0x001F=uint16,dec,builtin-fmt-count
 368   0x0022=uint16,dec,null-date,DATEMODE
 369   0x0025=uint16,hex,rowheight-flags,DEFROWHEIGHT-FLAGS
 370   0x0026=double,dec,left-margin,CONV-INCH-TO-CM
 371   0x0027=double,dec,right-margin,CONV-INCH-TO-CM
 372   0x0028=double,dec,top-margin,CONV-INCH-TO-CM
 373   0x0029=double,dec,bottom-margin,CONV-INCH-TO-CM
 374   0x002A=uint16,bool,print-sheet-headers
 375   0x002B=uint16,bool,print-gridlines
 376   0x0040=uint16,bool,backup-on-save
 377   0x0044=uint16,dec,xf-idx
 378   0x0045=uint16,dec,font-color-idx,COLORS
 379   0x0055=uint16,dec,base-col-width
 380   0x100B=uint16,dec,extrusion,CONV-PERCENT
 381   0x100C=uint16,hex,flags,CHATTACHEDLABEL-FLAGS
 382   0x1018=uint16,hex,flags,CHLINE-FLAGS
 383   0x101A=uint16,hex,flags,CHAREA-FLAGS
 384   0x101C=uint16,dec,line-type,CHCHARTLINE-TYPE
 385   0x1021=uint16,dec,axisline-id,CHAXISLINE-ID
 386   0x1024=uint16,dec,text-idx
 387   0x1026=uint16,dec,font-idx,FONTNAMES
 388   0x1045=uint16,dec,group-idx
 389   0x1046=uint16,dec,used-axessets
 390   0x104A=uint16,dec,series-idx
 391   0x104E=uint16,dec,fmt-idx,FORMATS
 392 end
 393
 394 constlist=SIMPLE-RECORDS-BIFF3
 395   include=SIMPLE-RECORDS-BIFF2
 396   0x0056=uint16,dec,builtin-fmt-count
 397   0x005E=uint16,unused
 398   0x005F=uint16,bool,recalc-on-save
 399   0x0063=uint16,bool,objects-protected
 400   0x0081=uint16,hex,flags,SHEETPR-FLAGS
 401   0x0082=uint16,bool,print-gridlines-changed
 402   0x0083=uint16,bool,horizontal-centered
 403   0x0084=uint16,bool,vertical-centered
 404   0x008D=uint16,dec,object-mode,HIDEOBJ
 405 end
 406
 407 constlist=SIMPLE-RECORDS-BIFF4
 408   include=SIMPLE-RECORDS-BIFF3
 409   0x008E=uint32,hex,stream-pos,CONV-DEC
 410   0x0099=uint16,dec,default-col-width,CONV-COLWIDTH
 411   0x009C=uint16,dec,func-group-count
 412   0x103D=uint16,dec,bar-dist
 413   0x103E=uint16,hex,flags,CHRADAR-FLAGS
 414   0x103F=uint16,hex,flags,CHSURFACE-FLAGS
 415 end
 416
 417 constlist=SIMPLE-RECORDS-BIFF5
 418   include=SIMPLE-RECORDS-BIFF4
 419   0x00C9=double,dec,value
 420   0x00CA=uint16,bool,value
 421   0x00CB=uint16,hex,error-code,ERRORCODES
 422   0x00CC=int16,dec,value
 423   0x00D5=uint16,hex,cache-id
 424   0x00D8=uint16,hex,flags,PCDFRANGEPR-FLAGS
 425   0x00DA=uint16,bool,strip-cached-values
 426   0x00DD=uint16,bool,scenarios-protected
 427   0x00E3=uint16,dec,source-type,PCDSOURCE-TYPE
 428   0x1040=uint16,hex,flags,CHRADAR-FLAGS
 429   0x105D=uint16,hex,flags,CHSERIESFORMAT-FLAGS
 430 end
 431
 432 constlist=SIMPLE-RECORDS-BIFF8
 433   include=SIMPLE-RECORDS-BIFF5
 434   0x00E1=uint16,dec,codepage,CODEPAGES
 435   0x0160=uint16,bool,use-nat-lang-refs
 436   0x0161=uint16,bool,double-stream
 437   0x01AF=uint16,bool,revlog-protected
 438   0x01B7=uint16,bool,refresh-all
 439   0x01BB=uint16,dec,sql-data-type,PCDFSQLTYPE-DATATYPE
 440   0x01BC=uint16,hex,password-hash
 441   0x1065=uint16,dec,series-idx
 442 end
 443
 444 # ARRAY ----------------------------------------------------------------------
 445
 446 flagslist=ARRAY-FLAGS-BIFF2
 447   0x0001=recalc-always
 448 end
 449
 450 flagslist=ARRAY-FLAGS-BIFF3
 451   include=ARRAY-FLAGS-BIFF2
 452   0x0002=recalc-onload
 453 end
 454
 455 # BOF ------------------------------------------------------------------------
 456
 457 constlist=BOF-BIFFTYPE
 458   0x0000=from-id
 459   0x0007=biff2
 460   0x0200=biff2
 461   0x0300=biff3
 462   0x0400=biff4
 463   0x0500=biff5
 464   0x0600=biff8
 465 end
 466
 467 constlist=BOF-SHEETTYPE
 468   0x0005=globals
 469   0x0006=vb-module
 470   0x0010=sheet
 471   0x0020=chart
 472   0x0040=macro
 473   0x0100=workspace
 474 end
 475
 476 shortlist=BOF-EXCELVERSION,0,excel-97,excel-2000,excel-2002,excel-2003,excel-2007
 477 shortlist=BOF-LOWESTVERSION-BIFF,6,biff8
 478
 479 combilist=BOF-HISTORY-FLAGS
 480   ignore=0x000000C0
 481   0x00000001=windows
 482   0x00000002=risc
 483   0x00000004=beta
 484   0x00000008=win-any
 485   0x00000010=mac-any
 486   0x00000020=beta-any
 487   0x00000100=risc-any
 488   0x00000200=out-of-mem
 489   0x00000400=out-of-mem-renderer
 490   0x00002000=font-limit-255
 491   0x0003C000=uint8,dec,max-version-saved,BOF-EXCELVERSION
 492 end
 493
 494 combilist=BOF-LOWESTVERSION-FLAGS
 495   0x000000FF=uint8,dec,biff-version,BOF-LOWESTVERSION-BIFF
 496   0x00000F00=uint8,dec,version-saved,BOF-EXCELVERSION
 497 end
 498
 499 # CALCMODE -------------------------------------------------------------------
 500
 501 shortlist=CALCMODE,-1,automatic-no-table,manual,automatic
 502
 503 # CFRULE ---------------------------------------------------------------------
 504
 505 shortlist=CFRULE-TYPE,1,value,formula
 506 shortlist=CFRULE-OPERATOR,0,none,between,not-between,equal,not-equal,greater-than,less-than,greater-equal,less-equal
 507
 508 flagslist=CFRULE-FLAGS
 509   ignore=0x00380080
 510   0x00000001=!hor-align-used
 511   0x00000002=!vert-align-used
 512   0x00000004=!text-wrap-used
 513   0x00000008=!rotation-used
 514   0x00000010=!justify-lastline-used
 515   0x00000020=!indent-used
 516   0x00000040=!shrinktofit-used
 517   0x00000100=!cell-locked-used
 518   0x00000200=!cell-hidden-used
 519   0x00000400=!left-border-used
 520   0x00000800=!right-border-used
 521   0x00001000=!top-border-used
 522   0x00002000=!bottom-border-used
 523   0x00004000=!tl-to-br-used
 524   0x00008000=!bl-to-tr-used
 525   0x00010000=!fill-pattern-used
 526   0x00020000=!fg-color-idx-used
 527   0x00040000=!bg-color-idx-used
 528   0x04000000=font-block
 529   0x08000000=alignment-block
 530   0x10000000=border-block
 531   0x20000000=pattern-block
 532   0x40000000=protection-block
 533   0x80000000=!text-dir-used
 534 end
 535
 536 combilist=CFRULE-ALIGNMENT
 537   0x07=uint8,dec,hor-align,XF-HORALIGN
 538   0x08=text-wrap
 539   0x70=uint8,dec,ver-align,XF-VERALIGN
 540   0x80=justify-lastline
 541 end
 542
 543 combilist=CFRULE-INDENT
 544   0x000F=uint8,dec,indent
 545   0x0010=shrink-to-fit
 546   0x00C0=uint8,dec,text-dir,XF-TEXTDIRECTION
 547 end
 548
 549 flagslist=CFRULE-FONTFLAGS
 550   0x00000002=italic
 551   0x00000008=outline
 552   0x00000010=shadow
 553   0x00000020=condense
 554   0x00000040=extend
 555   0x00000080=strikeout
 556 end
 557
 558 flagslist=CFRULE-FONTUSEDFLAGS
 559   0x00000002=!italic-used
 560   0x00000008=!outline-used
 561   0x00000010=!shadow-used
 562   0x00000020=!condense-used
 563   0x00000040=!extend-used
 564   0x00000080=!strikeout-used
 565 end
 566
 567 constlist=CFRULE-FONTUSED
 568   0=used
 569   1=not-used
 570 end
 571
 572 combilist=CFRULE-BORDERCOLOR2
 573   0x0000007F=uint8,dec,top-color,COLORS
 574   0x00003F80=uint8,dec,bottom-color,COLORS
 575   0x001FC000=uint8,dec,diag-color,COLORS
 576   0x01E00000=uint8,dec,diag-style,BORDERSTYLES
 577 end
 578
 579 combilist=CFRULE-FILLBLOCK
 580   0x0000FC00=uint8,dec,fill-pattern,FILLPATTERNS
 581   0x007F0000=uint8,dec,fg-color-idx,COLORS
 582   0x3F800000=uint8,dec,bg-color-idx,COLORS
 583 end
 584
 585 flagslist=CFRULE-PROTECTION-FLAGS
 586   0x0001=locked
 587   0x0002=formula-hidden
 588 end
 589
 590 # CH3DDATAFORMAT -------------------------------------------------------------
 591
 592 shortlist=CH3DDATAFORMAT-BASE,0,rectangular,circular
 593 shortlist=CH3DDATAFORMAT-TOP,0,straight,sharp,trunc
 594
 595 # CHAREA ---------------------------------------------------------------------
 596
 597 flagslist=CHAREA-FLAGS
 598   0x0001=stacked
 599   0x0002=percent
 600   0x0004=shadow
 601 end
 602
 603 # CHAREAFORMAT ---------------------------------------------------------------
 604
 605 flagslist=CHAREAFORMAT-FLAGS
 606   0x0001=auto
 607   0x0002=swap-negative
 608 end
 609
 610 # CHATTACHEDLABEL ------------------------------------------------------------
 611
 612 flagslist=CHATTACHEDLABEL-FLAGS
 613   0x0001=show-value
 614   0x0002=show-percent
 615   0x0004=show-categ-percent
 616   0x0008=smoothed
 617   0x0010=show-categ
 618   0x0020=show-bubble
 619 end
 620
 621 # CHAXESSET ------------------------------------------------------------------
 622
 623 shortlist=CHAXESSET-ID,0,primary,secondary
 624
 625 # CHAXIS ---------------------------------------------------------------------
 626
 627 shortlist=CHAXIS-TYPE,0,x-axis,y-axis,z-axis
 628
 629 # CHAXISLINE -----------------------------------------------------------------
 630
 631 shortlist=CHAXISLINE-ID,0,axisline,major-grid,minor-grid,wall
 632
 633 # CHBAR ----------------------------------------------------------------------
 634
 635 flagslist=CHBAR-FLAGS
 636   0x0001=horizontal
 637   0x0002=stacked
 638   0x0004=percent
 639   0x0008=shadow
 640 end
 641
 642 # CHCHART3D ------------------------------------------------------------------
 643
 644 flagslist=CHCHART3D-FLAGS
 645   ignore=0x0010
 646   0x0001=real3d
 647   0x0002=clustered
 648   0x0004=auto-height
 649   0x0020=2d-plotarea
 650 end
 651
 652 # CHTYPEGROUP ----------------------------------------------------------------
 653
 654 flagslist=CHTYPEGROUP-FLAGS
 655   0x0001=varied-colors
 656 end
 657
 658 # CHCHARTLINE ----------------------------------------------------------------
 659
 660 shortlist=CHCHARTLINE-TYPE,0,drop-line,hi-lo-line,series-connector
 661
 662 # CHDATAFORMAT ---------------------------------------------------------------
 663
 664 constlist=CHDATAFORMAT-POINTIDX
 665   default=
 666   -1=all-points
 667 end
 668
 669 constlist=CHDATAFORMAT-FORMATIDX
 670   default=
 671   -3=axesset-global
 672 end
 673
 674 flagslist=CHDATAFORMAT-FLAGS
 675   0x0001=excel4-colors
 676 end
 677
 678 # CHFRAME --------------------------------------------------------------------
 679
 680 shortlist=CHFRAME-FORMAT,0,standard,,,,shadow
 681
 682 flagslist=CHFRAME-FLAGS
 683   0x0001=auto-size
 684   0x0002=auto-pos
 685 end
 686
 687 # CHFRAMEPOS -----------------------------------------------------------------
 688
 689 shortlist=CHFRAMEPOS-OBJTYPE,2,any,,,legend
 690 shortlist=CHFRAMEPOS-SIZEMODE,1,manual,auto
 691
 692 # CHFRBLOCKBEGIN, CHFRBLOCKEND -----------------------------------------------
 693
 694 shortlist=CHFRBLOCK-TYPE,0,axes-set,,text,,axis,type-group,data-table,frame,,legend,legend-exception,,series,chart,data-format,drop-bar
 695
 696 # CHFRINFO -------------------------------------------------------------------
 697
 698 shortlist=CHFRINFO-APPVERSION,9,excel-2000,excel-xp-2003,excel-2007
 699
 700 # CHFRLABELPROPS -------------------------------------------------------------
 701
 702 flagslist=CHFRLABELPROPS-FLAGS
 703   0x0001=show-series
 704   0x0002=show-categ
 705   0x0004=show-value
 706   0x0008=show-percent
 707   0x0010=show-bubble
 708 end
 709
 710 # CHFRUNITPROPS --------------------------------------------------------------
 711
 712 shortlist=CHFRUNITPROPS-PRESET,-1,manual,none,hundred,thousand,10000,100000,million,10-million,100-million,billion,trillion
 713
 714 flagslist=CHFRUNITPROPS-FLAGS
 715   0x0002=show-unit
 716 end
 717
 718 # CHLABELRANGE ---------------------------------------------------------------
 719
 720 flagslist=CHLABELRANGE-FLAGS
 721   0x0001=cross-between-categ
 722   0x0002=maximum-axis-cross
 723   0x0004=reverse-order
 724 end
 725
 726 # CHLABELRANGE2 --------------------------------------------------------------
 727
 728 flagslist=CHLABELRANGE2-FLAGS
 729   0x0001=auto-minimum
 730   0x0002=auto-maximum
 731   0x0004=auto-major
 732   0x0008=auto-minor
 733   0x0010=date-axis
 734   0x0020=auto-base
 735   0x0040=auto-axis-cross
 736   0x0080=auto-date
 737 end
 738
 739 # CHLEGEND -------------------------------------------------------------------
 740
 741 shortlist=CHLEGEND-DOCKPOS,0,bottom,top-left,top,right,left,,,manual
 742 shortlist=CHLEGEND-SPACING,0,close,medium,open
 743
 744 flagslist=CHLEGEND-FLAGS
 745   0x0001=docked
 746   0x0002=auto-series
 747   0x0004=auto-pos-x
 748   0x0008=auto-pos-y
 749   0x0010=stacked
 750   0x0020=data-table
 751 end
 752
 753 # CHLINE ---------------------------------------------------------------------
 754
 755 flagslist=CHLINE-FLAGS
 756   0x0001=stacked
 757   0x0002=percent
 758   0x0004=shadow
 759 end
 760
 761 # CHLINEFORMAT ---------------------------------------------------------------
 762
 763 shortlist=CHLINEFORMAT-LINETYPE,0,solid,dash,dot,dash-dot,dash-dot-dot,none,25%-pattern,50%-pattern,75%-pattern
 764 shortlist=CHLINEFORMAT-LINEWEIGHT,-1,hair,thin,medium,thick
 765
 766 flagslist=CHLINEFORMAT-FLAGS
 767   0x0001=auto
 768   0x0004=axis-enabled
 769 end
 770
 771 # CHMARKERFORMAT -------------------------------------------------------------
 772
 773 shortlist=CHMARKERFORMAT-TYPE,0,none,square,diamond,triangle,cross,star,dow-jones,std-dev,circle,plus
 774
 775 flagslist=CHMARKERFORMAT-FLAGS
 776   0x0001=auto
 777   0x0010=no-fill
 778   0x0020=no-border
 779 end
 780
 781 # CHOBJECTLINK ---------------------------------------------------------------
 782
 783 shortlist=CHOBJECTLINK-TARGET,0,none,title,y-axis,x-axis,datapoint,legend,none,z-axis,,,,,axis-unit
 784
 785 constlist=CHOBJECTLINK-POINT
 786   default=
 787   -2=unknown
 788   -1=all-points
 789 end
 790
 791 # CHPICFORMAT ----------------------------------------------------------------
 792
 793 shortlist=CHPICFORMAT-BITMAP-MODE,1,stretched,stacked,stacked-scaled
 794
 795 constlist=CHPICFORMAT-IMAGE-FORMAT
 796   2=wmf
 797   9=bmp
 798   19=?emf
 799 end
 800
 801 shortlist=CHPICFORMAT-ENV,1,windows,apple
 802
 803 combilist=CHPICFORMAT-FLAGS
 804   0x00FF=uint16,dec,environment,CHPICFORMAT-ENV
 805   0x0100=format-only
 806   0x0200=top-bottom
 807   0x0400=front-back
 808   0x0800=left-right
 809 end
 810
 811 # CHPIE ----------------------------------------------------------------------
 812
 813 flagslist=CHPIE-FLAGS
 814   0x0001=shadow
 815   0x0002=connectors
 816 end
 817
 818 # CHRADAR, CHRADARAREA -------------------------------------------------------
 819
 820 flagslist=CHRADAR-FLAGS
 821   0x0001=axis-labels
 822   0x0002=shadow
 823 end
 824
 825 # CHPROPERTIES ---------------------------------------------------------------
 826
 827 shortlist=CHPROPERTIES-EMPTYCELLS,0,do-not-plot,as-zero,interpolated
 828
 829 flagslist=CHPROPERTIES-FLAGS
 830   0x0001=manual-format
 831   0x0002=plot-visible-only
 832   0x0004=fixed-size
 833   0x0008=manual-plotarea
 834 end
 835
 836 # CHSCATTER ------------------------------------------------------------------
 837
 838 shortlist=CHSCATTER-SIZETYPE,0,none,area,width
 839
 840 flagslist=CHSCATTER-FLAGS
 841   0x0001=bubbles
 842   0x0002=show-negative
 843   0x0004=shadow
 844 end
 845
 846 # CHSERERRORBAR --------------------------------------------------------------
 847
 848 shortlist=CHSERERRORBAR-TYPE,1,x-plus,x-minus,y-plus,y-minus
 849 shortlist=CHSERERRORBAR-SOURCE,1,percent,fixed,std-deviation,custom,std-error
 850
 851 # CHSERIES -------------------------------------------------------------------
 852
 853 shortlist=CHSERIES-TYPE,0,date,numeric,sequence,text
 854
 855 # CHSERIESFORMAT -------------------------------------------------------------
 856
 857 flagslist=CHSERIESFORMAT-FLAGS
 858   0x0001=spline
 859   0x0002=bubbles-3d
 860   0x0004=shadow
 861 end
 862
 863 # CHSERTRENDLINE -------------------------------------------------------------
 864
 865 shortlist=CHSERTRENDLINE-TYPE,0,poynomial,exponential,logarithmic,power,moving-average
 866
 867 # CHSOURCELINK ---------------------------------------------------------------
 868
 869 shortlist=CHSOURCELINK-TARGET,0,title,values,category,bubbles
 870 shortlist=CHSOURCELINK-TYPE,0,default,constant,sheet-link
 871
 872 flagslist=CHSOURCELINK-FLAGS
 873   0x0001=custom-numfmt
 874 end
 875
 876 # CHSTRING -------------------------------------------------------------------
 877
 878 shortlist=CHSTRING-TYPE,0,text,category-default,value-default,x-prefix,x-postfix,y-prefix,y-postfix,comment
 879
 880 # CHSURFACE ------------------------------------------------------------------
 881
 882 flagslist=CHSURFACE-FLAGS
 883   0x0001=filled
 884   0x0002=shadow
 885 end
 886
 887 # CHTEXT ---------------------------------------------------------------------
 888
 889 shortlist=CHTEXT-HORALIGN,1,left,center,right,block,distribute
 890 shortlist=CHTEXT-VERALIGN,1,top,center,bottom,block,distribute
 891 shortlist=CHTEXT-FILLMODE,1,transparent,opaque
 892
 893 combilist=CHTEXT-FLAGS-BIFF2
 894   0x0001=auto-color
 895   0x0002=show-symbol
 896   0x0004=show-value
 897   0x0008=vertical
 898   0x0010=auto-text
 899   0x0020=default-format
 900   0x0040=deleted
 901   0x0080=auto-fill
 902 end
 903
 904 combilist=CHTEXT-FLAGS-BIFF3
 905   include=CHTEXT-FLAGS-BIFF2
 906   0x0700=uint8,dec,orientation,TEXTORIENTATION
 907 end
 908
 909 combilist=CHTEXT-FLAGS-BIFF5
 910   include=CHTEXT-FLAGS-BIFF3
 911   0x0800=show-categ-percent
 912   0x1000=show-percent
 913 end
 914
 915 combilist=CHTEXT-FLAGS-BIFF8
 916   include=CHTEXT-FLAGS-BIFF5
 917   0x2000=show-bubble-size
 918   0x4000=show-categ
 919 end
 920
 921 multilist=CHTEXT-PLACEMENT
 922   default=
 923   0=context,outside,inside,center,axis,above,below,left,right,auto,manual
 924 end
 925
 926 # CHTICK ---------------------------------------------------------------------
 927
 928 shortlist=CHTICK-TYPE,0,none,inside,outside,both
 929 # TODO: really different label positions in BIFF2-BIFF4?
 930 shortlist=CHTICK-LABELPOS-BIFF2,0,none,near,below,above
 931 shortlist=CHTICK-LABELPOS-BIFF5,0,none,below,above,near
 932
 933 flagslist=CHTICK-FLAGS-BIFF2
 934   0x0001=auto-color
 935   0x0002=auto-fill
 936 end
 937
 938 combilist=CHTICK-FLAGS-BIFF3
 939   include=CHTICK-FLAGS-BIFF2
 940   0x001C=uint8,dec,orientation,TEXTORIENTATION
 941   0x0020=auto-rotation
 942 end
 943
 944 # CHVALUERANGE ---------------------------------------------------------------
 945
 946 flagslist=CHVALUERANGE-FLAGS
 947   ignore=0x0100
 948   0x0001=auto-minimum
 949   0x0002=auto-maximum
 950   0x0004=auto-major
 951   0x0008=auto-minor
 952   0x0010=auto-axis-cross
 953   0x0020=logarithmic
 954   0x0040=reverse-order
 955   0x0080=maximum-axis-cross
 956 end
 957
 958 # COLINFO --------------------------------------------------------------------
 959
 960 combilist=COLINFO-FLAGS
 961   0x0001=hidden
 962   0x0002=custom-width
 963   0x0004=best-fit
 964   0x0008=show-phonetic
 965   0x0700=uint8,dec,outline-level
 966   0x1000=outline-collapsed
 967 end
 968
 969 # DATATABLE ------------------------------------------------------------------
 970
 971 flagslist=DATATABLE-FLAGS-BIFF3
 972   0x0001=recalc-always
 973   0x0002=recalc-on-load
 974   0x0004=row-table
 975   0x0008=table-2d
 976 end
 977
 978 flagslist=DATATABLE-FLAGS-BIFF8
 979   include=DATATABLE-FLAGS-BIFF3
 980   0x0010=ref1-deleted
 981   0x0020=ref2-deleted
 982 end
 983
 984 # DATAVALIDATION -------------------------------------------------------------
 985
 986 combilist=DATAVALIDATION-FLAGS
 987   0x0000000F=uint8,dec,type,DATAVALIDATION-TYPE
 988   0x00000070=uint8,dec,error-style,DATAVALIDATION-ERRORSTYLE
 989   0x00000080=string-list
 990   0x00000100=ignore-empty
 991   0x00000200=no-dropdown
 992   0x00040000=show-input-box
 993   0x00080000=show-error-box
 994   0x00F00000=uint8,dec,operator,DATAVALIDATION-OPERATOR
 995 end
 996
 997 shortlist=DATAVALIDATION-TYPE,0,any,whole,decimal,list,date,time,text-length,custom
 998 shortlist=DATAVALIDATION-OPERATOR,0,between,not-between,equal,not-equal,greater-than,less-than,greater-equal,less-equal
 999 shortlist=DATAVALIDATION-ERRORSTYLE,0,error,warning,info
1000
1001 # DATAVALIDATIONS ------------------------------------------------------------
1002
1003 flagslist=DATAVALIDATIONS-FLAGS
1004   0x0001=input-box-visible
1005   0x0002=input-box-at-cell
1006   0x0004=cached
1007 end
1008
1009 # DATEMODE -------------------------------------------------------------------
1010
1011 shortlist=DATEMODE,0,1899-12-31,1904-01-01
1012
1013 # DEFINEDNAME ----------------------------------------------------------------
1014
1015 flagslist=DEFINEDNAME-FLAGS-BIFF2
1016   0x02=macro
1017   0x04=complex
1018 end
1019
1020 shortlist=DEFINEDNAME-MACROTYPE-BIFF2,0,none,function,procedure
1021
1022 flagslist=DEFINEDNAME-FLAGS-BIFF3
1023   0x0001=hidden
1024   0x0002=function
1025   0x0004=command
1026   0x0008=macro
1027   0x0010=complex
1028   0x0020=builtin
1029 end
1030
1031 shortlist=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
1032
1033 combilist=DEFINEDNAME-FLAGS-BIFF4
1034   include=DEFINEDNAME-FLAGS-BIFF3
1035   0x0FC0=uint16,dec,func-group,DEFINEDNAME-FUNCGROUP
1036 end
1037
1038 combilist=DEFINEDNAME-FLAGS-BIFF5
1039   include=DEFINEDNAME-FLAGS-BIFF4
1040   0x0004=vba
1041   0x1000=binary
1042 end
1043
1044 shortlist=DEFINEDNAME-FUNCGROUP,0,none,financial,date-time,math-trig,statistical,lookup-ref,database,text,logical,information,commands,customizing,macro-control,dde-external,user-definded
1045
1046 constlist=DEFINEDNAME-SHEETIDX
1047   default=
1048   0=global
1049 end
1050
1051 # DEFROWHEIGHT ---------------------------------------------------------------
1052
1053 combilist=DEFROWHEIGHT-FLAGS-BIFF2
1054   0x7FFF=uint16,dec,row-height,CONV-TWIP-TO-PT
1055   0x8000=unchanged
1056 end
1057
1058 flagslist=DEFROWHEIGHT-FLAGS-BIFF3
1059   0x0001=custom-height
1060   0x0002=hidden
1061   0x0004=thick-top
1062   0x0008=thick-bottom
1063 end
1064
1065 # EXTERNALBOOK ---------------------------------------------------------------
1066
1067 constlist=EXTERNALBOOK-KEY
1068   0x0401=self-reference
1069   0x3A01=analysis-addin
1070 end
1071
1072 # EXTERNALNAME ---------------------------------------------------------------
1073
1074 flagslist=EXTERNALNAME-FLAGS-BIFF3
1075   0x0001=builtin
1076   0x0002=automatic
1077   0x0004=pic-link
1078   0x0008=dde-stddocumentname
1079 end
1080
1081 combilist=EXTERNALNAME-FLAGS-BIFF5
1082   include=EXTERNALNAME-FLAGS-BIFF3
1083   0x0010=ole-link
1084   0x7FE0=uint16,dec,clipboard-format
1085   0x8000=iconified
1086 end
1087
1088 # EXTERNSHEET ----------------------------------------------------------------
1089
1090 constlist=EXTERNSHEET-IDX-BIFF8
1091   default=
1092   -1=deleted
1093   -2=special
1094 end
1095
1096 # FILEPASS -------------------------------------------------------------------
1097
1098 shortlist=FILEPASS-TYPE,0,xor,rc4
1099 shortlist=FILEPASS-MAJOR,1,rc4,crypto-api-2003,crypto-api-2007
1100
1101 # FONT -----------------------------------------------------------------------
1102
1103 flagslist=FONT-FLAGS
1104   0x0001=bold
1105   0x0002=italic
1106   0x0004=underline
1107   0x0008=strikeout
1108   0x0010=outline
1109   0x0020=shadow
1110   0x0040=condense
1111   0x0080=extend
1112 end
1113
1114 multilist=FONT-UNDERLINE
1115   0x00=none,single,double
1116   0x21=single-acc,double-acc
1117 end
1118
1119 shortlist=FONT-ESCAPEMENT,0,none,superscript,subscript
1120
1121 # FORMULA --------------------------------------------------------------------
1122
1123 flagslist=FORMULA-FLAGS-BIFF2
1124   0x0001=recalc-always
1125 end
1126
1127 flagslist=FORMULA-FLAGS-BIFF3
1128   include=FORMULA-FLAGS-BIFF2
1129   0x0002=recalc-onload
1130 end
1131
1132 flagslist=FORMULA-FLAGS-BIFF5
1133   include=FORMULA-FLAGS-BIFF3
1134   0x0008=shared-fmla
1135 end
1136
1137 shortlist=FORMULA-RESULTTYPE,0,string,boolean,error,empty
1138
1139 # HIDEOBJ --------------------------------------------------------------------
1140
1141 shortlist=HIDEOBJ,0,show,placeholder,hide
1142
1143 # IMGDATA --------------------------------------------------------------------
1144
1145 constlist=IMGDATA-FORMAT
1146   -1=none
1147   2=wmf-pict
1148   9=dib
1149   14=native
1150 end
1151
1152 shortlist=IMGDATA-ENV,1,windows,apple
1153
1154 # NOTE -----------------------------------------------------------------------
1155
1156 flagslist=NOTE-FLAGS-BIFF8
1157   0x0002=visible
1158 end
1159
1160 # OBJ ------------------------------------------------------------------------
1161
1162 # object types ---
1163
1164 multilist=OBJ-TYPE-BIFF3
1165   0=group,line,rectangle,oval,arc,chart,textbox,button,picture
1166 end
1167
1168 multilist=OBJ-TYPE-BIFF4
1169   include=OBJ-TYPE-BIFF3
1170   9=polygon
1171 end
1172
1173 multilist=OBJ-TYPE-BIFF5
1174   include=OBJ-TYPE-BIFF4
1175   10=,checkbox,optionbutton,edit,label,dialog,spin,scrollbar,listbox,groupbox
1176   20=dropdown
1177 end
1178
1179 multilist=OBJ-TYPE-BIFF8
1180   include=OBJ-TYPE-BIFF5
1181   25=note
1182   30=drawing
1183 end
1184
1185 # flags and constants ---
1186
1187 flagslist=OBJ-FLAGS-BIFF3
1188   0x0001=selected
1189   0x0002=auto-size
1190   0x0004=auto-move
1191   0x0010=protected
1192   0x0080=grouped
1193   0x0100=hidden
1194   0x0200=visible
1195 end
1196
1197 flagslist=OBJ-FLAGS-BIFF4
1198   include=OBJ-FLAGS-BIFF3
1199   0x0400=printable
1200 end
1201
1202 flagslist=OBJ-AUTO-FLAGS
1203   0x01=auto
1204 end
1205
1206 multilist=OBJ-LINETYPE
1207   0=solid,dash,dot,dash-dot,dash-dot-dot,25%-pattern,50%-pattern,75%-pattern
1208   255=none
1209 end
1210
1211 shortlist=OBJ-LINEWEIGHT,0,hair,thin,medium,thick
1212
1213 shortlist=OBJ-ARROWHEAD-TYPE,0,none,open,filled,double-end-open,double-end-filled
1214 shortlist=OBJ-ARROWHEAD-WIDTH,0,narrow,medium,wide
1215 shortlist=OBJ-ARROWHEAD-LENGTH,0,short,medium,long
1216
1217 combilist=OBJ-LINEENDS
1218   0x000F=uint8,dec,arrowhead-type,OBJ-ARROWHEAD-TYPE
1219   0x00F0=uint8,dec,arrowhead-width,OBJ-ARROWHEAD-WIDTH
1220   0x0F00=uint8,dec,arrowhead-length,OBJ-ARROWHEAD-LENGTH
1221 end
1222
1223 shortlist=OBJ-LINEDIR,0,topleft-to-bottomright,topright-to-bottomleft,bottomright-to-topleft,bottomleft-to-topright
1224
1225 shortlist=OBJ-ARC-QUADRANT,0,upper-right,upper-left,lower-left,lower-right
1226
1227 combilist=OBJ-FRAMESTYLE-FLAGS
1228   0x0001=rounded
1229   0x0002=shadow
1230   0x03FC=uint16,dec,rounded-diameter
1231 end
1232
1233 shortlist=OBJ-HORALIGN,0,none,left,center,right,justify
1234 shortlist=OBJ-VERALIGN,0,none,top,center,bottom,justify
1235
1236 combilist=OBJ-TEXT-FLAGS
1237   0x000E=uint16,dec,hor-align,OBJ-HORALIGN
1238   0x0070=uint16,dec,ver-align,OBJ-VERALIGN
1239   0x0080=auto-size
1240   0x0200=text-locked
1241   0x0400=selected
1242 end
1243
1244 flagslist=OBJ-PICTURE-FLAGS
1245   0x0001=auto-size
1246   0x0002=linked
1247   0x0008=symbol
1248 end
1249
1250 flagslist=OBJ-POLYGON-FLAGS
1251   0x0100=closed
1252 end
1253
1254 flagslist=OBJ-CHART-FLAGS-BIFF5
1255   0x0001=linked-to-sheet
1256 end
1257
1258 flagslist=OBJ-BUTTON-FLAGS-BIFF5
1259   0x0001=default-btn
1260   0x0002=help-btn
1261   0x0004=cancel-btn
1262   0x0008=close-btn
1263 end
1264
1265 shortlist=OBJ-CHECKBOX-STATE-BIFF5,0,unchecked,checked,tristate
1266
1267 flagslist=OBJ-CHECKBOX-FLAGS-BIFF5
1268   0x0001=flat
1269   0x0002=box-only
1270 end
1271
1272 shortlist=OBJ-EDIT-TYPE-BIFF5,0,text,integer,double,reference,formula
1273
1274 flagslist=OBJ-SCROLLBAR-FLAGS-BIFF5
1275   0x0001=visible
1276   0x0002=slider-only
1277   0x0004=tracking
1278   0x0008=flat
1279 end
1280
1281 combilist=OBJ-LISTBOX-FLAGS-BIFF5
1282   0x0004=linked-edit
1283   0x0008=flat
1284   0x0030=uint8,dec,selection-type,OBJ-LISTBOX-SELTYPE-BIFF5
1285 end
1286
1287 shortlist=OBJ-LISTBOX-SELTYPE-BIFF5,0,single,multi,range
1288
1289 flagslist=OBJ-GROUPBOX-FLAGS-BIFF5
1290   0x0001=flat
1291 end
1292
1293 combilist=OBJ-DROPDOWN-FLAGS-BIFF5
1294   0x0003=uint8,dec,type,OBJ-DROPDOWN-TYPE-BIFF5
1295   0x0008=filtered
1296 end
1297
1298 shortlist=OBJ-DROPDOWN-TYPE-BIFF5,0,listbox,combobox,simple,max
1299
1300 multilist=OBJ-RECNAMES-BIFF8
1301   0x0000=OBJEND,,,,OBJMACRO,,OBJGMO,OBJCF
1302   0x0008=OBJFLAGS,OBJPICTFMLA,OBJCBLS,OBJRBO,OBJSBS,OBJNTS,OBJSBSFMLA,OBJGBODATA
1303   0x0010=OBJEDODATA,OBJRBODATA,OBJCBLSDATA,OBJLBSDATA,OBJCBLSFMLA,OBJCMO,,
1304 end
1305
1306 flagslist=OBJFLAGS-FLAGS
1307   0x0001=manual-size
1308   0x0002=linked
1309   0x0004=update-on-print
1310   0x0008=symbol
1311   0x0010=control
1312   0x0020=ctls-stream
1313   0x0080=camera-pic
1314   0x0100=default-size
1315   0x0200=auto-load
1316 end
1317
1318 flagslist=OBJCMO-FLAGS
1319   0x0001=locked
1320   0x0004=default-size
1321   0x0008=published
1322   0x0010=printable
1323   0x0080=disabled
1324   0x0100=auxiliary
1325   0x0200=recalc-on-load
1326   0x1000=recalc-always
1327   0x2000=auto-line
1328   0x4000=auto-area
1329 end
1330
1331 # PAGESETUP ------------------------------------------------------------------
1332
1333 multilist=PAGESETUP-PAPERSIZE
1334   0=undefined,letter,letter-small,tabloid,ledger,legal,statement,executive,a3,a4
1335   10=a4-small,a5,b4,b5,folio,quarto,10x14,11x17,note,envelope-9
1336   20=envelope-10,envelope-11,envelope-12,envelope-14,c,d,e,envelope-dl,envelope-c5,envelope-c3
1337   30=envelope-c4,envelope-c6,envelope-c65,envelope-b4,envelope-b5,envelope-b6,envelope-italy,envelope-monarch,envelope-6-3/4,us-standard-fanfold
1338   40=german-standard-fanfold,german-legal-fanfold,b4,japanese-dbl-postcaed,9x11,10x11,15x11,,
1339   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
1340   60=a4-plus,a5-transverse,jis-b5-transverse,a3-extra,a5-extra,b5-extra,a2,a3-transverse,a3-extra-transverse
1341 end
1342
1343 constlist=PAGESETUP-SCALETOPAGES
1344   default=
1345   0=automatic
1346 end
1347
1348 flagslist=PAGESETUP-FLAGS-BIFF4
1349   0x0001=print-in-rows
1350   0x0002=portrait
1351   0x0004=uninitialized
1352   0x0008=black-and-white
1353 end
1354
1355 flagslist=PAGESETUP-FLAGS-BIFF5
1356   include=PAGESETUP-FLAGS-BIFF4
1357   0x0010=draft-quality
1358   0x0020=print-notes
1359   0x0040=default-orientation
1360   0x0080=use-first-page
1361 end
1362
1363 combilist=PAGESETUP-FLAGS-BIFF8
1364   include=PAGESETUP-FLAGS-BIFF5
1365   0x0200=print-notes-at-end
1366   0x0C00=uint8,dec,print-errors,PAGESETUP-PRINTERRORS
1367 end
1368
1369 shortlist=PAGESETUP-PRINTERRORS,0,displayed,none,as-dashes,as-na
1370
1371 unitconverter=PAGESETUP-DPI,1,dpi
1372
1373 # PANE -----------------------------------------------------------------------
1374
1375 shortlist=PANE-ID,0,bottom-right,top-right,bottom-left,top-left
1376
1377 # PCDEFINITION ---------------------------------------------------------------
1378
1379 flagslist=PCDEFINITION-FLAGS
1380   0x0001=save-data
1381   0x0002=invalid
1382   0x0004=refresh-on-load
1383   0x0008=optimize-memory
1384   0x0010=background-query
1385   0x0020=enable-refresh
1386 end
1387
1388 # PCDFIELD -------------------------------------------------------------------
1389
1390 flagslist=PCDFIELD-FLAGS
1391   0x0001=has-items
1392   0x0002=has-unshared-items
1393   0x0004=calculated
1394   0x0008=has-parent
1395   0x0010=range-group
1396   0x0020=is-numeric
1397   0x0040=is-integer
1398   0x0080=has-semi-mixed-types
1399   0x0100=has-min-max
1400   0x0200=16bit-indexes
1401   0x0400=has-non-date
1402   0x0800=has-date
1403 end
1404
1405 # PCDFRANGEPR ----------------------------------------------------------------
1406
1407 combilist=PCDFRANGEPR-FLAGS
1408   ignore=0xFFE0
1409   0x0001=auto-start
1410   0x0002=auto-end
1411   0x001C=uint8,dec,group-by,PCDFRANGEPR-GROUPBY
1412 end
1413
1414 shortlist=PCDFRANGEPR-GROUPBY,0,numeric,seconds,minutes,hours,days,months,quarters,years
1415
1416 # PCDFSQLTYPE ----------------------------------------------------------------
1417
1418 shortlist=PCDFSQLTYPE-DATATYPE,0,unknown,char,numeric,decimal,int32,int16,float,real,double,,,datetime,var-char
1419
1420 # PCDSOURCE ------------------------------------------------------------------
1421
1422 flagslist=PCDSOURCE-TYPE
1423   0x0001=spreadsheet
1424   0x0002=extern
1425   0x0004=consolidation-area
1426   0x0010=scenario
1427 end
1428
1429 # PHONETICPR -----------------------------------------------------------------
1430
1431 shortlist=PHONETICPR-TYPE,0,halfwidth-katakana,fullwidth-katakana,hiragana,no-conversion
1432 shortlist=PHONETICPR-ALIGNMENT,0,no-control,left,center,distributed
1433
1434 combilist=PHONETICPR-FLAGS
1435   ignore=0x0030
1436   0x0003=uint8,dec,type,PHONETICPR-TYPE
1437   0x000C=uint8,dec,alignment,PHONETICPR-ALIGNMENT
1438 end
1439
1440 # PROJEXTSHEET ---------------------------------------------------------------
1441
1442 shortlist=PROJEXTSHEET-TYPE,0,sheet,macro,chart
1443
1444 # PTDATAFIELD ----------------------------------------------------------------
1445
1446 shortlist=PTDATAFIELD-SUBTOTAL,0,sum,count-all,average,max,min,product,count-num,std-dev,std-dev-p,variance,variance-p
1447 shortlist=PTDATAFIELD-SHOWDATAAS,0,normal,diff-from,percent-of,percent-diff-from,running-total-in,percent-of-row,percent-of-column,percent-of-total,index
1448
1449 multilist=PTDATAFIELD-BASEITEM
1450   default=
1451   0x7FFB=previous-item,next-item
1452 end
1453
1454 # PTDEFINITION ---------------------------------------------------------------
1455
1456 flagslist=PTDEFINITION-FLAGS
1457   0x0001=row-grandtotals
1458   0x0002=column-grandtotals
1459   0x0008=auto-format
1460   0x0010=size-auto-format
1461   0x0020=font-auto-format
1462   0x0040=align-auto-format
1463   0x0080=border-auto-format
1464   0x0100=pattern-auto-format
1465   0x0200=number-auto-format
1466 end
1467
1468 constlist=PTDEFINITION-DATAFIELD-POS
1469   default=
1470   -1=append
1471 end
1472
1473 # PTDEFINITION2 --------------------------------------------------------------
1474
1475 combilist=PTDEFINITION2-FLAGS
1476   0x00000001=page-over-then-down
1477   0x000001FE=dec,uint8,page-wrap
1478   0x00010000=enable-wizard
1479   0x00020000=enable-drill
1480   0x00040000=enable-field-props
1481   0x00080000=preserve-formatting
1482   0x00100000=merge-labels
1483   0x00200000=show-error
1484   0x00400000=show-missing
1485   0x00800000=multiple-page-items
1486 end
1487
1488 # PTFIELD --------------------------------------------------------------------
1489
1490 flagslist=PTFIELD-AXISTYPE
1491   0x0001=row
1492   0x0002=column
1493   0x0004=page
1494   0x0008=data
1495 end
1496
1497 flagslist=PTFIELD-SUBTOTALS
1498   0x0001=default
1499   0x0002=sum
1500   0x0004=count-all
1501   0x0008=average
1502   0x0010=max
1503   0x0020=min
1504   0x0040=product
1505   0x0080=count-num
1506   0x0100=std-dev
1507   0x0200=std-dev-p
1508   0x0400=variance
1509   0x0800=variance-p
1510 end
1511
1512 # PTFIELD2 -------------------------------------------------------------------
1513
1514 combilist=PTFIELD2-FLAGS
1515   0x00000001=show-all-items
1516   0x00000002=drag-to-row
1517   0x00000004=drag-to-column
1518   0x00000008=drag-to-page
1519   0x00000010=drag-to-hide
1520   0x00000080=server-based
1521   0x00000200=autosort
1522   0x00000400=ascend-sort
1523   0x00000800=autoshow
1524   0x00001000=autoshow-top
1525   0x00002000=calculated
1526   0x00200000=outline
1527   0x00400000=insert-blank-row
1528   0x00800000=subtotal-top
1529   0xFF000000=uint8,dec,autoshow-item-count
1530 end
1531
1532 # PTFITEM --------------------------------------------------------------------
1533
1534 multilist=PTFITEM-ITEMTYPE
1535   0=data,default,sum,count-all,average,max,min,product,count-num,std-dev,std-dev-p,variance,variance-p,grandtotal
1536   254=page,none
1537 end
1538
1539 flagslist=PTFITEM-FLAGS
1540   0x0001=hidden
1541   0x0002=hide-detail
1542   0x0008=calculated
1543   0x0010=missing
1544 end
1545
1546 constlist=PTFITEM-CACHEIDX
1547   default=
1548   -1=no-cache-item
1549 end
1550
1551 # PTPAGEFIELDS ---------------------------------------------------------------
1552
1553 constlist=PTPAGEFIELDS-ITEM
1554   default=
1555   0x7FFD=all
1556 end
1557
1558 # PTROWCOLITEMS --------------------------------------------------------------
1559
1560 shortlist=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
1561
1562 combilist=PTROWCOLITEMS-FLAGS
1563   ignore=0xC000
1564   0x0001=field-name
1565   0x01FE=uint16,dec,data-field-idx
1566   0x0200=subtotal
1567   0x0400=blocktotal
1568   0x0800=grandtotal
1569   0x1000=multi-data
1570 end
1571
1572 # REFMODE --------------------------------------------------------------------
1573
1574 shortlist=REFMODE,0,R1C1,A1
1575
1576 # ROW ------------------------------------------------------------------------
1577
1578 combilist=ROW-HEIGHT
1579   0x7FFF=uint16,dec,height,CONV-TWIP-TO-PT
1580   0x8000=default-height
1581 end
1582
1583 combilist=ROW-FLAGS
1584   ignore=0x00000100
1585   0x00000007=uint8,dec,outline-level
1586   0x00000010=outline-collapsed
1587   0x00000020=hidden
1588   0x00000040=custom-height
1589   0x00000080=custom-format
1590   0x0FFF0000=uint16,dec,custom-xf-idx
1591   0x10000000=thick-top
1592   0x20000000=thick-bottom
1593   0x40000000=show-phonetic
1594 end
1595
1596 # SHEET ----------------------------------------------------------------------
1597
1598 shortlist=SHEET-STATE,0,visible,hidden,very-hidden
1599 shortlist=SHEET-TYPE,0,worksheet,macrosheet,chartsheet,,,,vb-module
1600
1601 # SHEETPR --------------------------------------------------------------------
1602
1603 shortlist=SHEETPR-WINDOWPOS,0,tiled,horizontal,vertical,cascaded
1604
1605 flagslist=SHEETPR-FLAGS-BIFF3
1606   0x0001=show-autopagebreaks
1607   0x0020=outline-auto-style
1608   0x0040=outline-symbols-below
1609   0x0080=outline-symbols-right
1610   0x0100=fit-to-pages
1611   0x0200=skip-linked-values
1612   0x0400=show-row-outline
1613   0x0800=show-column-outline
1614 end
1615
1616 flagslist=SHEETPR-FLAGS-BIFF4
1617   include=SHEETPR-FLAGS-BIFF3
1618   0x3000=uint8,dec,window-pos,SHEETPR-WINDOWPOS
1619   0x4000=lotus-expr-eval
1620   0x8000=lotus-formula-edit
1621 end
1622
1623 flagslist=SHEETPR-FLAGS-BIFF5
1624   include=SHEETPR-FLAGS-BIFF4
1625   exclude=0x0200,0x3000
1626   0x0010=dialog-sheet
1627 end
1628
1629 # SHEETPROTECTION ------------------------------------------------------------
1630
1631 flagslist=SHEETPROTECTION-FLAGS
1632   0x0001=edit-object
1633   0x0002=edit-scenario
1634   0x0004=format-cell
1635   0x0008=format-column
1636   0x0010=format-row
1637   0x0020=insert-column
1638   0x0040=insert-row
1639   0x0080=insert-hyperlink
1640   0x0100=delete-column
1641   0x0200=delete-row
1642   0x0400=select-locked
1643   0x0800=sort
1644   0x1000=use-autofilter
1645   0x2000=pivottable-report
1646   0x4000=select-unlocked
1647 end
1648
1649 # STYLE ----------------------------------------------------------------------
1650
1651 combilist=STYLE-FLAGS
1652   0x0FFF=uint16,dec,xf-idx
1653   0x8000=builtin
1654 end
1655
1656 shortlist=STYLE-BUILTIN,0,normal,rowlevel,collevel,comma,currency,percent,comma-0,currency-0,hyperlink,followed-hyperlink
1657
1658 # SXEXT ----------------------------------------------------------------------
1659
1660 combilist=SXEXT-FLAGS
1661   0x0007=uint8,dec,source-type,SXEXT-SOURCETYPE
1662   0x0008=odbc-connection
1663   0x0010=odbc-sql
1664   0x0020=server-pagefields
1665   0x0040=webquery
1666   0x0080=save-password
1667   0x0100=tables-html-only
1668 end
1669
1670 shortlist=SXEXT-SOURCETYPE,1,odbc,dao,,webquery
1671
1672 # TXO ------------------------------------------------------------------------
1673
1674 combilist=TXO-FLAGS
1675   0x000E=uint16,dec,hor-align,OBJ-HORALIGN
1676   0x0070=uint16,dec,ver-align,OBJ-VERALIGN
1677   0x0200=text-locked
1678 end
1679
1680 # WINDOW1 --------------------------------------------------------------------
1681
1682 flagslist=WINDOW1-FLAGS
1683   0x0001=hidden
1684   0x0002=minimized
1685   0x0008=show-horizontal-scroll
1686   0x0010=show-vertical-scroll
1687   0x0020=show-tabbar
1688 end
1689
1690 unitconverter=WINDOW1-TABBARRATIO,/10,%
1691
1692 # WINDOW2 --------------------------------------------------------------------
1693
1694 flagslist=WINDOW2-FLAGS-BIFF3
1695   0x0001=show-formulas
1696   0x0002=show-gridlines
1697   0x0004=show-headings
1698   0x0008=frozen-panes
1699   0x0010=show-zeros
1700   0x0020=default-gridcolor
1701   0x0040=right-to-left
1702   0x0080=show-outline-symbols
1703   0x0100=remove-split-with-freeze
1704 end
1705
1706 flagslist=WINDOW2-FLAGS-BIFF5
1707   include=WINDOW2-FLAGS-BIFF3
1708   0x0200=sheet-selected
1709   0x0400=sheet-active
1710 end
1711
1712 flagslist=WINDOW2-FLAGS-BIFF8
1713   include=WINDOW2-FLAGS-BIFF5
1714   0x0800=pagebreak-mode
1715 end
1716
1717 # XF -------------------------------------------------------------------------
1718
1719 shortlist=XF-HORALIGN,0,general,left,center,right,fill,block,center-across-sel,distribute
1720 shortlist=XF-VERALIGN,0,top,center,bottom,justify,distribute
1721 shortlist=XF-TEXTDIRECTION,0,context,left-to-right,right-to-left
1722
1723 flagslist=XF-PROTECTION-FLAGS
1724   0x01=locked
1725   0x02=formula-hidden
1726   0x04=style-xf
1727 end
1728
1729 flagslist=XF-USEDATTRIBS-FLAGS
1730   0x04=format
1731   0x08=font
1732   0x10=alignment
1733   0x20=border
1734   0x40=area
1735   0x80=protection
1736 end
1737
1738 combilist=XF-STYLEFLAGS-BIFF2
1739   0x07=uint8,dec,hor-align,XF-HORALIGN
1740   0x08=left-border
1741   0x10=right-border
1742   0x20=top-border
1743   0x40=bottom-border
1744   0x80=fill
1745 end
1746
1747 combilist=XF-TYPEFLAGS-BIFF2
1748   0x3F=uint8,dec,fmt-idx,FORMATS
1749   0x40=locked
1750   0x80=formula-hidden
1751 end
1752
1753 flagslist=XF-TYPEFLAGS-BIFF3
1754   include=XF-PROTECTION-FLAGS
1755 end
1756
1757 combilist=XF-TYPEFLAGS-BIFF4
1758   include=XF-TYPEFLAGS-BIFF3
1759   0xFFF0=uint16,dec,parent-xf-idx
1760 end
1761
1762 combilist=XF-ALIGNMENT-BIFF3
1763   0x0007=uint8,dec,hor-align,XF-HORALIGN
1764   0x0008=text-wrap
1765   0xFFF0=uint16,dec,parent-xf-idx
1766 end
1767
1768 combilist=XF-ALIGNMENT-BIFF4
1769   0x07=uint8,dec,hor-align,XF-HORALIGN
1770   0x08=text-wrap
1771   0x30=uint8,dec,ver-align,XF-VERALIGN
1772   0xC0=uint8,dec,orientation,TEXTORIENTATION
1773 end
1774
1775 combilist=XF-ALIGNMENT-BIFF5
1776   0x07=uint8,dec,hor-align,XF-HORALIGN
1777   0x08=text-wrap
1778   0x70=uint8,dec,ver-align,XF-VERALIGN
1779   0x80=justify-lastline
1780 end
1781
1782 combilist=XF-ORIENTATTRIBS-BIFF5
1783   include=XF-USEDATTRIBS-FLAGS
1784   0x03=uint8,dec,orientation,TEXTORIENTATION
1785 end
1786
1787 combilist=XF-TEXTFLAGS-BIFF8
1788   0x0F=uint8,dec,indent
1789   0x10=shrink-to-fit
1790   0xC0=uint8,dec,text-dir,XF-TEXTDIRECTION
1791 end
1792
1793 combilist=XF-FILL-BIFF3
1794   0x003F=uint8,dec,fill-pattern,FILLPATTERNS
1795   0x07C0=uint8,dec,fg-color-idx,COLORS
1796   0xF800=uint8,dec,bg-color-idx,COLORS
1797 end
1798
1799 combilist=XF-BORDER-BIFF3
1800   0x00000007=uint8,dec,top-style,BORDERSTYLES
1801   0x000000F8=uint8,dec,top-color,COLORS
1802   0x00000700=uint8,dec,left-style,BORDERSTYLES
1803   0x0000F800=uint8,dec,left-color,COLORS
1804   0x00070000=uint8,dec,bottom-style,BORDERSTYLES
1805   0x00F80000=uint8,dec,bottom-color,COLORS
1806   0x07000000=uint8,dec,right-style,BORDERSTYLES
1807   0xF8000000=uint8,dec,right-color,COLORS
1808 end
1809
1810 combilist=XF-FILL-BIFF5
1811   0x0000007F=uint8,dec,fg-color-idx,COLORS
1812   0x00003F80=uint8,dec,bg-color-idx,COLORS
1813   0x003F0000=uint8,dec,fill-pattern,FILLPATTERNS
1814   0x01C00000=uint8,dec,bottom-style,BORDERSTYLES
1815   0xFE000000=uint8,dec,bottom-color,COLORS
1816 end
1817
1818 combilist=XF-BORDER-BIFF5
1819   0x00000007=uint8,dec,top-style,BORDERSTYLES
1820   0x00000038=uint8,dec,left-style,BORDERSTYLES
1821   0x000001C0=uint8,dec,right-style,BORDERSTYLES
1822   0x0000FE00=uint8,dec,top-color,COLORS
1823   0x007F0000=uint8,dec,left-color,COLORS
1824   0x3F800000=uint8,dec,right-color,COLORS
1825 end
1826
1827 combilist=XF-BORDERSTYLE-BIFF8
1828   0x000F=uint8,dec,left-style,BORDERSTYLES
1829   0x00F0=uint8,dec,right-style,BORDERSTYLES
1830   0x0F00=uint8,dec,top-style,BORDERSTYLES
1831   0xF000=uint8,dec,bottom-style,BORDERSTYLES
1832 end
1833
1834 combilist=XF-BORDERCOLOR1-BIFF8
1835   0x007F=uint8,dec,left-color,COLORS
1836   0x3F80=uint8,dec,right-color,COLORS
1837   0x4000=diag-tl-to-br
1838   0x8000=diag-bl-to-tr
1839 end
1840
1841 combilist=XF-BORDERCOLOR2-BIFF8
1842   0x0000007F=uint8,dec,top-color,COLORS
1843   0x00003F80=uint8,dec,bottom-color,COLORS
1844   0x001FC000=uint8,dec,diag-color,COLORS
1845   0x01E00000=uint8,dec,diag-style,BORDERSTYLES
1846   0xFC000000=uint8,dec,fill-pattern,FILLPATTERNS
1847 end
1848
1849 combilist=XF-FILLCOLOR-BIFF8
1850   0x007F=uint8,dec,fg-color-idx,COLORS
1851   0x3F80=uint8,dec,bg-color-idx,COLORS
1852 end
1853
1854 # BIFF2 XF index field -------------------------------------------------------
1855
1856 constlist=XFINDEX-BIFF2
1857   default=
1858   63=from-ixfe
1859 end
1860
1861 combilist=CELL-XFINDEX-BIFF2
1862   0x3F=uint8,dec,xf-idx,XFINDEX-BIFF2
1863   0x40=locked
1864   0x80=formula-hidden
1865 end
1866
1867 combilist=CELL-XFFORMAT-BIFF2
1868   0x3F=uint8,dec,fmt-idx,FORMATS
1869   0xC0=uint8,dec,font-idx,FONTNAMES
1870 end
1871
1872 combilist=CELL-XFSTYLE-BIFF2
1873   include=XF-STYLEFLAGS-BIFF2
1874 end
1875
1876 # ============================================================================
1877