oox/source/dump/biffdumper.ini

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