oox/source/dump/xlsbdumper.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=oledumper.ini
   7
   8 # Enable entire dumper. This option does not affect the option 'enable-import'.
   9 #   0=off, 1=on, missing = use setting from dumperbase.ini
  10 # enable-dumper=1
  11
  12 # Enable import after dumping. Disabling this option allows to dump a file
  13 # without loading it. This option is independent from the 'enable-dumper'
  14 # option.
  15 #   0=off, 1=on, missing = use setting from dumperbase.ini
  16 # enable-import=1
  17
  18 # name lists =================================================================
  19
  20 # common ---------------------------------------------------------------------
  21
  22 unitconverter=CONV-TINT,/327.67,%
  23 unitconverter=CONV-COLWIDTH,/256,chars
  24
  25 constlist=ERRORCODES
  26   0x00=#NULL!
  27   0x07=#DIV/0!
  28   0x0F=#VALUE!
  29   0x17=#REF!
  30   0x1D=#NAME?
  31   0x24=#NUM!
  32   0x2A=#N/A
  33 end
  34
  35 flagslist=STRING-FLAGS
  36   0x01=rich-string
  37   0x02=phonetic-text
  38 end
  39
  40 combilist=CELL-XFID
  41   0x00FFFFFF=int32,dec,xf-id
  42   0x01000000=show-phonetic
  43 end
  44
  45 combilist=PHONETIC-FLAGS
  46   ignore=0x0030
  47   0x0003=uint8,dec,type,PHONETICPR-TYPE
  48   0x000C=uint8,dec,alignment,PHONETICPR-ALIGNMENT
  49 end
  50
  51 shortlist=COLOR-TYPE,0,auto,indexed,rgb,theme
  52
  53 combilist=COLOR-FLAGS
  54   0x01=rgb-valid
  55   0xFE=uint8,dec,type,COLOR-TYPE
  56 end
  57
  58 multilist=PALETTE-COLORS
  59   default=
  60   0=ega-black,ega-white,ega-red,ega-green,ega-blue,ega-yellow,ega-magenta,ega-cyan
  61   64=sys-window-text
  62   65=sys-window-bg
  63   67=sys-button-face
  64   77=sys-window-text-chart
  65   78=sys-window-bg-chart
  66   79=auto-border-chart
  67   80=sys-tooltip-bg
  68   81=sys-tooltip-text
  69 end
  70
  71 constlist=TEXTROTATION
  72   default=
  73   255=stacked
  74 end
  75
  76 multilist=BORDERSTYLES
  77   0=none,thin,medium,dash,dot
  78   5=thick,double,hair,medium-dash,thin-dash-dot
  79   10=medium-dash-dot,thin-dash-dot-dot,medium-dash-dot-dot,slant-dash-dot
  80 end
  81
  82 multilist=FILLPATTERNS
  83   0=no-fill,solid-fill,50%-grey,75%-grey,25%-grey
  84   5=hor-stripe,ver-stripe,rev-diag-stripe,diag-stripe,diag-crosshatch
  85   10=thick-diag-crosshatch,thin-hor-stripe,thin-ver-stripe,thin-rev-diag-stripe,thin-diag-stripe
  86   15=thin-hor-crosshatch,thin-diag-crosshatch,12.5%-grey,6.25%-grey
  87   40=gradient
  88 end
  89
  90 # formulas -------------------------------------------------------------------
  91
  92 flagslist=FORMULA-FLAGS
  93   0x0002=recalc-always
  94 end
  95
  96 multilist=BASETOKENS
  97   0x00=,tExp,tTbl,tAdd,tSub,tMul,tDiv,tPower
  98   0x08=tConcat,tLT,tLE,tEQ,tGE,tGT,tNE,tIsect
  99   0x10=tList,tRange,tUplus,tUminus,tPercent,tParen,tMissArg,tStr
 100   0x18=tTable,tAttr,,,tErr,tBool,tInt,tNum
 101 end
 102
 103 constlist=TOKENCLASSES
 104   0x20=R
 105   0x40=V
 106   0x60=A
 107 end
 108
 109 multilist=CLASSTOKENS
 110   0x00=tArray,tFunc,tFuncVar,tName,tRef,tArea,tMemArea,tMemErr
 111   0x08=tMemNoMem,tMemFunc,tRefErr,tAreaErr,tRefN,tAreaN,tMemAreaN,tMemNoMemN
 112   0x18=,tNameX,tRef3d,tArea3d,tRefErr3d,tAreaErr3d
 113 end
 114
 115 combilist=FUNCID
 116   0x7FFF=uint16,dec,func-id
 117   0x8000=command
 118 end
 119
 120 combilist=PARAMCOUNT-CMD
 121   0x7F=uint8,dec,count
 122   0x80=prompt
 123 end
 124
 125 combilist=REFRELFLAGS
 126   0x3FFF=uint16,dec,value
 127   0x4000=col-rel
 128   0x8000=row-rel
 129 end
 130
 131 flagslist=TABLEFLAGS
 132   0x0001=single-column
 133   0x0002=column-range
 134   0x0004=#all
 135   0x0008=#headers
 136   0x0010=#data
 137   0x0020=#totals
 138   0x0040=#this-row
 139   0x0080=bracket-spaces
 140   0x0100=sep-spaces
 141   0x0200=single-row
 142   0x0400=single-cell
 143 end
 144
 145 flagslist=ATTRTYPES
 146   0x01=volatile
 147   0x02=if
 148   0x04=choose
 149   0x08=skip
 150   0x10=sum
 151   0x20=assign
 152   0x40=space
 153   0x80=iferror
 154 end
 155
 156 shortlist=ATTRSPACETYPES,0,space-before-token,cr-before-token,space-before-open,cr-before-open,space-before-close,cr-before-close,leading-space
 157
 158 shortlist=ARRAYVALUE-TYPE,0,number,string,boolean,,error
 159
 160 # record names ---------------------------------------------------------------
 161
 162 multilist=RECORD-NAMES
 163   0x0000=ROW,CELL_BLANK,CELL_RK,CELL_ERROR,CELL_BOOL,CELL_DOUBLE,CELL_STRING,CELL_SI
 164   0x0008=FORMULA_STRING,FORMULA_DOUBLE,FORMULA_BOOL,FORMULA_ERROR,MULTCELL_BLANK,MULTCELL_RK,MULTCELL_ERROR,MULTCELL_BOOL
 165   0x0010=MULTCELL_DOUBLE,MULTCELL_STRING,MULTCELL_SI,SI,PCITEM_MISSING,PCITEM_DOUBLE,PCITEM_BOOL,PCITEM_ERROR
 166   0x0018=PCITEM_STRING,PCITEM_DATE,PCITEM_INDEX,PCITEMA_MISSING,PCITEMA_DOUBLE,PCITEMA_BOOL,PCITEMA_ERROR,PCITEMA_STRING
 167   0x0020=PCITEMA_DATE,PCRECORD,PCRECORDDT,FRT,FRT_END,,,DEFINEDNAME
 168   0x0028=BINARYINDEXROWS,,BINARYINDEXBLOCK,FONT,NUMFMT,FILL,BORDER,XF
 169   0x0030=CELLSTYLE,,,,,,,
 170   0x0038=,,,,COL,MULTCELL_RSTRING,CELL_RSTRING,CALCCHAINCELL
 171   0x0040=DATAVALIDATION,,,,,,,
 172
 173   0x0080=FILEVERSION,WORKSHEET,WORKSHEET_END,WORKBOOK,WORKBOOK_END,SHEETVIEWS,SHEETVIEWS_END,BOOKVIEWS
 174   0x0088=BOOKVIEWS_END,SHEETVIEW,SHEETVIEW_END,CHARTSHEETVIEWS,CHARTSHEETVIEWS_END,CHARTSHEETVIEW,CHARTSHEETVIEW_END,SHEETS
 175   0x0090=SHEETS_END,SHEETDATA,SHEETDATA_END,SHEETPR,DIMENSION,,,PANE
 176   0x0098=SELECTION,WORKBOOKPR,SMARTTAGPR,FILERECOVERYPR,SHEET,CALCPR,WORKBOOKVIEW,SST
 177   0x00A0=SST_END,AUTOFILTER,AUTOFILTER_END,FILTERCOLUMN,FILTERCOLUMN_END,FILTERS,FILTERS_END,FILTER
 178   0x00A8=COLORFILTER,ICONFILTER,TOP10FILTER,DYNAMICFILTER,CUSTOMFILTERS,CUSTOMFILTERS_END,CUSTOMFILTER,AUTOFILTERDATEGROUPITEM
 179   0x00B0=MERGECELL,MERGECELLS,MERGECELLS_END,PCDEFINITION,PCDEFINITION_END,PCDFIELDS,PCDFIELDS_END,PCDFIELD
 180   0x00B8=PCDFIELD_END,PCDSOURCE,PCDSOURCE_END,PCDSHEETSOURCE,PCDSHEETSOURCE_END,PCDFSHAREDITEMS,PCDFSHAREDITEMS_END,PCITEM_ARRAY
 181   0x00C0=PCITEM_ARRAY_END,PCRECORDS,PCRECORDS_END,,,,,
 182
 183   0x00D8=,,,PCDFIELDGROUP,PCDFIELDGROUP_END,PCDFGROUPITEMS,PCDFGROUPITEMS_END,PCDFRANGEPR
 184   0x00E0=PCDFRANGEPR_END,PCDFDISCRETEPR,PCDFDISCRETEPR_END,,,,,
 185
 186   0x00F0=,,,,,,,PIVOTAREA
 187   0x00F8=PIVOTAREA_END,PTREFERENCES,PTREFERENCES_END,PTREFERENCE,PTREFERENCE_END,,,
 188
 189   0x0110=,,,,,BINARYINDEX_END,STYLESHEET,STYLESHEET_END
 190   0x0118=PTDEFINITION,PTFITEM_END,PTFITEM,PTFITEMS,PTFITEMS_END,PTFIELD,PTFIELD_END,PTFIELDS
 191   0x0120=PTFIELDS_END,PTPAGEFIELD,PTPAGEFIELD_END,PTPAGEFIELDS,PTPAGEFIELDS_END,PTDATAFIELD,PTDATAFIELD_END,PTDATAFIELDS
 192   0x0128=PTDATAFIELDS_END,,,,,,,
 193   0x0130=,,,,,PTROWFIELDS,PTROWFIELDS_END,PTCOLFIELDS
 194   0x0138=PTCOLFIELDS_END,PTLOCATION_END,PTLOCATION,PTDEFINITION_END,,,,
 195
 196   0x0150=,,,,,,,TABLE
 197   0x0158=TABLE_END,TABLECOLUMNS,TABLECOLUMNS_END,TABLECOLUMN,TABLECOLUMN_END,,,CALCEDCOLUMNFMLA
 198   0x0160=,EXTERNALREFS,EXTERNALREFS_END,EXTERNALREF,,EXTERNALSELF,EXTERNALSAME,EXTSHEETNAMES
 199   0x0168=EXTERNALBOOK,,EXTERNALSHEETS,EXTSHEETDATA,EXTSHEETDATA_END,,EXTROW,EXTCELL_BLANK
 200   0x0170=EXTCELL_DOUBLE,EXTCELL_BOOL,EXTCELL_ERROR,EXTCELL_STRING,,,,
 201   0x0178=,,,,,,PTREFERENCEITEM,PTREFERENCEITEM_END
 202   0x0180=PIVOTCACHES,PIVOTCACHES_END,PIVOTCACHE,PIVOTCACHE_END,,,COLS,COLS_END
 203   0x0188=ROWBREAKS,ROWBREAKS_END,COLBREAKS,COLBREAKS_END,BRK,CUSTOMWORKBOOKVIEW,,
 204
 205   0x01A0=,,,,,,CUSTOMSHEETVIEWS,CUSTOMSHEETVIEW
 206   0x01A8=CUSTOMSHEETVIEW_END,CUSTOMSHEETVIEWS_END,ARRAY,SHAREDFMLA,DATATABLE,,,
 207
 208   0x01C8=,,,AUTOSORTSCOPE,AUTOSORTSCOPE_END,CONDFORMATTING,CONDFORMATTING_END,CFRULE
 209   0x01D0=CFRULE_END,ICONSET,ICONSET_END,DATABAR,DATABAR_END,COLORSCALE,COLORSCALE_END,CFVO
 210   0x01D8=,COLORS,COLORS_END,RGBCOLOR,PAGEMARGINS,PRINTOPTIONS,PAGESETUP,HEADERFOOTER
 211   0x01E0=HEADERFOOTER_END,,,,,SHEETFORMATPR,,
 212   0x01E8=,,,,,,HYPERLINK,
 213   0x01F0=,,,,SCENARIOS,SCENARIOS_END,SCENARIO,SCENARIO_END
 214   0x01F8=INPUTCELLS,DXFS,DXFS_END,DXF,TABLESTYLES,TABLESTYLES_END,,
 215   0x0200=,TABLESTYLEINFO,VOLTYPES,VOLTYPES_END,VOLTYPE,VOLTYPE_END,VOLTYPEMAIN,VOLTYPEMAIN_END
 216   0x0208=VOLTYPETP,VOLTYPETP_END,VOLTYPESTP,VOLTYPETR,,VOLTYPE_ERROR,,
 217   0x0210=CALCCHAIN,CALCCHAIN_END,,,,,,SHEETPROTECTION
 218   0x0218=,PHONETICPR,,,,,,
 219   0x0220=,,,,,,DRAWING,LEGACYDRAWING
 220
 221   0x0230=,,PICTURE,,CFCOLOR,INDEXEDCOLORS,INDEXEDCOLORS_END,
 222   0x0238=,MRUCOLORS,MRUCOLORS_END,,COLOR,DATAVALIDATIONS,DATAVALIDATIONS_END,
 223   0x0240=,EXTERNALNAME,DDEITEMVALUES,DDEITEMVALUES_END,DDEITEM_DOUBLE,DDEITEM_ERROR,DDEITEM_STRING,DDEITEM_EMPTY
 224   0x0248=DDEITEM_BOOL,EXTERNALNAMEREF,EXTERNALNAMEFLAGS,EXTERNALNAME_END,EXTERNALBOOK_END,,,
 225   0x0250=,,,,,,,PTFILTERS
 226   0x0258=PTFILTERS_END,PTFILTER,PTFILTER_END,FILLS,FILLS_END,,,
 227   0x0260=,,,FONTS,FONTS_END,BORDERS,BORDERS_END,NUMFMTS
 228   0x0268=NUMFMTS_END,CELLXFS,CELLXFS_END,CELLSTYLES,CELLSTYLES_END,,,
 229   0x0270=,,CELLSTYLEXFS,CELLSTYLEXFS_END,COMMENTS,COMMENTS_END,COMMENTAUTHORS,COMMENTAUTHORS_END
 230   0x0278=COMMENTAUTHOR,COMMENTLIST,COMMENTLIST_END,COMMENT,COMMENT_END,COMMENTTEXT,OLEOBJECTS,OLEOBJECT
 231   0x0280=OLEOBJECTS_END,,,CONTROLS,CONTROL,CONTROLS_END,,
 232   0x0288=,,,CHARTSHEETPR,CHARTPAGESETUP,CUSTOMCHARTVIEWS,CUSTOMCHARTVIEWS_END,CUSTOMCHARTVIEW
 233   0x0290=CUSTOMCHARTVIEW_END,,,,TABLEPARTS,TABLEPART,TABLEPARTS_END,SHEETCALCPR
 234   0x0298=FUNCTIONGROUPS,FUNCTIONGROUP,FUNCTIONGROUPS_END,EXTERNALADDIN,,CHARTPROTECTION,,
 235 end
 236
 237 # simple records -------------------------------------------------------------
 238
 239 constlist=SIMPLE-RECORDS
 240   0x001A=int32,dec,item-index
 241   0x00B5=int32,dec,count
 242   0x00C1=int32,dec,count
 243   0x00DD=int32,dec,count
 244   0x00E1=int32,dec,count
 245   0x00F9=int32,dec,count
 246   0x011B=int32,dec,count
 247   0x011F=int32,dec,count
 248   0x0123=int32,dec,count
 249   0x0159=int32,dec,count
 250   0x017E=int32,dec,item-index
 251   0x01DD=uint16,hex,flags,PRINTOPTIONS-FLAGS
 252   0x01F9=int32,dec,count
 253   0x0204=int32,dec,type,VOLTYPE-TYPE
 254   0x020D=uint8,dec,error-code,ERRORCODES
 255   0x0244=double,dec,value
 256   0x0245=uint8,dec,error-code,ERRORCODES
 257   0x0248=uint8,dec,value,BOOLEAN
 258   0x0257=int32,dec,count
 259   0x025B=int32,dec,count
 260   0x0263=int32,dec,count
 261   0x0265=int32,dec,count
 262   0x0267=int32,dec,count
 263   0x0269=int32,dec,count
 264   0x026B=int32,dec,count
 265   0x0272=int32,dec,count
 266   0x0294=int32,dec,count
 267   0x0297=uint8,hex,flags,SHEETCALCPR-FLAGS
 268   0x0298=uint8,dec,builtin-count
 269 end
 270
 271 # ARRAY ----------------------------------------------------------------------
 272
 273 flagslist=ARRAY-FLAGS
 274   0x01=recalc-always
 275 end
 276
 277 # BORDER ---------------------------------------------------------------------
 278
 279 flagslist=BORDER-FLAGS
 280   0x01=diag-tl-to-br
 281   0x02=diag-bl-to-tr
 282 end
 283
 284 # CALCPR ---------------------------------------------------------------------
 285
 286 shortlist=CALCPR-CALCMODE,0,manual,auto,auto-no-tables
 287
 288 flagslist=CALCPR-FLAGS
 289   0x0001=calc-on-load
 290   0x0002=a1
 291   0x0004=iterate
 292   0x0008=full-precision
 293   0x0010=calc-complete
 294   0x0020=calc-on-save
 295   0x0040=concurrent
 296   0x0080=manual-processors
 297   0x0100=force-full-calc
 298 end
 299
 300 # CELLSTYLE ------------------------------------------------------------------
 301
 302 flagslist=CELLSTYLE-FLAGS
 303   0x0001=builtin
 304   0x0002=hidden
 305   0x0004=custom
 306 end
 307
 308 multilist=CELLSTYLE-BUILTIN
 309   0=normal,rowlevel,collevel,comma,currency,percent,comma-0,currency-0,hyperlink,followed-hyperlink
 310   10=note,warning-text,,,,title,heading-1,heading-2,heading-3,heading-4
 311   20=input,output,calculation,check-cell,linked-cell,total,good,bad,neutral,accent1
 312   30=20%-accent1,40%-accent1,60%-accent1,accent2,20%-accent2,40%-accent2,60%-accent2,accent3,20%-accent3,40%-accent3
 313   40=60%-accent3,accent4,20%-accent4,40%-accent4,60%-accent4,accent5,20%-accent5,40%-accent5,60%-accent5,accent6
 314   50=20%-accent6,40%-accent6,60%-accent6,explanatory-text
 315 end
 316
 317 # CFRULE ---------------------------------------------------------------------
 318
 319 shortlist=CFRULE-TYPE,1,cell-is,expression,color-scale,data-bar,top-ten,icon-set
 320
 321 multilist=CFRULE-SUBTYPE
 322   0=cell-is,expression,color-scale,data-bar,icon-set,top-ten,,unique-values,contains-text,contains-blanks
 323   10=not-contains-blanks,contains-errors,not-contains-errors,,,today,tomorrow,yesterday,last-7-days,last-month
 324   20=next-month,this-week,next-week,last-week,this-month,above-average,below-average,duplicate-values,,equal-above-average
 325   30=equal-below-average
 326 end
 327
 328 shortlist=CFRULE-CELL-OPERATOR,1,between,not-between,equal,not-equal,greater-than,less-than,greater-equal,less-equal
 329 shortlist=CFRULE-TEXT-OPERATOR,0,contains,not-contains,begins-with,ends-with
 330 shortlist=CFRULE-TIME-OPERATOR,0,today,yesterday,last-7-days,this-week,last-week,last-month,tomorrow,next-week,next-month,this-month
 331 shortlist=CFRULE-OTHER-OPERATOR,0,none
 332
 333 flagslist=CFRULE-FLAGS
 334   0x0001=table-row
 335   0x0002=stop-if-true
 336   0x0004=avove-average
 337   0x0008=bottom
 338   0x0010=percent
 339 end
 340
 341 # CHARTPAGESETUP ------------------------------------------------------------------
 342
 343 combilist=CHARTPAGESETUP-FLAGS
 344   0x0001=landscape
 345   0x0002=uninitialized
 346   0x0004=black-and-white
 347   0x0008=default-orientation
 348   0x0010=use-first-page
 349   0x0020=draft-quality
 350 end
 351
 352 # CHARTSHEETPR ---------------------------------------------------------------
 353
 354 flagslist=CHARTSHEETPR-FLAGS
 355   0x0001=published
 356 end
 357
 358 # CHARTSHEETVIEW -------------------------------------------------------------
 359
 360 flagslist=CHARTSHEETVIEW-FLAGS
 361   0x0001=selected
 362   0x0002=zoom-to-fit
 363 end
 364
 365 # COL ------------------------------------------------------------------------
 366
 367 combilist=COL-FLAGS
 368   0x0001=hidden
 369   0x0002=custom-width
 370   0x0004=best-fit
 371   0x0008=show-phonetic
 372   0x0700=uint8,dec,outline-level
 373   0x1000=outline-collapsed
 374 end
 375
 376 # DATATABLE ------------------------------------------------------------------
 377
 378 flagslist=DATATABLE-FLAGS
 379   0x01=row-table
 380   0x02=table-2d
 381   0x04=ref1-deleted
 382   0x08=ref2-deleted
 383   0x10=recalc-always
 384 end
 385
 386 # DATAVALIDATION -------------------------------------------------------------
 387
 388 combilist=DATAVALIDATION-FLAGS
 389   0x0000000F=uint8,dec,type,DATAVALIDATION-TYPE
 390   0x00000070=uint8,dec,error-style,DATAVALIDATION-ERRORSTYLE
 391   0x00000080=string-list
 392   0x00000100=ignore-empty
 393   0x00000200=no-dropdown
 394   0x00040000=show-input-box
 395   0x00080000=show-error-box
 396   0x00F00000=uint8,dec,operator,DATAVALIDATION-OPERATOR
 397 end
 398
 399 shortlist=DATAVALIDATION-TYPE,0,any,whole,decimal,list,date,time,text-length,custom
 400 shortlist=DATAVALIDATION-OPERATOR,0,between,not-between,equal,not-equal,greater-than,less-than,greater-equal,less-equal
 401 shortlist=DATAVALIDATION-ERRORSTYLE,0,error,warning,info
 402
 403 # DATAVALIDATIONS ------------------------------------------------------------
 404
 405 combilist=DATAVALIDATIONS-FLAGS
 406   0x0001=disable-prompts
 407 end
 408
 409 # DEFINEDNAME ----------------------------------------------------------------
 410
 411 combilist=DEFINEDNAME-FLAGS
 412   0x00000001=hidden
 413   0x00000002=function
 414   0x00000004=vba
 415   0x00000008=macro
 416   0x00000010=complex
 417   0x00000020=built-in
 418   0x00007FC0=int32,dec,func-group,DEFINEDNAME-FUNCGROUP
 419   0x00008000=published
 420   0x00010000=workbook-param
 421 end
 422
 423 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
 424
 425 constlist=DEFINEDNAME-SHEETID
 426   default=
 427   -1=global
 428 end
 429
 430 # DXF ------------------------------------------------------------------------
 431
 432 flagslist=DXF-FLAGS
 433   0x00008000=border-outline
 434 end
 435
 436 multilist=DXF-SUBREC
 437   0=FILL-PATTERN,FILL-FGCOLOR,FILL-BGCOLOR,FILL-GRADIENT,FILL-STOP
 438   5=FONT-COLOR,BORDER-TOP,BORDER-BOTTOM,BORDER-LEFT,BORDER-RIGHT
 439   10=BORDER-DIAGONAL,BORDER-VERTICAL,BORDER-HORIZONTAL,BORDER-DIAGUP,BORDER-DIAGDOWN
 440   15=ALIGN-HORIZONTAL,ALIGN-VERTICAL,ALIGN-ROTATION,ALIGN-INDENT,ALIGN-READINGORDER
 441   20=ALIGN-WRAPTEXT,ALIGN-JUSTLASTLINE,ALIGN-SHRINKTOFIT,,FONT-NAME
 442   25=FONT-WEIGHT,FONT-UNDERLINE,FONT-ESCAPEMENT,FONT-ITALIC,FONT-STRIKE
 443   30=FONT-OUTLINE,FONT-SHADOW,FONT-CONDENSE,FONT-EXTEND,FONT-CHARSET
 444   35=FONT-PITCHFAMILY,FONT-HEIGHT,FONT-SCHEME,NUMFMT-CODE,
 445   40=,NUMFMT-ID,ALIGN-RELINDENT,PROT-LOCKED,PROT-HIDDEN
 446 end
 447
 448 # EXTERNALBOOK ---------------------------------------------------------------
 449
 450 shortlist=EXTERNALBOOK-TYPE,0,book,dde-link,ole-link
 451
 452 # EXTERNALNAMEFLAGS ----------------------------------------------------------
 453
 454 flagslist=EXTERNALNAMEFLAGS-FLAGS
 455   0x0002=automatic
 456   0x0004=pic-link
 457   0x0008=dde-stddocumentname
 458   0x0010=ole-link
 459   0x0020=iconified
 460 end
 461
 462 # EXTERNALSHEETS -------------------------------------------------------------
 463
 464 constlist=EXTERNALSHEETS-ID
 465   default=
 466   -1=deleted
 467   -2=special
 468 end
 469
 470 # EXTSHEETDATA ---------------------------------------------------------------
 471
 472 flagslist=EXTSHEETDATA-FLAGS
 473   0x01=refresh-error
 474 end
 475
 476 # FILL -----------------------------------------------------------------------
 477
 478 shortlist=FILL-GRADIENTTYPE,0,linear,path
 479
 480 # FONT -----------------------------------------------------------------------
 481
 482 flagslist=FONT-FLAGS
 483   0x0001=bold
 484   0x0002=italic
 485   0x0004=underline
 486   0x0008=strikeout
 487   0x0010=outline
 488   0x0020=shadow
 489   0x0040=condense
 490   0x0080=extend
 491 end
 492
 493 multilist=FONT-UNDERLINE
 494   0x00=none,single,double
 495   0x21=single-acc,double-acc
 496 end
 497
 498 shortlist=FONT-SCHEME,0,none,major,minor
 499 shortlist=FONT-ESCAPEMENT,0,none,superscript,subscript
 500
 501 # HEADERFOOTER ---------------------------------------------------------------
 502
 503 flagslist=HEADERFOOTER-FLAGS
 504   0x0001=diff-odd-even
 505   0x0002=diff-dirst
 506   0x0004=scale-with-doc
 507   0x0008=align-with-margins
 508 end
 509
 510 # OLEOBJECT ------------------------------------------------------------------
 511
 512 shortlist=OLEOBJECT-ASPECT,1,content,,,icon
 513 shortlist=OLEOBJECT-UPDATE,0,na,automatic,,manual
 514
 515 flagslist=OLEOBJECT-FLAGS
 516   0x0001=linked
 517   0x0002=auto-load
 518 end
 519
 520 # PAGESETUP ------------------------------------------------------------------
 521
 522 multilist=PAGESETUP-PAPERSIZE
 523   0=undefined,letter,letter-small,tabloid,ledger,legal,statement,executive,a3,a4
 524   10=a4-small,a5,b4,b5,folio,quarto,10x14,11x17,note,envelope-9
 525   20=envelope-10,envelope-11,envelope-12,envelope-14,c,d,e,envelope-dl,envelope-c5,envelope-c3
 526   30=envelope-c4,envelope-c6,envelope-c65,envelope-b4,envelope-b5,envelope-b6,envelope-italy,envelope-monarch,envelope-6-3/4,us-standard-fanfold
 527   40=german-standard-fanfold,german-legal-fanfold,b4,japanese-dbl-postcaed,9x11,10x11,15x11,,
 528   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
 529   60=a4-plus,a5-transverse,jis-b5-transverse,a3-extra,a5-extra,b5-extra,a2,a3-transverse,a3-extra-transverse
 530 end
 531
 532 constlist=PAGESETUP-SCALETOPAGES
 533   default=
 534   0=automatic
 535 end
 536
 537 combilist=PAGESETUP-FLAGS
 538   0x0001=print-in-rows
 539   0x0002=landscape
 540   0x0004=uninitialized
 541   0x0008=black-and-white
 542   0x0010=draft-quality
 543   0x0020=print-notes
 544   0x0040=default-orientation
 545   0x0080=use-first-page
 546   0x0100=print-notes-at-end
 547   0x0600=uint8,dec,print-errors,PAGESETUP-PRINTERRORS
 548 end
 549
 550 shortlist=PAGESETUP-PRINTERRORS,0,displayed,none,as-dashes,as-na
 551
 552 unitconverter=PAGESETUP-DPI,1,dpi
 553
 554 # PANE -----------------------------------------------------------------------
 555
 556 shortlist=PANE-ID,0,bottom-right,top-right,bottom-left,top-left
 557
 558 flagslist=PANE-FLAGS
 559   0x01=frozen
 560   0x02=remove-split-with-freeze
 561 end
 562
 563 # PCDEFINITION ---------------------------------------------------------------
 564
 565 flagslist=PCDEFINITION-FLAGS1
 566   0x01=save-data
 567   0x02=invalid
 568   0x04=refresh-on-load
 569   0x08=optimize-memory
 570   0x10=enable-refresh
 571   0x20=background-query
 572   0x40=upgrade-on-refresh
 573   0x80=tupel-cache
 574 end
 575
 576 constlist=PCDEFINITION-MISSINGITEMS
 577   default=
 578   -1=clear-automatic
 579   0=clear-always
 580 end
 581
 582 flagslist=PCDEFINITION-FLAGS2
 583   0x01=has-username
 584   0x02=has-rel-id
 585   0x04=support-subquery
 586   0x08=support-drilldown
 587 end
 588
 589 # PCDFIELD -------------------------------------------------------------------
 590
 591 flagslist=PCDFIELD-FLAGS
 592   0x0001=server-field
 593   0x0002=no-unique-items
 594   0x0004=database-field
 595   0x0008=has-caption
 596   0x0010=member-property-field
 597   0x0100=has-formula
 598   0x0200=has-property-name
 599 end
 600
 601 # PCDFRANGEPR ----------------------------------------------------------------
 602
 603 shortlist=PCDFRANGEPR-GROUPBY,0,numeric,seconds,minutes,hours,days,months,quarters,years
 604
 605 flagslist=PCDFRANGEPR-FLAGS
 606   0x01=auto-start
 607   0x02=auto-end
 608   0x04=date-group
 609 end
 610
 611 # PCDFSHAREDITEMS ------------------------------------------------------------
 612
 613 flagslist=PCDFSHAREDITEMS-FLAGS
 614   0x0001=has-semi-mixed-types
 615   0x0002=has-non-date
 616   0x0004=has-date
 617   0x0008=has-string-bool-err
 618   0x0010=has-blank
 619   0x0020=has-mixed-types
 620   0x0040=is-numeric
 621   0x0080=is-integer
 622   0x0100=has-min-max
 623   0x0200=long-text
 624 end
 625
 626 # PCDSOURCE ------------------------------------------------------------------
 627
 628 shortlist=PCDSOURCE-TYPE,0,worksheet,external,consolidation,scenario
 629
 630 # PCDWORKSHEETSOURCE ---------------------------------------------------------
 631
 632 flagslist=PCDWORKSHEETSOURCE-FLAGS
 633   0x01=has-rel-id
 634   0x02=has-sheet
 635 end
 636
 637 # PCITEM_ARRAY ---------------------------------------------------------------
 638
 639 constlist=PCITEM_ARRAY-TYPE
 640   0x0001=double
 641   0x0002=string
 642   0x0010=error
 643   0x0020=date
 644 end
 645
 646 # PHONETICPR -----------------------------------------------------------------
 647
 648 shortlist=PHONETICPR-TYPE,0,halfwidth-katakana,fullwidth-katakana,hiragana,no-conversion
 649 shortlist=PHONETICPR-ALIGNMENT,0,no-control,left,center,distributed
 650
 651 # PIVOTAREA ------------------------------------------------------------------
 652
 653 shortlist=PIVOTAREA-TYPE,0,none,normal,data,all,origin,button,top-right
 654
 655 flagslist=PIVOTAREA-FLAGS1
 656   0x01=data-only
 657   0x02=label-only
 658   0x04=grand-row
 659   0x08=grand-col
 660   0x10=cache-based
 661   0x20=line-mode
 662   0x40=part
 663   0x80=fuzzy
 664 end
 665
 666 combilist=PIVOTAREA-FLAGS2
 667   0x0001=row
 668   0x0002=col
 669   0x0004=page
 670   0x0008=data
 671   0x0FF0=uint8,dec,pos-on-axis
 672 end
 673
 674 # PRINTOPTIONS ---------------------------------------------------------------
 675
 676 flagslist=PRINTOPTIONS-FLAGS
 677   0x0001=horizontal-centered
 678   0x0002=vertical-centered
 679   0x0004=print-headings
 680   0x0008=print-gridlines
 681   0x0010=gridlines-set
 682 end
 683
 684 # Pivot table globals --------------------------------------------------------
 685
 686 constlist=PT-FIELDINDEX
 687   default=
 688   -2=data-field
 689 end
 690
 691 # PTDATAFIELD ----------------------------------------------------------------
 692
 693 shortlist=PTDATAFIELD-SUBTOTAL,0,sum,count-all,average,max,min,product,count-num,std-dev,std-dev-p,var,var-p
 694 shortlist=PTDATAFIELD-SHOWDATAAS,0,normal,difference,percent,percent-diff,run-total,percent-of-row,percent-of-col,percent-of-total,index
 695
 696 constlist=PTDATAFIELD-BASEITEM
 697   default=
 698   0x001000FC=previous-item
 699   0x001000FD=next-item
 700 end
 701
 702 # PTDEFINITION ---------------------------------------------------------------
 703
 704 flagslist=PTDEFINITION-FLAGS1
 705   0x01=show-items
 706   0x02=edit-data
 707   0x04=disable-field-list
 708   0x08=refresh-on-load
 709   0x10=hide-calc-members
 710   0x20=with-hidden-totals
 711   0x40=show-multiple-label
 712 end
 713
 714 combilist=PTDEFINITION-FLAGS2
 715   0x0001=hide-data-drop-down
 716   0x0010=hide-drill
 717   0x0020=print-drill
 718   0x0040=show-member-prop-tips
 719   0x0080=hide-data-tips
 720   0x7F00=uint8,dec,indent
 721   0x8000=hide-headers
 722 end
 723
 724 flagslist=PTDEFINITION-FLAGS3
 725   ignore=0x00010000
 726   0x00000001=hide-drop-zones
 727   0x00000002=no-asterisk-totals
 728   0x00000004=show-empty-row
 729   0x00000008=show-empty-col
 730   0x00000010=enable-wizard
 731   0x00000020=enable-drill
 732   0x00000040=enable-field-props
 733   0x00000080=preserve-formatting
 734   0x00000100=use-auto-formatting
 735   0x00000200=show-error
 736   0x00000400=show-missing
 737   0x00000800=page-over-then-down
 738   0x00001000=multiple-page-items
 739   0x00002000=row-grand-totals
 740   0x00004000=col-grand-totals
 741   0x00008000=field-print-titles
 742   0x00020000=item-print-titles
 743   0x00040000=merge-labels
 744   0x00080000=has-data-caption
 745   0x00100000=has-grand-total-caption
 746   0x00200000=has-page-field-style
 747   0x00400000=has-pivot-table-style
 748   0x00800000=has-vacated-style
 749   0x01000000=apply-num-fmt
 750   0x02000000=apply-font
 751   0x04000000=apply-alignment
 752   0x08000000=apply-border
 753   0x10000000=apply-pattern
 754   0x20000000=protected
 755   0x40000000=has-tag
 756 end
 757
 758 flagslist=PTDEFINITION-FLAGS4
 759   0x00000001=compact
 760   0x00000002=outline
 761   0x00000004=outline-data
 762   0x00000008=compact-data
 763   0x00000010=no-grid-drop-zones
 764   0x00000020=published
 765   0x00000040=!has-error-caption
 766   0x00000080=!has-missing-caption
 767   0x00000100=immersive-off
 768   0x00000200=single-field-filters
 769   0x00000400=has-row-header-caption
 770   0x00000800=has-col-header-caption
 771   0x00001000=field-list-sort-asc
 772   0x00004000=no-custom-list-sort
 773 end
 774
 775 shortlist=PTDEFINITION-DATAFIELD-AXIS,1,row-axis,col-axis
 776
 777 constlist=PTDEFINITION-DATAFIELD-POS
 778   default=
 779   -1=append
 780 end
 781
 782 # PTFIELD --------------------------------------------------------------------
 783
 784 flagslist=PTFIELD-FLAGS1
 785   0x00000001=row
 786   0x00000002=col
 787   0x00000004=page
 788   0x00000008=data
 789   0x00000100=default
 790   0x00000200=sum
 791   0x00000400=count-all
 792   0x00000800=average
 793   0x00001000=max
 794   0x00002000=min
 795   0x00004000=product
 796   0x00008000=count-num
 797   0x00010000=std-dev
 798   0x00020000=std-dev-p
 799   0x00040000=variance
 800   0x00080000=variance-p
 801   0x01000000=drilled-level
 802   0x02000000=hide-dropdown
 803   0x04000000=hidden-level
 804   0x08000000=has-member-prop-caption
 805   0x10000000=compact
 806   0x20000000=has-display-name
 807   0x40000000=has-subtotal-caption
 808   0x80000000=source-ordered
 809 end
 810
 811 flagslist=PTFIELD-FLAGS2
 812   0x00000001=drag-to-row
 813   0x00000002=drag-to-col
 814   0x00000004=drag-to-page
 815   0x00000008=drag-to-hide
 816   0x00000010=drag-to-data
 817   0x00000020=show-all-items
 818   0x00000040=outline
 819   0x00000080=insert-blank-row
 820   0x00000100=subtotal-top
 821   0x00000200=server-based
 822   0x00000800=insert-page-break
 823   0x00001000=autosort
 824   0x00002000=ascend-sort
 825   0x00004000=autoshow
 826   0x00008000=autoshow-top
 827   0x00010000=hide-new-items
 828   0x00020000=has-value-filter
 829   0x00040000=exclude-new-items
 830   0x00080000=multiple-page-items
 831   0x00100000=simple-data-sort
 832   0x00200000=show-member-prop-report
 833   0x00400000=show-member-prop-tooltip
 834   0x00800000=show-member-prop-caption
 835   0x01000000=items-drilled
 836 end
 837
 838 # PTFILTER -------------------------------------------------------------------
 839
 840 multilist=PTFILTER-TYPE
 841   0=unknown,count,percent,sum,caption-equal,caption-not-equal,caption-begins-width,caption-not-begins-with,caption-ends-width,caption-not-ends-with
 842   10=caption-contains,caption-not-contains,caption-greater-than,caption-greater-equal,caption-less-than,caption-less-equal,caption-between,caption-not-between,value-equal,value-not-equal
 843   20=value-greater-than,value-greater-equal,value-less-than,value-less-equal,value-between,value-not-between,date-equal,date-older-than,date-newer-than,date-between
 844   30=date-tomorrow,date-today,date-yesterday,date-next-week,date-this-week,date-last-week,date-next-month,date-this-month,date-last-month,date-next-quarter
 845   40=date-this-quarter,date-last-quarter,date-next-year,date-this-year,date-last-year,year-to-date,date-q1,date-q2,date-q3,date-q4
 846   50=date-jan,date-feb,date-mar,date-apr,date-may,date-jun,date-jul,date-aug,date-sep,date-oct
 847   60=date-nov,date-dec,date-not-equal,date-older-equal,date-newer-equal,date-not-between
 848 end
 849
 850 flagslist=PTFILTER-FLAGS
 851   0x0001=has-name
 852   0x0002=has-description
 853   0x0004=has-str-value1
 854   0x0008=has-str-value2
 855 end
 856
 857 # PTFITEM --------------------------------------------------------------------
 858
 859 shortlist=PTFITEM-TYPE,0,data,default,sum,count-all,average,max,min,product,count-mumbers,std-dev,std-dev-p,var,var-p,grand-total,blank
 860
 861 flagslist=PTFITEM-FLAGS
 862   0x0001=hidden
 863   0x0002=hide-detail
 864   0x0004=calculated
 865   0x0008=missing
 866   0x0010=has-name
 867   0x0020=drilled-member
 868   0x0040=can-have-children
 869   0x0080=collapsed-member
 870   0x0100=olap-filter-selected
 871 end
 872
 873 # PTPAGEFIELD ----------------------------------------------------------------
 874
 875 constlist=PTPAGEFIELD-ITEM
 876   default=
 877   0x001000FE=mutiple-items
 878 end
 879
 880 flagslist=PTPAGEFIELD-FLAGS
 881   0x01=has-unique-name
 882   0x02=has-member-caption
 883 end
 884
 885 # PTREFERENCE ----------------------------------------------------------------
 886
 887 flagslist=PTREFERENCE-FLAGS1
 888   0x0001=data
 889   0x0002=default
 890   0x0004=sum
 891   0x0008=count-all
 892   0x0010=average
 893   0x0020=max
 894   0x0040=min
 895   0x0080=product
 896   0x0100=count-num
 897   0x0200=std-dev
 898   0x0400=std-dev-p
 899   0x0800=variance
 900   0x1000=variance-p
 901 end
 902
 903 flagslist=PTREFERENCE-FLAGS2
 904   0x01=selected
 905 end
 906
 907 # ROW ------------------------------------------------------------------------
 908
 909 combilist=ROW-FLAGS1
 910   0x0001=thick-top
 911   0x0002=thick-bottom
 912   0x0700=uint8,dec,outline-level
 913   0x0800=outline-collapsed
 914   0x1000=hidden
 915   0x2000=custom-height
 916   0x4000=custom-format
 917 end
 918
 919 flagslist=ROW-FLAGS2
 920   0x01=show-phonetic
 921 end
 922
 923 # SHEET ----------------------------------------------------------------------
 924
 925 shortlist=SHEET-STATE,0,visible,hidden,very-hidden
 926
 927 # SHEETCALCPR ----------------------------------------------------------------
 928
 929 flagslist=SHEETCALCPR-FLAGS
 930   0x01=calc-on-load
 931 end
 932
 933 # SHEETFORMATPR --------------------------------------------------------------
 934
 935 flagslist=SHEETFORMATPR-FLAGS
 936   0x0001=custom-row-height
 937   0x0002=rows-hidden
 938 end
 939
 940 # SHEETPR --------------------------------------------------------------------
 941
 942 flagslist=SHEETPR-FLAGS1
 943   0x0001=show-autopagebreaks
 944   0x0008=published
 945   0x0010=dialog-sheet
 946   0x0020=outline-auto-style
 947   0x0040=row-symbols-below
 948   0x0080=column-symbols-right
 949   0x0100=fit-to-pages
 950   0x0400=show-outline-symbols
 951   0x1000=is-row-synched
 952   0x2000=is-col-synched
 953   0x4000=lotus-formula-eval
 954   0x8000=lotus-formula-entry
 955 end
 956
 957 flagslist=SHEETPR-FLAGS2
 958   0x01=is-filtered
 959   0x02=eval-cond-formats
 960 end
 961
 962 # SHEETVIEW ------------------------------------------------------------------
 963
 964 flagslist=SHEETVIEW-FLAGS
 965   0x0001=window-protected
 966   0x0002=show-formulas
 967   0x0004=show-gridlines
 968   0x0008=show-headings
 969   0x0010=show-zeros
 970   0x0020=right-to-left
 971   0x0040=selected
 972   0x0080=show-ruler
 973   0x0100=show-outline-symbols
 974   0x0200=default-gridcolor
 975   0x0400=show-whitespace
 976 end
 977
 978 shortlist=SHEETVIEW-TYPE,0,normal,pagebreak-preview,page-layout
 979
 980 # TABLE ----------------------------------------------------------------------
 981
 982 shortlist=TABLE-TYPE,0,worksheet,,,query-table
 983
 984 flagslist=TABLE-FLAGS
 985   0x00000001=totals-row-shown
 986   0x00000002=published
 987   0x00000004=insert-row
 988   0x00000008=insert-row-shift
 989 end
 990
 991 # TABLESTYLEINFO -------------------------------------------------------------
 992
 993 flagslist=TABLESTYLEINFO-FLAGS
 994   0x0001=show-first-column
 995   0x0002=show-last-column
 996   0x0004=show-row-stripes
 997   0x0008=show-column-stripes
 998   0x0010=show-row-headers
 999   0x0020=show-column-headers
