xref: /aoo42x/main/oox/source/dump/xlsbdumper.ini (revision d71964d5)

# *************************************************************
#
#  Licensed to the Apache Software Foundation (ASF) under one
#  or more contributor license agreements.  See the NOTICE file
#  distributed with this work for additional information
#  regarding copyright ownership.  The ASF licenses this file
#  to you under the Apache License, Version 2.0 (the
#  "License"); you may not use this file except in compliance
#  with the License.  You may obtain a copy of the License at
#
#    http://www.apache.org/licenses/LICENSE-2.0
#
#  Unless required by applicable law or agreed to in writing,
#  software distributed under the License is distributed on an
#  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
#  KIND, either express or implied.  See the License for the
#  specific language governing permissions and limitations
#  under the License.
#
# *************************************************************

# dumper settings ============================================================

# Path to additional configuration data, relative to this file.
include-config-file=dumperbase.ini
include-config-file=oledumper.ini

# Enable entire dumper. This option does not affect the option 'enable-import'.
#   0=off, 1=on, missing = use setting from dumperbase.ini
# enable-dumper=1

# Enable import after dumping. Disabling this option allows to dump a file
# without loading it. This option is independent from the 'enable-dumper'
# option.
#   0=off, 1=on, missing = use setting from dumperbase.ini
# enable-import=1

# name lists =================================================================

# common ---------------------------------------------------------------------

unitconverter=CONV-TINT,/327.67,%
unitconverter=CONV-COLWIDTH,/256,chars

constlist=ERRORCODES
  0x00=#NULL!
  0x07=#DIV/0!
  0x0F=#VALUE!
  0x17=#REF!
  0x1D=#NAME?
  0x24=#NUM!
  0x2A=#N/A
end

flagslist=STRING-FLAGS
  0x01=rich-string
  0x02=phonetic-text
end

combilist=CELL-XFID
  0x00FFFFFF=int32,dec,xf-id
  0x01000000=show-phonetic
end

combilist=PHONETIC-FLAGS
  ignore=0x0030
  0x0003=uint8,dec,type,PHONETICPR-TYPE
  0x000C=uint8,dec,alignment,PHONETICPR-ALIGNMENT
end

shortlist=COLOR-TYPE,0,auto,indexed,rgb,theme

combilist=COLOR-FLAGS
  0x01=rgb-valid
  0xFE=uint8,dec,type,COLOR-TYPE
end

multilist=PALETTE-COLORS
  default=
  0=ega-black,ega-white,ega-red,ega-green,ega-blue,ega-yellow,ega-magenta,ega-cyan
  64=sys-window-text
  65=sys-window-bg
  67=sys-button-face
  77=sys-window-text-chart
  78=sys-window-bg-chart
  79=auto-border-chart
  80=sys-tooltip-bg
  81=sys-tooltip-text
end

constlist=TEXTROTATION
  default=
  255=stacked
end

multilist=BORDERSTYLES
  0=none,thin,medium,dash,dot
  5=thick,double,hair,medium-dash,thin-dash-dot
  10=medium-dash-dot,thin-dash-dot-dot,medium-dash-dot-dot,slant-dash-dot
end

multilist=FILLPATTERNS
  0=no-fill,solid-fill,50%-grey,75%-grey,25%-grey
  5=hor-stripe,ver-stripe,rev-diag-stripe,diag-stripe,diag-crosshatch
  10=thick-diag-crosshatch,thin-hor-stripe,thin-ver-stripe,thin-rev-diag-stripe,thin-diag-stripe
  15=thin-hor-crosshatch,thin-diag-crosshatch,12.5%-grey,6.25%-grey
  40=gradient
end

# formulas -------------------------------------------------------------------

flagslist=FORMULA-FLAGS
  0x0002=recalc-always
end

multilist=BASETOKENS
  0x00=,tExp,tTbl,tAdd,tSub,tMul,tDiv,tPower
  0x08=tConcat,tLT,tLE,tEQ,tGE,tGT,tNE,tIsect
  0x10=tList,tRange,tUplus,tUminus,tPercent,tParen,tMissArg,tStr
  0x18=tTable,tAttr,,,tErr,tBool,tInt,tNum
end

constlist=TOKENCLASSES
  0x20=R
  0x40=V
  0x60=A
end

multilist=CLASSTOKENS
  0x00=tArray,tFunc,tFuncVar,tName,tRef,tArea,tMemArea,tMemErr
  0x08=tMemNoMem,tMemFunc,tRefErr,tAreaErr,tRefN,tAreaN,tMemAreaN,tMemNoMemN
  0x18=,tNameX,tRef3d,tArea3d,tRefErr3d,tAreaErr3d
end

combilist=FUNCID
  0x7FFF=uint16,dec,func-id
  0x8000=command
end

combilist=PARAMCOUNT-CMD
  0x7F=uint8,dec,count
  0x80=prompt
end

combilist=REFRELFLAGS
  0x3FFF=uint16,dec,value
  0x4000=col-rel
  0x8000=row-rel
end

flagslist=TABLEFLAGS
  0x0001=single-column
  0x0002=column-range
  0x0004=#all
  0x0008=#headers
  0x0010=#data
  0x0020=#totals
  0x0040=#this-row
  0x0080=bracket-spaces
  0x0100=sep-spaces
  0x0200=single-row
  0x0400=single-cell
end

flagslist=ATTRTYPES
  0x01=volatile
  0x02=if
  0x04=choose
  0x08=skip
  0x10=sum
  0x20=assign
  0x40=space
  0x80=iferror
end

shortlist=ATTRSPACETYPES,0,space-before-token,cr-before-token,space-before-open,cr-before-open,space-before-close,cr-before-close,leading-space

shortlist=ARRAYVALUE-TYPE,0,number,string,boolean,,error

# record names ---------------------------------------------------------------

