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