1000 end
1001
1002 # TOP10FILTER ----------------------------------------------------------------
1003
1004 flagslist=TOP10FILTER-FLAGS
1005   0x01=!bottom!top
1006   0x02=percent
1007   0x04=applied
1008 end
1009
1010 # VOLTYPE --------------------------------------------------------------------
1011
1012 shortlist=VOLTYPE-TYPE,0,realtime-data,olap-functions
1013
1014 # WORKBBOKPR -----------------------------------------------------------------
1015
1016 combilist=WORKBBOKPR-FLAGS
1017   0x00000001=date-1904
1018   0x00000004=hide-border-unsel-tables
1019   0x00000008=filter-privacy
1020   0x00000010=prompted-solutions
1021   0x00000020=show-ink-annotation
1022   0x00000040=backup-file
1023   0x00000080=strip-extlink-values
1024   0x00000300=uint8,dec,update-links,WORKBBOKPR-UPDATELINKS
1025   0x00000400=hide-pivot-fieldlist
1026   0x00000800=publish-items
1027   0x00001000=check-compatibility
1028   0x00006000=uint8,dec,show-objects,WORKBBOKPR-SHOWOBJECTS
1029   0x00008000=show-pivotchart-filter
1030   0x00010000=autocompress-pic
1031   0x00020000=refresh-all-links
1032 end
1033
1034 shortlist=WORKBBOKPR-UPDATELINKS,0,ask-user,never,always
1035 shortlist=WORKBBOKPR-SHOWOBJECTS,0,show,placeholder,hide
1036
1037 # WORKBOOKVIEW ---------------------------------------------------------------
1038
1039 flagslist=WORKBOOKVIEW-FLAGS
1040   0x01=hidden
1041   0x02=minimized
1042   0x08=show-horizontal-scroll
1043   0x10=show-vertical-scroll
1044   0x20=show-tabbar
1045   0x40=autofilter-date-grouping
1046 end
1047
1048 # XF -------------------------------------------------------------------------
1049
1050 shortlist=XF-HORALIGN,0,general,left,center,right,fill,block,center-across-sel,distribute
1051 shortlist=XF-VERALIGN,0,top,center,bottom,justify,distribute
1052 shortlist=XF-TEXTDIRECTION,0,context,left-to-right,right-to-left
1053
1054 combilist=XF-ALIGNMENT
1055   0x000000FF=uint8,dec,rotation,TEXTROTATION
1056   0x0000FF00=uint8,dec,indent
1057   0x00070000=uint8,dec,hor-align,XF-HORALIGN
1058   0x00380000=uint8,dec,ver-align,XF-VERALIGN
1059   0x00400000=text-wrap
1060   0x00800000=justify-lastline
1061   0x01000000=shrink-to-fit
1062   0x0C000000=uint8,dec,text-dir,XF-TEXTDIRECTION
1063   0x10000000=locked
1064   0x20000000=formula-hidden
1065   0x80000000=quote-prefix
1066 end
1067
1068 flagslist=XF-USEDFLAGS
1069   0x0001=format
1070   0x0002=font
1071   0x0004=alignment
1072   0x0008=border
1073   0x0010=fill
1074   0x0020=protection
1075 end
1076
1077 # ============================================================================
1078