multilist=RECORD-NAMES
  0x0000=ROW,CELL_BLANK,CELL_RK,CELL_ERROR,CELL_BOOL,CELL_DOUBLE,CELL_STRING,CELL_SI
  0x0008=FORMULA_STRING,FORMULA_DOUBLE,FORMULA_BOOL,FORMULA_ERROR,MULTCELL_BLANK,MULTCELL_RK,MULTCELL_ERROR,MULTCELL_BOOL
  0x0010=MULTCELL_DOUBLE,MULTCELL_STRING,MULTCELL_SI,SI,PCITEM_MISSING,PCITEM_DOUBLE,PCITEM_BOOL,PCITEM_ERROR
  0x0018=PCITEM_STRING,PCITEM_DATE,PCITEM_INDEX,PCITEMA_MISSING,PCITEMA_DOUBLE,PCITEMA_BOOL,PCITEMA_ERROR,PCITEMA_STRING
  0x0020=PCITEMA_DATE,PCRECORD,PCRECORDDT,FRT,FRT_END,,,DEFINEDNAME
  0x0028=BINARYINDEXROWS,,BINARYINDEXBLOCK,FONT,NUMFMT,FILL,BORDER,XF
  0x0030=CELLSTYLE,,,,,,,
  0x0038=,,,,COL,MULTCELL_RSTRING,CELL_RSTRING,CALCCHAINCELL
  0x0040=DATAVALIDATION,,,,,,,

  0x0080=FILEVERSION,WORKSHEET,WORKSHEET_END,WORKBOOK,WORKBOOK_END,SHEETVIEWS,SHEETVIEWS_END,BOOKVIEWS
  0x0088=BOOKVIEWS_END,SHEETVIEW,SHEETVIEW_END,CHARTSHEETVIEWS,CHARTSHEETVIEWS_END,CHARTSHEETVIEW,CHARTSHEETVIEW_END,SHEETS
  0x0090=SHEETS_END,SHEETDATA,SHEETDATA_END,SHEETPR,DIMENSION,,,PANE
  0x0098=SELECTION,WORKBOOKPR,SMARTTAGPR,FILERECOVERYPR,SHEET,CALCPR,WORKBOOKVIEW,SST
  0x00A0=SST_END,AUTOFILTER,AUTOFILTER_END,FILTERCOLUMN,FILTERCOLUMN_END,DISCRETEFILTERS,DISCRETEFILTERS_END,DISCRETEFILTER
  0x00A8=COLORFILTER,ICONFILTER,TOP10FILTER,DYNAMICFILTER,CUSTOMFILTERS,CUSTOMFILTERS_END,CUSTOMFILTER,AFDATEGROUPITEM
  0x00B0=MERGECELL,MERGECELLS,MERGECELLS_END,PCDEFINITION,PCDEFINITION_END,PCDFIELDS,PCDFIELDS_END,PCDFIELD
  0x00B8=PCDFIELD_END,PCDSOURCE,PCDSOURCE_END,PCDSHEETSOURCE,PCDSHEETSOURCE_END,PCDFSHAREDITEMS,PCDFSHAREDITEMS_END,PCITEM_ARRAY
  0x00C0=PCITEM_ARRAY_END,PCRECORDS,PCRECORDS_END,,,,,
  0x00C8=,CONNECTION,CONNECTION_END,,,,,

  0x00D8=,,,PCDFIELDGROUP,PCDFIELDGROUP_END,PCDFGROUPITEMS,PCDFGROUPITEMS_END,PCDFRANGEPR
  0x00E0=PCDFRANGEPR_END,PCDFDISCRETEPR,PCDFDISCRETEPR_END,,,,,

  0x00F0=,,,,,,,PIVOTAREA
  0x00F8=PIVOTAREA_END,PTREFERENCES,PTREFERENCES_END,PTREFERENCE,PTREFERENCE_END,,,
  0x0100=,,,,,WEBPR,WEBPR_END,WEBPRTABLES
  0x0108=WEBPRTABLES_END,,,,,,,
  0x0110=,,,,,BINARYINDEX_END,STYLESHEET,STYLESHEET_END
  0x0118=PTDEFINITION,PTFITEM_END,PTFITEM,PTFITEMS,PTFITEMS_END,PTFIELD,PTFIELD_END,PTFIELDS
  0x0120=PTFIELDS_END,PTPAGEFIELD,PTPAGEFIELD_END,PTPAGEFIELDS,PTPAGEFIELDS_END,PTDATAFIELD,PTDATAFIELD_END,PTDATAFIELDS
  0x0128=PTDATAFIELDS_END,,,,,,,
  0x0130=,,,,,PTROWFIELDS,PTROWFIELDS_END,PTCOLFIELDS
  0x0138=PTCOLFIELDS_END,PTLOCATION_END,PTLOCATION,PTDEFINITION_END,,,,

  0x0150=,,,,,,,TABLE
  0x0158=TABLE_END,TABLECOLUMNS,TABLECOLUMNS_END,TABLECOLUMN,TABLECOLUMN_END,,,CALCEDCOLUMNFMLA
  0x0160=,EXTERNALREFS,EXTERNALREFS_END,EXTERNALREF,,EXTERNALSELF,EXTERNALSAME,EXTSHEETNAMES
  0x0168=EXTERNALBOOK,,EXTERNALSHEETS,EXTSHEETDATA,EXTSHEETDATA_END,,EXTROW,EXTCELL_BLANK
  0x0170=EXTCELL_DOUBLE,EXTCELL_BOOL,EXTCELL_ERROR,EXTCELL_STRING,,,,
  0x0178=,,,,,,PTREFERENCEITEM,PTREFERENCEITEM_END
  0x0180=PIVOTCACHES,PIVOTCACHES_END,PIVOTCACHE,PIVOTCACHE_END,,,COLS,COLS_END
  0x0188=ROWBREAKS,ROWBREAKS_END,COLBREAKS,COLBREAKS_END,BRK,CUSTOMWORKBOOKVIEW,,

  0x01A0=,,,,,,CUSTOMSHEETVIEWS,CUSTOMSHEETVIEW
  0x01A8=CUSTOMSHEETVIEW_END,CUSTOMSHEETVIEWS_END,ARRAY,SHAREDFMLA,DATATABLE,CONNECTIONS,CONNECTIONS_END,

  0x01B8=,,,,,,,QUERYTABLE
  0x01C0=QUERYTABLE_END,QUERYTABLEREFRESH,QUERYTABLEREFRESH_END,,,,,
  0x01C8=,,,AUTOSORTSCOPE,AUTOSORTSCOPE_END,CONDFORMATTING,CONDFORMATTING_END,CFRULE
  0x01D0=CFRULE_END,ICONSET,ICONSET_END,DATABAR,DATABAR_END,COLORSCALE,COLORSCALE_END,CFVO
  0x01D8=,COLORS,COLORS_END,RGBCOLOR,PAGEMARGINS,PRINTOPTIONS,PAGESETUP,HEADERFOOTER
  0x01E0=HEADERFOOTER_END,PTCHARTFORMAT,PTCHARTFORMAT_END,PTCHARTFORMATS,PTCHARTFORMATS_END,SHEETFORMATPR,,
  0x01E8=,,,,,,HYPERLINK,
  0x01F0=,,,,SCENARIOS,SCENARIOS_END,SCENARIO,SCENARIO_END
  0x01F8=INPUTCELLS,DXFS,DXFS_END,DXF,TABLESTYLES,TABLESTYLES_END,,
  0x0200=,TABLESTYLEINFO,VOLTYPES,VOLTYPES_END,VOLTYPE,VOLTYPE_END,VOLTYPEMAIN,VOLTYPEMAIN_END
  0x0208=VOLTYPETP,VOLTYPETP_END,VOLTYPESTP,VOLTYPETR,,VOLTYPE_ERROR,,
  0x0210=CALCCHAIN,CALCCHAIN_END,,,,,,SHEETPROTECTION
  0x0218=,PHONETICPR,,,,,,
  0x0220=,,,,,OLESIZE,DRAWING,LEGACYDRAWING

  0x0230=,,PICTURE,,CFCOLOR,INDEXEDCOLORS,INDEXEDCOLORS_END,
  0x0238=,MRUCOLORS,MRUCOLORS_END,,COLOR,DATAVALIDATIONS,DATAVALIDATIONS_END,
  0x0240=,EXTERNALNAME,DDEITEMVALUES,DDEITEMVALUES_END,DDEITEM_DOUBLE,DDEITEM_ERROR,DDEITEM_STRING,DDEITEM_EMPTY
  0x0248=DDEITEM_BOOL,EXTERNALNAMEREF,EXTERNALNAMEFLAGS,EXTERNALNAME_END,EXTERNALBOOK_END,,,
  0x0250=,,,,,,,PTFILTERS
  0x0258=PTFILTERS_END,PTFILTER,PTFILTER_END,FILLS,FILLS_END,,,
  0x0260=,,,FONTS,FONTS_END,BORDERS,BORDERS_END,NUMFMTS
  0x0268=NUMFMTS_END,CELLXFS,CELLXFS_END,CELLSTYLES,CELLSTYLES_END,,,
  0x0270=,,CELLSTYLEXFS,CELLSTYLEXFS_END,COMMENTS,COMMENTS_END,COMMENTAUTHORS,COMMENTAUTHORS_END
  0x0278=COMMENTAUTHOR,COMMENTLIST,COMMENTLIST_END,COMMENT,COMMENT_END,COMMENTTEXT,OLEOBJECTS,OLEOBJECT
  0x0280=OLEOBJECTS_END,,,CONTROLS,CONTROL,CONTROLS_END,,
  0x0288=,,,CHARTSHEETPR,CHARTPAGESETUP,CUSTOMCHARTVIEWS,CUSTOMCHARTVIEWS_END,CUSTOMCHARTVIEW
  0x0290=CUSTOMCHARTVIEW_END,,,,TABLEPARTS,TABLEPART,TABLEPARTS_END,SHEETCALCPR
  0x0298=FUNCTIONGROUPS,FUNCTIONGROUP,FUNCTIONGROUPS_END,EXTERNALADDIN,,CHARTPROTECTION,,
