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