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,PTCHARTFORMAT,PTCHARTFORMAT_END,PTCHARTFORMATS,PTCHARTFORMATS_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   0x01E3=int32,dec,count
 253   0x01F9=int32,dec,count
 254   0x0204=int32,dec,type,VOLTYPE-TYPE
 255   0x020D=uint8,dec,error-code,ERRORCODES
 256   0x0244=double,dec,value
 257   0x0245=uint8,dec,error-code,ERRORCODES
 258   0x0248=uint8,dec,value,BOOLEAN
 259   0x0257=int32,dec,count
 260   0x025B=int32,dec,count
 261   0x0263=int32,dec,count
 262   0x0265=int32,dec,count
 263   0x0267=int32,dec,count
 264   0x0269=int32,dec,count
 265   0x026B=int32,dec,count
 266   0x0272=int32,dec,count
 267   0x0294=int32,dec,count
 268   0x0297=uint8,hex,flags,SHEETCALCPR-FLAGS
 269   0x0298=uint8,dec,builtin-count
 270 end
 271
 272 # ARRAY ----------------------------------------------------------------------
 273
 274 flagslist=ARRAY-FLAGS
 275   0x01=recalc-always
 276 end
 277
 278 # BORDER ---------------------------------------------------------------------
 279
 280 flagslist=BORDER-FLAGS
 281   0x01=diag-tl-to-br
 282   0x02=diag-bl-to-tr
 283 end
 284
 285 # CALCPR ---------------------------------------------------------------------
 286
 287 shortlist=CALCPR-CALCMODE,0,manual,auto,auto-no-tables
 288
 289 flagslist=CALCPR-FLAGS
 290   0x0001=calc-on-load
 291   0x0002=a1
 292   0x0004=iterate
 293   0x0008=full-precision
 294   0x0010=calc-complete
 295   0x0020=calc-on-save
 296   0x0040=concurrent
 297   0x0080=manual-processors
 298   0x0100=force-full-calc
 299 end
 300
 301 # CELLSTYLE ------------------------------------------------------------------
 302
 303 flagslist=CELLSTYLE-FLAGS
 304   0x0001=builtin
 305   0x0002=hidden
 306   0x0004=custom
 307 end
 308
 309 multilist=CELLSTYLE-BUILTIN
 310   0=normal,rowlevel,collevel,comma,currency,percent,comma-0,currency-0,hyperlink,followed-hyperlink
 311   10=note,warning-text,,,,title,heading-1,heading-2,heading-3,heading-4
 312   20=input,output,calculation,check-cell,linked-cell,total,good,bad,neutral,accent1
 313   30=20%-accent1,40%-accent1,60%-accent1,accent2,20%-accent2,40%-accent2,60%-accent2,accent3,20%-accent3,40%-accent3
 314   40=60%-accent3,accent4,20%-accent4,40%-accent4,60%-accent4,accent5,20%-accent5,40%-accent5,60%-accent5,accent6
 315   50=20%-accent6,40%-accent6,60%-accent6,explanatory-text
 316 end
 317
 318 # CFRULE ---------------------------------------------------------------------
 319
 320 shortlist=CFRULE-TYPE,1,cell-is,expression,color-scale,data-bar,top-ten,icon-set
 321
 322 multilist=CFRULE-SUBTYPE
 323   0=cell-is,expression,color-scale,data-bar,icon-set,top-ten,,unique-values,contains-text,contains-blanks
 324   10=not-contains-blanks,contains-errors,not-contains-errors,,,today,tomorrow,yesterday,last-7-days,last-month
 325   20=next-month,this-week,next-week,last-week,this-month,above-average,below-average,duplicate-values,,equal-above-average
 326   30=equal-below-average
 327 end
 328
 329 shortlist=CFRULE-CELL-OPERATOR,1,between,not-between,equal,not-equal,greater-than,less-than,greater-equal,less-equal
 330 shortlist=CFRULE-TEXT-OPERATOR,0,contains,not-contains,begins-with,ends-with
 331 shortlist=CFRULE-TIME-OPERATOR,0,today,yesterday,last-7-days,this-week,last-week,last-month,tomorrow,next-week,next-month,this-month
 332 shortlist=CFRULE-OTHER-OPERATOR,0,none
 333
 334 flagslist=CFRULE-FLAGS
 335   0x0001=table-row
 336   0x0002=stop-if-true
 337   0x0004=avove-average
 338   0x0008=bottom
 339   0x0010=percent
 340 end
 341
 342 # CHARTPAGESETUP ------------------------------------------------------------------
 343
 344 combilist=CHARTPAGESETUP-FLAGS
 345   0x0001=landscape
 346   0x0002=uninitialized
 347   0x0004=black-and-white
 348   0x0008=default-orientation
 349   0x0010=use-first-page
 350   0x0020=draft-quality
 351 end
 352
 353 # CHARTSHEETPR ---------------------------------------------------------------
 354
 355 flagslist=CHARTSHEETPR-FLAGS
 356   0x0001=published
 357 end
 358
 359 # CHARTSHEETVIEW -------------------------------------------------------------
 360
 361 flagslist=CHARTSHEETVIEW-FLAGS
 362   0x0001=selected
 363   0x0002=zoom-to-fit
 364 end
 365
 366 # COL ------------------------------------------------------------------------
 367
 368 combilist=COL-FLAGS
 369   0x0001=hidden
 370   0x0002=custom-width
 371   0x0004=best-fit
 372   0x0008=show-phonetic
 373   0x0700=uint8,dec,outline-level
 374   0x1000=outline-collapsed
 375 end
 376
 377 # DATATABLE ------------------------------------------------------------------
 378
 379 flagslist=DATATABLE-FLAGS
 380   0x01=row-table
 381   0x02=table-2d
 382   0x04=ref1-deleted
 383   0x08=ref2-deleted
 384   0x10=recalc-always
 385 end
 386
 387 # DATAVALIDATION -------------------------------------------------------------
 388
 389 combilist=DATAVALIDATION-FLAGS
 390   0x0000000F=uint8,dec,type,DATAVALIDATION-TYPE
 391   0x00000070=uint8,dec,error-style,DATAVALIDATION-ERRORSTYLE
 392   0x00000080=string-list
 393   0x00000100=ignore-empty
 394   0x00000200=no-dropdown
 395   0x00040000=show-input-box
 396   0x00080000=show-error-box
 397   0x00F00000=uint8,dec,operator,DATAVALIDATION-OPERATOR
 398 end
 399
 400 shortlist=DATAVALIDATION-TYPE,0,any,whole,decimal,list,date,time,text-length,custom
 401 shortlist=DATAVALIDATION-OPERATOR,0,between,not-between,equal,not-equal,greater-than,less-than,greater-equal,less-equal
 402 shortlist=DATAVALIDATION-ERRORSTYLE,0,error,warning,info
 403
 404 # DATAVALIDATIONS ------------------------------------------------------------
 405
 406 combilist=DATAVALIDATIONS-FLAGS
 407   0x0001=disable-prompts
 408 end
 409
 410 # DEFINEDNAME ----------------------------------------------------------------
 411
 412 combilist=DEFINEDNAME-FLAGS
 413   0x00000001=hidden
 414   0x00000002=function
 415   0x00000004=vba
 416   0x00000008=macro
 417   0x00000010=complex
 418   0x00000020=built-in
 419   0x00007FC0=int32,dec,func-group,DEFINEDNAME-FUNCGROUP
 420   0x00008000=published
 421   0x00010000=workbook-param
 422 end
 423
 424 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
 425
 426 constlist=DEFINEDNAME-SHEETID
 427   default=
 428   -1=global
 429 end
 430
 431 # DXF ------------------------------------------------------------------------
 432
 433 flagslist=DXF-FLAGS
 434   0x00008000=border-outline
 435 end
 436
 437 multilist=DXF-SUBREC
 438   0=FILL-PATTERN,FILL-FGCOLOR,FILL-BGCOLOR,FILL-GRADIENT,FILL-STOP
 439   5=FONT-COLOR,BORDER-TOP,BORDER-BOTTOM,BORDER-LEFT,BORDER-RIGHT
 440   10=BORDER-DIAGONAL,BORDER-VERTICAL,BORDER-HORIZONTAL,BORDER-DIAGUP,BORDER-DIAGDOWN
 441   15=ALIGN-HORIZONTAL,ALIGN-VERTICAL,ALIGN-ROTATION,ALIGN-INDENT,ALIGN-READINGORDER
 442   20=ALIGN-WRAPTEXT,ALIGN-JUSTLASTLINE,ALIGN-SHRINKTOFIT,,FONT-NAME
 443   25=FONT-WEIGHT,FONT-UNDERLINE,FONT-ESCAPEMENT,FONT-ITALIC,FONT-STRIKE
 444   30=FONT-OUTLINE,FONT-SHADOW,FONT-CONDENSE,FONT-EXTEND,FONT-CHARSET
 445   35=FONT-PITCHFAMILY,FONT-HEIGHT,FONT-SCHEME,NUMFMT-CODE,
 446   40=,NUMFMT-ID,ALIGN-RELINDENT,PROT-LOCKED,PROT-HIDDEN
 447 end
 448
 449 # EXTERNALBOOK ---------------------------------------------------------------
 450
 451 shortlist=EXTERNALBOOK-TYPE,0,book,dde-link,ole-link
 452
 453 # EXTERNALNAMEFLAGS ----------------------------------------------------------
 454
 455 flagslist=EXTERNALNAMEFLAGS-FLAGS
 456   0x0002=automatic
 457   0x0004=pic-link
 458   0x0008=dde-stddocumentname
 459   0x0010=ole-link
 460   0x0020=iconified
 461 end
 462
 463 # EXTERNALSHEETS -------------------------------------------------------------
 464
 465 constlist=EXTERNALSHEETS-ID
 466   default=
 467   -1=deleted
 468   -2=special
 469 end
 470
 471 # EXTSHEETDATA ---------------------------------------------------------------
 472
 473 flagslist=EXTSHEETDATA-FLAGS
 474   0x01=refresh-error
 475 end
 476
 477 # FILL -----------------------------------------------------------------------
 478
 479 shortlist=FILL-GRADIENTTYPE,0,linear,path
 480
 481 # FONT -----------------------------------------------------------------------
 482
 483 flagslist=FONT-FLAGS
 484   0x0001=bold
 485   0x0002=italic
 486   0x0004=underline
 487   0x0008=strikeout
 488   0x0010=outline
 489   0x0020=shadow
 490   0x0040=condense
 491   0x0080=extend
 492 end
 493
 494 multilist=FONT-UNDERLINE
 495   0x00=none,single,double
 496   0x21=single-acc,double-acc
 497 end
 498
 499 shortlist=FONT-SCHEME,0,none,major,minor
 500 shortlist=FONT-ESCAPEMENT,0,none,superscript,subscript
 501
 502 # HEADERFOOTER ---------------------------------------------------------------
 503
 504 flagslist=HEADERFOOTER-FLAGS
 505   0x0001=diff-odd-even
 506   0x0002=diff-dirst
 507   0x0004=scale-with-doc
 508   0x0008=align-with-margins
 509 end
 510
 511 # OLEOBJECT ------------------------------------------------------------------
 512
 513 shortlist=OLEOBJECT-ASPECT,1,content,,,icon
 514 shortlist=OLEOBJECT-UPDATE,0,na,automatic,,manual
 515
 516 flagslist=OLEOBJECT-FLAGS
 517   0x0001=linked
 518   0x0002=auto-load
 519 end
 520
 521 # PAGESETUP ------------------------------------------------------------------
 522
 523 multilist=PAGESETUP-PAPERSIZE
 524   0=undefined,letter,letter-small,tabloid,ledger,legal,statement,executive,a3,a4
 525   10=a4-small,a5,b4,b5,folio,quarto,10x14,11x17,note,envelope-9
 526   20=envelope-10,envelope-11,envelope-12,envelope-14,c,d,e,envelope-dl,envelope-c5,envelope-c3
 527   30=envelope-c4,envelope-c6,envelope-c65,envelope-b4,envelope-b5,envelope-b6,envelope-italy,envelope-monarch,envelope-6-3/4,us-standard-fanfold
 528   40=german-standard-fanfold,german-legal-fanfold,b4,japanese-dbl-postcaed,9x11,10x11,15x11,,
 529   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
 530   60=a4-plus,a5-transverse,jis-b5-transverse,a3-extra,a5-extra,b5-extra,a2,a3-transverse,a3-extra-transverse
 531 end
 532
 533 constlist=PAGESETUP-SCALETOPAGES
 534   default=
 535   0=automatic
 536 end
 537
 538 combilist=PAGESETUP-FLAGS
 539   0x0001=print-in-rows
 540   0x0002=landscape
 541   0x0004=uninitialized
 542   0x0008=black-and-white
 543   0x0010=draft-quality
 544   0x0020=print-notes
 545   0x0040=default-orientation
 546   0x0080=use-first-page
 547   0x0100=print-notes-at-end
 548   0x0600=uint8,dec,print-errors,PAGESETUP-PRINTERRORS
 549 end
 550
 551 shortlist=PAGESETUP-PRINTERRORS,0,displayed,none,as-dashes,as-na
 552
 553 unitconverter=PAGESETUP-DPI,1,dpi
 554
 555 # PANE -----------------------------------------------------------------------
 556
 557 shortlist=PANE-ID,0,bottom-right,top-right,bottom-left,top-left
 558
 559 flagslist=PANE-FLAGS
 560   0x01=frozen
 561   0x02=remove-split-with-freeze
 562 end
 563
 564 # PCDEFINITION ---------------------------------------------------------------
 565
 566 flagslist=PCDEFINITION-FLAGS1
 567   0x01=save-data
 568   0x02=invalid
 569   0x04=refresh-on-load
 570   0x08=optimize-memory
 571   0x10=enable-refresh
 572   0x20=background-query
 573   0x40=upgrade-on-refresh
 574   0x80=tupel-cache
 575 end
 576
 577 constlist=PCDEFINITION-MISSINGITEMS
 578   default=
 579   -1=clear-automatic
 580   0=clear-always
 581 end
 582
 583 flagslist=PCDEFINITION-FLAGS2
 584   0x01=has-username
 585   0x02=has-rel-id
 586   0x04=support-subquery
 587   0x08=support-drilldown
 588 end
 589
 590 # PCDFIELD -------------------------------------------------------------------
 591
 592 flagslist=PCDFIELD-FLAGS
 593   0x0001=server-field
 594   0x0002=no-unique-items
 595   0x0004=database-field
 596   0x0008=has-caption
 597   0x0010=member-property-field
 598   0x0100=has-formula
 599   0x0200=has-property-name
 600 end
 601
 602 # PCDFRANGEPR ----------------------------------------------------------------
 603
 604 shortlist=PCDFRANGEPR-GROUPBY,0,numeric,seconds,minutes,hours,days,months,quarters,years
 605
 606 flagslist=PCDFRANGEPR-FLAGS
 607   0x01=auto-start
 608   0x02=auto-end
 609   0x04=date-group
 610 end
 611
 612 # PCDFSHAREDITEMS ------------------------------------------------------------
 613
 614 flagslist=PCDFSHAREDITEMS-FLAGS
 615   0x0001=has-semi-mixed-types
 616   0x0002=has-non-date
 617   0x0004=has-date
 618   0x0008=has-string-bool-err
 619   0x0010=has-blank
 620   0x0020=has-mixed-types
 621   0x0040=is-numeric
 622   0x0080=is-integer
 623   0x0100=has-min-max
 624   0x0200=long-text
 625 end
 626
 627 # PCDSOURCE ------------------------------------------------------------------
 628
 629 shortlist=PCDSOURCE-TYPE,0,worksheet,external,consolidation,scenario
 630
 631 # PCDWORKSHEETSOURCE ---------------------------------------------------------
 632
 633 flagslist=PCDWORKSHEETSOURCE-FLAGS
 634   0x01=has-rel-id
 635   0x02=has-sheet
 636 end
 637
 638 # PCITEM_ARRAY ---------------------------------------------------------------
 639
 640 constlist=PCITEM_ARRAY-TYPE
 641   0x0001=double
 642   0x0002=string
 643   0x0010=error
 644   0x0020=date
 645 end
 646
 647 # PHONETICPR -----------------------------------------------------------------
 648
 649 shortlist=PHONETICPR-TYPE,0,halfwidth-katakana,fullwidth-katakana,hiragana,no-conversion
 650 shortlist=PHONETICPR-ALIGNMENT,0,no-control,left,center,distributed
 651
 652 # PIVOTAREA ------------------------------------------------------------------
 653
 654 shortlist=PIVOTAREA-TYPE,0,none,normal,data,all,origin,button,top-right
 655
 656 flagslist=PIVOTAREA-FLAGS1
 657   0x01=data-only
 658   0x02=label-only
 659   0x04=grand-row
 660   0x08=grand-col
 661   0x10=cache-based
 662   0x20=line-mode
 663   0x40=part
 664   0x80=fuzzy
 665 end
 666
 667 combilist=PIVOTAREA-FLAGS2
 668   0x0001=row
 669   0x0002=col
 670   0x0004=page
 671   0x0008=data
 672   0x0FF0=uint8,dec,pos-on-axis
 673 end
 674
 675 # PRINTOPTIONS ---------------------------------------------------------------
 676
 677 flagslist=PRINTOPTIONS-FLAGS
 678   0x0001=horizontal-centered
 679   0x0002=vertical-centered
 680   0x0004=print-headings
 681   0x0008=print-gridlines
 682   0x0010=gridlines-set
 683 end
 684
 685 # Pivot table globals --------------------------------------------------------
 686
 687 constlist=PT-FIELDINDEX
 688   default=
 689   -2=data-field
 690 end
 691
 692 # PTDATAFIELD ----------------------------------------------------------------
 693
 694 shortlist=PTDATAFIELD-SUBTOTAL,0,sum,count-all,average,max,min,product,count-num,std-dev,std-dev-p,var,var-p
 695 shortlist=PTDATAFIELD-SHOWDATAAS,0,normal,difference,percent,percent-diff,run-total,percent-of-row,percent-of-col,percent-of-total,index
 696
 697 constlist=PTDATAFIELD-BASEITEM
 698   default=
 699   0x001000FC=previous-item
 700   0x001000FD=next-item
 701 end
 702
 703 # PTDEFINITION ---------------------------------------------------------------
 704
 705 flagslist=PTDEFINITION-FLAGS1
 706   0x01=show-items
 707   0x02=edit-data
 708   0x04=disable-field-list
 709   0x08=refresh-on-load
 710   0x10=hide-calc-members
 711   0x20=with-hidden-totals
 712   0x40=show-multiple-label
 713 end
 714
 715 combilist=PTDEFINITION-FLAGS2
 716   0x0001=hide-data-drop-down
 717   0x0010=hide-drill
 718   0x0020=print-drill
 719   0x0040=show-member-prop-tips
 720   0x0080=hide-data-tips
 721   0x7F00=uint8,dec,indent
 722   0x8000=hide-headers
 723 end
 724
 725 flagslist=PTDEFINITION-FLAGS3
 726   ignore=0x00010000
 727   0x00000001=hide-drop-zones
 728   0x00000002=no-asterisk-totals
 729   0x00000004=show-empty-row
 730   0x00000008=show-empty-col
 731   0x00000010=enable-wizard
 732   0x00000020=enable-drill
 733   0x00000040=enable-field-props
 734   0x00000080=preserve-formatting
 735   0x00000100=use-auto-formatting
 736   0x00000200=show-error
 737   0x00000400=show-missing
 738   0x00000800=page-over-then-down
 739   0x00001000=multiple-page-items
 740   0x00002000=row-grand-totals
 741   0x00004000=col-grand-totals
 742   0x00008000=field-print-titles
 743   0x00020000=item-print-titles
 744   0x00040000=merge-labels
 745   0x00080000=has-data-caption
 746   0x00100000=has-grand-total-caption
 747   0x00200000=has-page-field-style
 748   0x00400000=has-pivot-table-style
 749   0x00800000=has-vacated-style
 750   0x01000000=apply-num-fmt
 751   0x02000000=apply-font
 752   0x04000000=apply-alignment
 753   0x08000000=apply-border
 754   0x10000000=apply-pattern
 755   0x20000000=protected
 756   0x40000000=has-tag
 757 end
 758
 759 flagslist=PTDEFINITION-FLAGS4
 760   0x00000001=compact
 761   0x00000002=outline
 762   0x00000004=outline-data
 763   0x00000008=compact-data
 764   0x00000010=no-grid-drop-zones
 765   0x00000020=published
 766   0x00000040=!has-error-caption
 767   0x00000080=!has-missing-caption
 768   0x00000100=immersive-off
 769   0x00000200=single-field-filters
 770   0x00000400=has-row-header-caption
 771   0x00000800=has-col-header-caption
 772   0x00001000=field-list-sort-asc
 773   0x00004000=no-custom-list-sort
 774 end
 775
 776 shortlist=PTDEFINITION-DATAFIELD-AXIS,1,row-axis,col-axis
 777
 778 constlist=PTDEFINITION-DATAFIELD-POS
 779   default=
 780   -1=append
 781 end
 782
 783 # PTFIELD --------------------------------------------------------------------
 784
 785 flagslist=PTFIELD-FLAGS1
 786   0x00000001=row
 787   0x00000002=col
 788   0x00000004=page
 789   0x00000008=data
 790   0x00000100=default
 791   0x00000200=sum
 792   0x00000400=count-all
 793   0x00000800=average
 794   0x00001000=max
 795   0x00002000=min
 796   0x00004000=product
 797   0x00008000=count-num
 798   0x00010000=std-dev
 799   0x00020000=std-dev-p
 800   0x00040000=variance
 801   0x00080000=variance-p
 802   0x01000000=drilled-level
 803   0x02000000=hide-dropdown
 804   0x04000000=hidden-level
 805   0x08000000=has-member-prop-caption
 806   0x10000000=compact
 807   0x20000000=has-display-name
 808   0x40000000=has-subtotal-caption
 809   0x80000000=source-ordered
 810 end
 811
 812 flagslist=PTFIELD-FLAGS2
 813   0x00000001=drag-to-row
 814   0x00000002=drag-to-col
 815   0x00000004=drag-to-page
 816   0x00000008=drag-to-hide
 817   0x00000010=drag-to-data
 818   0x00000020=show-all-items
 819   0x00000040=outline
 820   0x00000080=insert-blank-row
 821   0x00000100=subtotal-top
 822   0x00000200=server-based
 823   0x00000800=insert-page-break
 824   0x00001000=autosort
 825   0x00002000=ascend-sort
 826   0x00004000=autoshow
 827   0x00008000=autoshow-top
 828   0x00010000=hide-new-items
 829   0x00020000=has-value-filter
 830   0x00040000=exclude-new-items
 831   0x00080000=multiple-page-items
 832   0x00100000=simple-data-sort
 833   0x00200000=show-member-prop-report
 834   0x00400000=show-member-prop-tooltip
 835   0x00800000=show-member-prop-caption
 836   0x01000000=items-drilled
 837 end
 838
 839 # PTFILTER -------------------------------------------------------------------
 840
 841 multilist=PTFILTER-TYPE
 842   0=unknown,count,percent,sum,caption-equal,caption-not-equal,caption-begins-width,caption-not-begins-with,caption-ends-width,caption-not-ends-with
 843   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
 844   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
 845   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
 846   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
 847   50=date-jan,date-feb,date-mar,date-apr,date-may,date-jun,date-jul,date-aug,date-sep,date-oct
 848   60=date-nov,date-dec,date-not-equal,date-older-equal,date-newer-equal,date-not-between
 849 end
 850
 851 flagslist=PTFILTER-FLAGS
 852   0x0001=has-name
 853   0x0002=has-description
 854   0x0004=has-str-value1
 855   0x0008=has-str-value2
 856 end
 857
 858 # PTFITEM --------------------------------------------------------------------
 859
 860 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
 861
 862 flagslist=PTFITEM-FLAGS
 863   0x0001=hidden
 864   0x0002=hide-detail
 865   0x0004=calculated
 866   0x0008=missing
 867   0x0010=has-name
 868   0x0020=drilled-member
 869   0x0040=can-have-children
 870   0x0080=collapsed-member
 871   0x0100=olap-filter-selected
 872 end
 873
 874 # PTPAGEFIELD ----------------------------------------------------------------
 875
 876 constlist=PTPAGEFIELD-ITEM
 877   default=
 878   0x001000FE=mutiple-items
 879 end
 880
 881 flagslist=PTPAGEFIELD-FLAGS
 882   0x01=has-unique-name
 883   0x02=has-member-caption
 884 end
 885
 886 # PTREFERENCE ----------------------------------------------------------------
 887
 888 flagslist=PTREFERENCE-FLAGS1
 889   0x0001=data
 890   0x0002=default
 891   0x0004=sum
 892   0x0008=count-all
 893   0x0010=average
 894   0x0020=max
 895   0x0040=min
 896   0x0080=product
 897   0x0100=count-num
 898   0x0200=std-dev
 899   0x0400=std-dev-p
 900   0x0800=variance
 901   0x1000=variance-p
 902 end
 903
 904 flagslist=PTREFERENCE-FLAGS2
 905   0x01=selected
 906 end
 907
 908 # ROW ------------------------------------------------------------------------
 909
 910 combilist=ROW-FLAGS1
 911   0x0001=thick-top
 912   0x0002=thick-bottom
 913   0x0700=uint8,dec,outline-level
 914   0x0800=outline-collapsed
 915   0x1000=hidden
 916   0x2000=custom-height
 917   0x4000=custom-format
 918 end
 919
 920 flagslist=ROW-FLAGS2
 921   0x01=show-phonetic
 922 end
 923
 924 # SHEET ----------------------------------------------------------------------
 925
 926 shortlist=SHEET-STATE,0,visible,hidden,very-hidden
 927
 928 # SHEETCALCPR ----------------------------------------------------------------
 929
 930 flagslist=SHEETCALCPR-FLAGS
 931   0x01=calc-on-load
 932 end
 933
 934 # SHEETFORMATPR --------------------------------------------------------------
 935
 936 flagslist=SHEETFORMATPR-FLAGS
 937   0x0001=custom-row-height
 938   0x0002=rows-hidden
 939 end
 940
 941 # SHEETPR --------------------------------------------------------------------
 942
 943 flagslist=SHEETPR-FLAGS1
 944   0x0001=show-autopagebreaks
 945   0x0008=published
 946   0x0010=dialog-sheet
 947   0x0020=outline-auto-style
 948   0x0040=row-symbols-below
 949   0x0080=column-symbols-right
 950   0x0100=fit-to-pages
 951   0x0400=show-outline-symbols
 952   0x1000=is-row-synched
 953   0x2000=is-col-synched
 954   0x4000=lotus-formula-eval
 955   0x8000=lotus-formula-entry
 956 end
 957
 958 flagslist=SHEETPR-FLAGS2
 959   0x01=is-filtered
 960   0x02=eval-cond-formats
 961 end
 962
 963 # SHEETVIEW ------------------------------------------------------------------
 964
 965 flagslist=SHEETVIEW-FLAGS
 966   0x0001=window-protected
 967   0x0002=show-formulas
 968   0x0004=show-gridlines
 969   0x0008=show-headings
 970   0x0010=show-zeros
 971   0x0020=right-to-left
 972   0x0040=selected
 973   0x0080=show-ruler
 974   0x0100=show-outline-symbols
 975   0x0200=default-gridcolor
 976   0x0400=show-whitespace
 977 end
 978
 979 shortlist=SHEETVIEW-TYPE,0,normal,pagebreak-preview,page-layout
 980
 981 # TABLE ----------------------------------------------------------------------
 982
 983 shortlist=TABLE-TYPE,0,worksheet,,,query-table
 984
 985 flagslist=TABLE-FLAGS
 986   0x00000001=totals-row-shown
 987   0x00000002=published
 988   0x00000004=insert-row
 989   0x00000008=insert-row-shift
 990 end
 991
 992 # TABLESTYLEINFO -------------------------------------------------------------
 993
 994 flagslist=TABLESTYLEINFO-FLAGS
 995   0x0001=show-first-column
 996   0x0002=show-last-column
 997   0x0004=show-row-stripes
 998   0x0008=show-column-stripes
 999   0x0010=show-row-headers