end

# simple records -------------------------------------------------------------

constlist=SIMPLE-RECORDS
  0x001A=int32,dec,item-index
  0x00AC=int32,dec,relation,CUSTOMFILTERS-RELATION
  0x00B5=int32,dec,count
  0x00C1=int32,dec,count
  0x00DD=int32,dec,count
  0x00E1=int32,dec,count
  0x00F9=int32,dec,count
  0x0107=int32,dec,count
  0x011B=int32,dec,count
  0x011F=int32,dec,count
  0x0123=int32,dec,count
  0x0159=int32,dec,count
  0x017E=int32,dec,item-index
  0x01DD=uint16,hex,flags,PRINTOPTIONS-FLAGS
  0x01E3=int32,dec,count
  0x01F9=int32,dec,count
  0x0204=int32,dec,type,VOLTYPE-TYPE
  0x020D=uint8,dec,error-code,ERRORCODES
  0x0244=double,dec,value
  0x0245=uint8,dec,error-code,ERRORCODES
  0x0248=uint8,dec,value,BOOLEAN
  0x0257=int32,dec,count
  0x025B=int32,dec,count
  0x0263=int32,dec,count
  0x0265=int32,dec,count
  0x0267=int32,dec,count
  0x0269=int32,dec,count
  0x026B=int32,dec,count
  0x0272=int32,dec,count
  0x0294=int32,dec,count
  0x0297=uint8,hex,flags,SHEETCALCPR-FLAGS
  0x0298=uint8,dec,builtin-count
end

# ARRAY ----------------------------------------------------------------------

