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