1000   0x0020=show-column-headers
1001 end
1002
1003 # TOP10FILTER ----------------------------------------------------------------
1004
1005 flagslist=TOP10FILTER-FLAGS
1006   0x01=!bottom!top
1007   0x02=percent
1008   0x04=applied
1009 end
1010
1011 # VOLTYPE --------------------------------------------------------------------
1012
1013 shortlist=VOLTYPE-TYPE,0,realtime-data,olap-functions
1014
1015 # WORKBBOKPR -----------------------------------------------------------------
1016
1017 combilist=WORKBBOKPR-FLAGS
1018   0x00000001=date-1904
1019   0x00000004=hide-border-unsel-tables
1020   0x00000008=filter-privacy
1021   0x00000010=prompted-solutions
1022   0x00000020=show-ink-annotation
1023   0x00000040=backup-file
1024   0x00000080=strip-extlink-values
1025   0x00000300=uint8,dec,update-links,WORKBBOKPR-UPDATELINKS
1026   0x00000400=hide-pivot-fieldlist
1027   0x00000800=publish-items
1028   0x00001000=check-compatibility
1029   0x00006000=uint8,dec,show-objects,WORKBBOKPR-SHOWOBJECTS
1030   0x00008000=show-pivotchart-filter
1031   0x00010000=autocompress-pic
1032   0x00020000=refresh-all-links
1033 end
1034
1035 shortlist=WORKBBOKPR-UPDATELINKS,0,ask-user,never,always
1036 shortlist=WORKBBOKPR-SHOWOBJECTS,0,show,placeholder,hide
1037
1038 # WORKBOOKVIEW ---------------------------------------------------------------
1039
1040 flagslist=WORKBOOKVIEW-FLAGS
1041   0x01=hidden
1042   0x02=minimized
1043   0x08=show-horizontal-scroll
1044   0x10=show-vertical-scroll
1045   0x20=show-tabbar
1046   0x40=autofilter-date-grouping
1047 end
1048
1049 # XF -------------------------------------------------------------------------
1050
1051 shortlist=XF-HORALIGN,0,general,left,center,right,fill,block,center-across-sel,distribute
1052 shortlist=XF-VERALIGN,0,top,center,bottom,justify,distribute
1053 shortlist=XF-TEXTDIRECTION,0,context,left-to-right,right-to-left
1054
1055 combilist=XF-ALIGNMENT
1056   0x000000FF=uint8,dec,rotation,TEXTROTATION
1057   0x0000FF00=uint8,dec,indent
1058   0x00070000=uint8,dec,hor-align,XF-HORALIGN
1059   0x00380000=uint8,dec,ver-align,XF-VERALIGN
1060   0x00400000=text-wrap
1061   0x00800000=justify-lastline
1062   0x01000000=shrink-to-fit
1063   0x0C000000=uint8,dec,text-dir,XF-TEXTDIRECTION
1064   0x10000000=locked
1065   0x20000000=formula-hidden
1066   0x80000000=quote-prefix
1067 end
1068
1069 flagslist=XF-USEDFLAGS
1070   0x0001=format
1071   0x0002=font
1072   0x0004=alignment
1073   0x0008=border
1074   0x0010=fill
1075   0x0020=protection
1076 end
1077
1078 # ============================================================================
1079