flagslist=ARRAY-FLAGS
  ignore=0xFE
  0x01=recalc-always
end

# BORDER ---------------------------------------------------------------------

flagslist=BORDER-FLAGS
  0x01=diag-tl-to-br
  0x02=diag-bl-to-tr
end

# CALCPR ---------------------------------------------------------------------

shortlist=CALCPR-CALCMODE,0,manual,auto,auto-no-tables

flagslist=CALCPR-FLAGS
  0x0001=calc-on-load
  0x0002=a1
  0x0004=iterate
  0x0008=full-precision
  0x0010=calc-complete
  0x0020=calc-on-save
  0x0040=concurrent
  0x0080=manual-processors
  0x0100=force-full-calc
end

# CELLSTYLE ------------------------------------------------------------------

flagslist=CELLSTYLE-FLAGS
  0x0001=builtin
  0x0002=hidden
  0x0004=custom
end

multilist=CELLSTYLE-BUILTIN
  0=normal,rowlevel,collevel,comma,currency,percent,comma-0,currency-0,hyperlink,followed-hyperlink
  10=note,warning-text,,,,title,heading-1,heading-2,heading-3,heading-4
  20=input,output,calculation,check-cell,linked-cell,total,good,bad,neutral,accent1
  30=20%-accent1,40%-accent1,60%-accent1,accent2,20%-accent2,40%-accent2,60%-accent2,accent3,20%-accent3,40%-accent3
  40=60%-accent3,accent4,20%-accent4,40%-accent4,60%-accent4,accent5,20%-accent5,40%-accent5,60%-accent5,accent6
  50=20%-accent6,40%-accent6,60%-accent6,explanatory-text
end

# CFRULE ---------------------------------------------------------------------

shortlist=CFRULE-TYPE,1,cell-is,expression,color-scale,data-bar,top-ten,icon-set

multilist=CFRULE-SUBTYPE
  0=cell-is,expression,color-scale,data-bar,icon-set,top-ten,,unique-values,contains-text,contains-blanks
  10=not-contains-blanks,contains-errors,not-contains-errors,,,today,tomorrow,yesterday,last-7-days,last-month
  20=next-month,this-week,next-week,last-week,this-month,above-average,below-average,duplicate-values,,equal-above-average
  30=equal-below-average
end

shortlist=CFRULE-CELL-OPERATOR,1,between,not-between,equal,not-equal,greater-than,less-than,greater-equal,less-equal
shortlist=CFRULE-TEXT-OPERATOR,0,contains,not-contains,begins-with,ends-with
shortlist=CFRULE-DATE-OPERATOR,0,today,yesterday,last-7-days,this-week,last-week,last-month,tomorrow,next-week,next-month,this-month
shortlist=CFRULE-OTHER-OPERATOR,0,none

flagslist=CFRULE-FLAGS
  0x0001=table-row
  0x0002=stop-if-true
  0x0004=above-average
  0x0008=bottom
  0x0010=percent
end

# CHARTPAGESETUP ------------------------------------------------------------------

combilist=CHARTPAGESETUP-FLAGS
  0x0001=landscape
  0x0002=uninitialized
  0x0004=black-and-white
  0x0008=default-orientation
  0x0010=use-first-page
  0x0020=draft-quality
end

# CHARTSHEETPR ---------------------------------------------------------------

flagslist=CHARTSHEETPR-FLAGS
  0x0001=published
end

# CHARTSHEETVIEW -------------------------------------------------------------

flagslist=CHARTSHEETVIEW-FLAGS
  0x0001=selected
  0x0002=zoom-to-fit
end

# COL ------------------------------------------------------------------------

combilist=COL-FLAGS
  0x0001=hidden
  0x0002=custom-width
  0x0004=best-fit
  0x0008=show-phonetic
  0x0700=uint8,dec,outline-level
  0x1000=outline-collapsed
end

# CONNECTION -----------------------------------------------------------------

shortlist=CONNECTION-SAVEPASSWORD,1,on,off
unitconverter=CONNECTION-INTERVAL,60,sec
shortlist=CONNECTION-SOURCETYPE,1,odbc,dao,file,html,ole-db,text,ado,dsp
shortlist=CONNECTION-RECONNECTTYPE,1,as-required,always,never
shortlist=CONNECTION-CREDENTIALS,0,integrated,none,stored-sso,prompt

flagslist=CONNECTION-FLAGS
  0x0001=keep-alive
  0x0002=new
  0x0004=deleted
  0x0008=only-use-conn-file
  0x0010=background
  0x0020=refresh-on-load
  0x0040=save-data
end

flagslist=CONNECTION-STRINGFLAGS
  0x0001=has-source-file
  0x0002=has-source-conn-file
  0x0004=has-description
  0x0008=has-name
  0x0010=has-sso-id
end

# CUSTOMFILTER ---------------------------------------------------------------

constlist=CUSTOMFILTER-DATATYPE
  4=double
  6=string
  8=boolean
  12=blank
  14=not-blank
end

shortlist=CUSTOMFILTER-OPERATOR,1,less,equal,less-equal,greater,not-equal,greater-equal

# CUSTOMFILTERS --------------------------------------------------------------

shortlist=CUSTOMFILTERS-RELATION,0,and,or

# DATATABLE ------------------------------------------------------------------

flagslist=DATATABLE-FLAGS
  0x01=row-table
  0x02=table-2d
  0x04=ref1-deleted
  0x08=ref2-deleted
  0x10=recalc-always
end

# DATAVALIDATION -------------------------------------------------------------

combilist=DATAVALIDATION-FLAGS
  0x0000000F=uint8,dec,type,DATAVALIDATION-TYPE
  0x00000070=uint8,dec,error-style,DATAVALIDATION-ERRORSTYLE
  0x00000080=string-list
  0x00000100=ignore-empty
  0x00000200=no-dropdown
  0x00040000=show-input-box
  0x00080000=show-error-box
  0x00F00000=uint8,dec,operator,DATAVALIDATION-OPERATOR
end

shortlist=DATAVALIDATION-TYPE,0,any,whole,decimal,list,date,time,text-length,custom
shortlist=DATAVALIDATION-OPERATOR,0,between,not-between,equal,not-equal,greater-than,less-than,greater-equal,less-equal
shortlist=DATAVALIDATION-ERRORSTYLE,0,error,warning,info

# DATAVALIDATIONS ------------------------------------------------------------

combilist=DATAVALIDATIONS-FLAGS
  0x0001=disable-prompts
end

# DEFINEDNAME ----------------------------------------------------------------

combilist=DEFINEDNAME-FLAGS
  0x00000001=hidden
  0x00000002=function
  0x00000004=vba
  0x00000008=macro
  0x00000010=complex
  0x00000020=built-in
  0x00007FC0=int32,dec,func-group,DEFINEDNAME-FUNCGROUP
  0x00008000=published
  0x00010000=workbook-param
end

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

constlist=DEFINEDNAME-SHEETID
  default=
  -1=global
end

# DISCRETEFILTERS --------------------------------------------------------------------

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

# DXF ------------------------------------------------------------------------

flagslist=DXF-FLAGS
  0x00008000=border-outline
end

multilist=DXF-SUBREC
  0=FILL-PATTERN,FILL-FGCOLOR,FILL-BGCOLOR,FILL-GRADIENT,FILL-STOP
  5=FONT-COLOR,BORDER-TOP,BORDER-BOTTOM,BORDER-LEFT,BORDER-RIGHT
  10=BORDER-DIAGONAL,BORDER-VERTICAL,BORDER-HORIZONTAL,BORDER-DIAGUP,BORDER-DIAGDOWN
  15=ALIGN-HORIZONTAL,ALIGN-VERTICAL,ALIGN-ROTATION,ALIGN-INDENT,ALIGN-READINGORDER
  20=ALIGN-WRAPTEXT,ALIGN-JUSTLASTLINE,ALIGN-SHRINKTOFIT,,FONT-NAME
  25=FONT-WEIGHT,FONT-UNDERLINE,FONT-ESCAPEMENT,FONT-ITALIC,FONT-STRIKE
  30=FONT-OUTLINE,FONT-SHADOW,FONT-CONDENSE,FONT-EXTEND,FONT-CHARSET
  35=FONT-PITCHFAMILY,FONT-HEIGHT,FONT-SCHEME,NUMFMT-CODE,
  40=,NUMFMT-ID,ALIGN-RELINDENT,PROT-LOCKED,PROT-HIDDEN
end

# EXTERNALBOOK ---------------------------------------------------------------

shortlist=EXTERNALBOOK-TYPE,0,book,dde-link,ole-link

# EXTERNALNAMEFLAGS ----------------------------------------------------------

flagslist=EXTERNALNAMEFLAGS-FLAGS
  0x0002=automatic
  0x0004=pic-link
  0x0008=dde-stddocumentname
  0x0010=ole-link
  0x0020=iconified
end

# EXTERNALSHEETS -------------------------------------------------------------

constlist=EXTERNALSHEETS-ID
  default=
  -1=deleted
  -2=special
end

# EXTSHEETDATA ---------------------------------------------------------------

flagslist=EXTSHEETDATA-FLAGS
  0x01=refresh-error
end

# FILL -----------------------------------------------------------------------

shortlist=FILL-GRADIENTTYPE,0,linear,path

# FILTERCOLUMN ---------------------------------------------------------------

flagslist=FILTERCOLUMN-FLAGS
  0x0001=hidden-button
  0x0002=show-button
end

# FONT -----------------------------------------------------------------------

flagslist=FONT-FLAGS
  0x0001=bold
  0x0002=italic
  0x0004=underline
  0x0008=strikeout
  0x0010=outline
  0x0020=shadow
  0x0040=condense
  0x0080=extend
end

multilist=FONT-UNDERLINE
  0x00=none,single,double
  0x21=single-acc,double-acc
end

shortlist=FONT-SCHEME,0,none,major,minor
shortlist=FONT-ESCAPEMENT,0,none,superscript,subscript

# HEADERFOOTER ---------------------------------------------------------------

flagslist=HEADERFOOTER-FLAGS
  0x0001=diff-odd-even
  0x0002=diff-dirst
  0x0004=scale-with-doc
  0x0008=align-with-margins
end

# OLEOBJECT ------------------------------------------------------------------

shortlist=OLEOBJECT-ASPECT,1,content,,,icon
shortlist=OLEOBJECT-UPDATE,0,na,automatic,,manual

flagslist=OLEOBJECT-FLAGS
  0x0001=linked
  0x0002=auto-load
end

# PAGESETUP ------------------------------------------------------------------

multilist=PAGESETUP-PAPERSIZE
  0=undefined,letter,letter-small,tabloid,ledger,legal,statement,executive,a3,a4
  10=a4-small,a5,b4,b5,folio,quarto,10x14,11x17,note,envelope-9
  20=envelope-10,envelope-11,envelope-12,envelope-14,c,d,e,envelope-dl,envelope-c5,envelope-c3
  30=envelope-c4,envelope-c6,envelope-c65,envelope-b4,envelope-b5,envelope-b6,envelope-italy,envelope-monarch,envelope-6-3/4,us-standard-fanfold
  40=german-standard-fanfold,german-legal-fanfold,b4,japanese-dbl-postcaed,9x11,10x11,15x11,,
  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
  60=a4-plus,a5-transverse,jis-b5-transverse,a3-extra,a5-extra,b5-extra,a2,a3-transverse,a3-extra-transverse
end

constlist=PAGESETUP-SCALETOPAGES
  default=
  0=automatic
end

combilist=PAGESETUP-FLAGS
  0x0001=print-in-rows
  0x0002=landscape
  0x0004=uninitialized
  0x0008=black-and-white
  0x0010=draft-quality
  0x0020=print-notes
  0x0040=default-orientation
  0x0080=use-first-page
  0x0100=print-notes-at-end
  0x0600=uint8,dec,print-errors,PAGESETUP-PRINTERRORS
end

shortlist=PAGESETUP-PRINTERRORS,0,displayed,none,as-dashes,as-na

unitconverter=PAGESETUP-DPI,1,dpi

# PANE -----------------------------------------------------------------------

shortlist=PANE-ID,0,bottom-right,top-right,bottom-left,top-left

flagslist=PANE-FLAGS
  0x01=frozen
  0x02=remove-split-with-freeze
end

# PCDEFINITION ---------------------------------------------------------------

flagslist=PCDEFINITION-FLAGS1
  0x01=save-data
  0x02=invalid
  0x04=refresh-on-load
  0x08=optimize-memory
  0x10=enable-refresh
  0x20=background-query
  0x40=upgrade-on-refresh
  0x80=tupel-cache
end

constlist=PCDEFINITION-MISSINGITEMS
  default=
  -1=clear-automatic
  0=clear-always
end

flagslist=PCDEFINITION-FLAGS2
  0x01=has-username
  0x02=has-rel-id
  0x04=support-subquery
  0x08=support-drilldown
end

# PCDFIELD -------------------------------------------------------------------

flagslist=PCDFIELD-FLAGS
  0x0001=server-field
  0x0002=no-unique-items
  0x0004=database-field
  0x0008=has-caption
  0x0010=member-property-field
  0x0100=has-formula
  0x0200=has-property-name
end

# PCDFRANGEPR ----------------------------------------------------------------

shortlist=PCDFRANGEPR-GROUPBY,0,numeric,seconds,minutes,hours,days,months,quarters,years

flagslist=PCDFRANGEPR-FLAGS
  0x01=auto-start
  0x02=auto-end
  0x04=date-group
end

# PCDFSHAREDITEMS ------------------------------------------------------------

flagslist=PCDFSHAREDITEMS-FLAGS
  0x0001=has-semi-mixed-types
  0x0002=has-non-date
  0x0004=has-date
  0x0008=has-string-bool-err
  0x0010=has-blank
  0x0020=has-mixed-types
  0x0040=is-numeric
  0x0080=is-integer
  0x0100=has-min-max
  0x0200=long-text
end

# PCDSOURCE ------------------------------------------------------------------

shortlist=PCDSOURCE-TYPE,0,worksheet,external,consolidation,scenario

# PCDWORKSHEETSOURCE ---------------------------------------------------------

flagslist=PCDWORKSHEETSOURCE-FLAGS
  0x01=has-rel-id
  0x02=has-sheet
end

# PCITEM_ARRAY ---------------------------------------------------------------

constlist=PCITEM_ARRAY-TYPE
  0x0001=double
  0x0002=string
  0x0010=error
  0x0020=date
end

# PHONETICPR -----------------------------------------------------------------

shortlist=PHONETICPR-TYPE,0,halfwidth-katakana,fullwidth-katakana,hiragana,no-conversion
shortlist=PHONETICPR-ALIGNMENT,0,no-control,left,center,distributed

# PIVOTAREA ------------------------------------------------------------------

shortlist=PIVOTAREA-TYPE,0,none,normal,data,all,origin,button,top-right

flagslist=PIVOTAREA-FLAGS1
  0x01=data-only
  0x02=label-only
  0x04=grand-row
  0x08=grand-col
  0x10=cache-based
  0x20=line-mode
  0x40=part
  0x80=fuzzy
end

combilist=PIVOTAREA-FLAGS2
  0x0001=row
  0x0002=col
  0x0004=page
  0x0008=data
  0x0FF0=uint8,dec,pos-on-axis
end

# PRINTOPTIONS ---------------------------------------------------------------

flagslist=PRINTOPTIONS-FLAGS
  0x0001=horizontal-centered
  0x0002=vertical-centered
  0x0004=print-headings
  0x0008=print-gridlines
  0x0010=gridlines-set
end

# Pivot table globals --------------------------------------------------------

constlist=PT-FIELDINDEX
  default=
  -2=data-field
end

# PTDATAFIELD ----------------------------------------------------------------

shortlist=PTDATAFIELD-SUBTOTAL,0,sum,count-all,average,max,min,product,count-num,std-dev,std-dev-p,var,var-p
shortlist=PTDATAFIELD-SHOWDATAAS,0,normal,difference,percent,percent-diff,run-total,percent-of-row,percent-of-col,percent-of-total,index

constlist=PTDATAFIELD-BASEITEM
  default=
  0x001000FC=previous-item
  0x001000FD=next-item
end

# PTDEFINITION ---------------------------------------------------------------

flagslist=PTDEFINITION-FLAGS1
  0x01=show-items
  0x02=edit-data
  0x04=disable-field-list
  0x08=refresh-on-load
  0x10=hide-calc-members
  0x20=with-hidden-totals
  0x40=show-multiple-label
end

combilist=PTDEFINITION-FLAGS2
  0x0001=hide-data-drop-down
  0x0010=hide-drill
  0x0020=print-drill
  0x0040=show-member-prop-tips
  0x0080=hide-data-tips
  0x7F00=uint8,dec,indent
  0x8000=hide-headers
end

flagslist=PTDEFINITION-FLAGS3
  ignore=0x00010000
  0x00000001=hide-drop-zones
  0x00000002=no-asterisk-totals
  0x00000004=show-empty-row
  0x00000008=show-empty-col
  0x00000010=enable-wizard
  0x00000020=enable-drill
  0x00000040=enable-field-props
  0x00000080=preserve-formatting
  0x00000100=use-auto-formatting
  0x00000200=show-error
  0x00000400=show-missing
  0x00000800=page-over-then-down
  0x00001000=multiple-page-items
  0x00002000=row-grand-totals
  0x00004000=col-grand-totals
  0x00008000=field-print-titles
  0x00020000=item-print-titles
  0x00040000=merge-item
  0x00080000=has-data-caption
  0x00100000=has-grand-total-caption
  0x00200000=has-page-field-style
  0x00400000=has-pivot-table-style
  0x00800000=has-vacated-style
  0x01000000=apply-num-fmt
  0x02000000=apply-font
  0x04000000=apply-alignment
  0x08000000=apply-border
  0x10000000=apply-fill
  0x20000000=apply-protection
  0x40000000=has-tag
end

flagslist=PTDEFINITION-FLAGS4
  0x00000001=compact
  0x00000002=outline
  0x00000004=outline-data
  0x00000008=compact-data
  0x00000010=no-grid-drop-zones
  0x00000020=published
  0x00000040=!has-error-caption
  0x00000080=!has-missing-caption
  0x00000100=immersive-off
  0x00000200=single-field-filters
  0x00000400=has-row-header-caption
  0x00000800=has-col-header-caption
  0x00001000=field-list-sort-asc
  0x00004000=no-custom-list-sort
end

shortlist=PTDEFINITION-DATAFIELD-AXIS,1,row-axis,col-axis

constlist=PTDEFINITION-DATAFIELD-POS
  default=
  -1=append
end

# PTFIELD --------------------------------------------------------------------

flagslist=PTFIELD-FLAGS1
  0x00000001=row
  0x00000002=col
  0x00000004=page
  0x00000008=data
  0x00000100=default
  0x00000200=sum
  0x00000400=count-all
  0x00000800=average
  0x00001000=max
  0x00002000=min
  0x00004000=product
  0x00008000=count-num
  0x00010000=std-dev
  0x00020000=std-dev-p
  0x00040000=variance
  0x00080000=variance-p
  0x01000000=drilled-level
  0x02000000=hide-dropdown
  0x04000000=hidden-level
  0x08000000=has-member-prop-caption
  0x10000000=compact
  0x20000000=has-display-name
  0x40000000=has-subtotal-caption
  0x80000000=source-ordered
end

flagslist=PTFIELD-FLAGS2
  0x00000001=drag-to-row
  0x00000002=drag-to-col
  0x00000004=drag-to-page
  0x00000008=drag-to-hide
  0x00000010=drag-to-data
  0x00000020=show-all-items
  0x00000040=outline
  0x00000080=insert-blank-row
  0x00000100=subtotal-top
  0x00000200=server-based
  0x00000800=insert-page-break
  0x00001000=autosort
  0x00002000=ascend-sort
  0x00004000=autoshow
  0x00008000=autoshow-top
  0x00010000=hide-new-items
  0x00020000=has-value-filter
  0x00040000=exclude-new-items
  0x00080000=multiple-page-items
  0x00100000=simple-data-sort
  0x00200000=show-member-prop-report
  0x00400000=show-member-prop-tooltip
  0x00800000=show-member-prop-caption
  0x01000000=items-drilled
end

# PTFILTER -------------------------------------------------------------------

multilist=PTFILTER-TYPE
  0=unknown,count,percent,sum,caption-equal,caption-not-equal,caption-begins-width,caption-not-begins-with,caption-ends-width,caption-not-ends-with
  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
  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
  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
  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
  50=date-jan,date-feb,date-mar,date-apr,date-may,date-jun,date-jul,date-aug,date-sep,date-oct
  60=date-nov,date-dec,date-not-equal,date-older-equal,date-newer-equal,date-not-between
end

flagslist=PTFILTER-FLAGS
  0x0001=has-name
  0x0002=has-description
  0x0004=has-str-value1
  0x0008=has-str-value2
end

# PTFITEM --------------------------------------------------------------------

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

flagslist=PTFITEM-FLAGS
  0x0001=hidden
  0x0002=hide-detail
  0x0004=calculated
  0x0008=missing
  0x0010=has-name
  0x0020=drilled-member
  0x0040=can-have-children
  0x0080=collapsed-member
  0x0100=olap-filter-selected
end

# PTPAGEFIELD ----------------------------------------------------------------

constlist=PTPAGEFIELD-ITEM
  default=
  0x001000FE=mutiple-items
end

flagslist=PTPAGEFIELD-FLAGS
  0x01=has-unique-name
  0x02=has-member-caption
end

# PTREFERENCE ----------------------------------------------------------------

flagslist=PTREFERENCE-FLAGS1
  0x0001=data
  0x0002=default
  0x0004=sum
  0x0008=count-all
  0x0010=average
  0x0020=max
  0x0040=min
  0x0080=product
  0x0100=count-num
  0x0200=std-dev
  0x0400=std-dev-p
  0x0800=variance
  0x1000=variance-p
end

flagslist=PTREFERENCE-FLAGS2
  0x01=selected
end

# QUERYTABLE -----------------------------------------------------------------

combilist=QUERYTABLE-FLAGS
  0x00000001=headers
  0x00000002=row-numbers
  0x00000004=disable-refresh
  0x00000008=background
  0x00000010=first-background
  0x00000020=refresh-on-load
  0x000000C0=uint8,dec,grow-shrink,QUERYTABLE-GROWSHRINK
  0x00000100=fill-formulas
  0x00000200=save-data
  0x00000400=disable-edit
  0x00000800=preserve-formatting
  0x00001000=adjust-column-width
  0x00002000=intermediate
  0x00004000=apply-num-fmt
  0x00008000=apply-font
  0x00010000=apply-alignment
  0x00020000=apply-border
  0x00040000=apply-fill
  0x00080000=apply-protection
end

shortlist=QUERYTABLE-GROWSHRINK,0,insert-clear,insert-delete,overwrite-clear

# ROW ------------------------------------------------------------------------

combilist=ROW-FLAGS1
  0x0001=thick-top
  0x0002=thick-bottom
  0x0700=uint8,dec,outline-level
  0x0800=outline-collapsed
  0x1000=hidden
  0x2000=custom-height
  0x4000=custom-format
end

flagslist=ROW-FLAGS2
  0x01=show-phonetic
end

# SHEET ----------------------------------------------------------------------

shortlist=SHEET-STATE,0,visible,hidden,very-hidden

# SHEETCALCPR ----------------------------------------------------------------

flagslist=SHEETCALCPR-FLAGS
  0x01=calc-on-load
end

# SHEETFORMATPR --------------------------------------------------------------

flagslist=SHEETFORMATPR-FLAGS
  0x0001=custom-row-height
  0x0002=rows-hidden
end

# SHEETPR --------------------------------------------------------------------

flagslist=SHEETPR-FLAGS1
  0x0001=show-autopagebreaks
  0x0008=published
  0x0010=dialog-sheet
  0x0020=outline-auto-style
  0x0040=row-symbols-below
  0x0080=column-symbols-right
  0x0100=fit-to-pages
  0x0400=show-outline-symbols
  0x1000=is-row-synched
  0x2000=is-col-synched
  0x4000=lotus-formula-eval
  0x8000=lotus-formula-entry
end

flagslist=SHEETPR-FLAGS2
  0x01=is-filtered
  0x02=eval-cond-formats
end

# SHEETVIEW ------------------------------------------------------------------

flagslist=SHEETVIEW-FLAGS
  0x0001=window-protected
  0x0002=show-formulas
  0x0004=show-gridlines
  0x0008=show-headings
  0x0010=show-zeros
  0x0020=right-to-left
  0x0040=selected
  0x0080=show-ruler
  0x0100=show-outline-symbols
  0x0200=default-gridcolor
  0x0400=show-whitespace
end

shortlist=SHEETVIEW-TYPE,0,normal,pagebreak-preview,page-layout

# TABLE ----------------------------------------------------------------------

shortlist=TABLE-TYPE,0,worksheet,,,query-table

flagslist=TABLE-FLAGS
  0x00000001=totals-row-shown
  0x00000002=published
  0x00000004=insert-row
  0x00000008=insert-row-shift
end

# TABLESTYLEINFO -------------------------------------------------------------

flagslist=TABLESTYLEINFO-FLAGS
  0x0001=show-first-column
  0x0002=show-last-column
  0x0004=show-row-stripes
  0x0008=show-column-stripes
  0x0010=show-row-headers
  0x0020=show-column-headers
end

# TOP10FILTER ----------------------------------------------------------------

flagslist=TOP10FILTER-FLAGS
  0x01=!bottom!top
  0x02=percent
  0x04=applied
end

# VOLTYPE --------------------------------------------------------------------

shortlist=VOLTYPE-TYPE,0,realtime-data,olap-functions

# WEBPR ----------------------------------------------------------------------

combilist=WEBPR-FLAGS
  0x000000FF=uint8,dec,html-format,WEBPR-HTMLFORMAT
  0x00000100=xml
  0x00000200=source-data
  0x00000400=parse-pre
  0x00000800=consecutive-delimiters
  0x00001000=first-row
  0x00002000=xl97-created
  0x00004000=text-dates
  0x00008000=xl2000-refreshed
  0x00010000=html-tables
end

shortlist=WEBPR-HTMLFORMAT,0,none,rtf,all

flagslist=WEBPR-STRINGFLAGS
  0x01=has-post-method
  0x02=has-edit-page
  0x04=has-url
end

# WORKBBOKPR -----------------------------------------------------------------

combilist=WORKBBOKPR-FLAGS
  0x00000001=date-1904
  0x00000004=hide-border-unsel-tables
  0x00000008=filter-privacy
  0x00000010=prompted-solutions
  0x00000020=show-ink-annotation
  0x00000040=backup-file
  0x00000080=strip-extlink-values
  0x00000300=uint8,dec,update-links,WORKBBOKPR-UPDATELINKS
  0x00000400=hide-pivot-fieldlist
  0x00000800=publish-items
  0x00001000=check-compatibility
  0x00006000=uint8,dec,show-objects,WORKBBOKPR-SHOWOBJECTS
  0x00008000=show-pivotchart-filter
  0x00010000=autocompress-pic
  0x00020000=refresh-all-links
end

shortlist=WORKBBOKPR-UPDATELINKS,0,ask-user,never,always
shortlist=WORKBBOKPR-SHOWOBJECTS,0,show,placeholder,hide

# WORKBOOKVIEW ---------------------------------------------------------------

flagslist=WORKBOOKVIEW-FLAGS
  0x01=hidden
  0x02=minimized
  0x08=show-horizontal-scroll
  0x10=show-vertical-scroll
  0x20=show-tabbar
  0x40=autofilter-date-grouping
end

# XF -------------------------------------------------------------------------

shortlist=XF-HORALIGN,0,general,left,center,right,fill,block,center-across-sel,distribute
shortlist=XF-VERALIGN,0,top,center,bottom,justify,distribute
shortlist=XF-TEXTDIRECTION,0,context,left-to-right,right-to-left

combilist=XF-ALIGNMENT
  0x000000FF=uint8,dec,rotation,TEXTROTATION
  0x0000FF00=uint8,dec,indent
  0x00070000=uint8,dec,hor-align,XF-HORALIGN
  0x00380000=uint8,dec,ver-align,XF-VERALIGN
  0x00400000=text-wrap
  0x00800000=justify-lastline
  0x01000000=shrink-to-fit
  0x0C000000=uint8,dec,text-dir,XF-TEXTDIRECTION
  0x10000000=locked
  0x20000000=formula-hidden
  0x80000000=quote-prefix
end

flagslist=XF-USEDFLAGS
  0x0001=format
  0x0002=font
  0x0004=alignment
  0x0008=border
  0x0010=fill
  0x0020=protection
end

# ============================================================================