| # ************************************************************* |
| # |
| # Licensed to the Apache Software Foundation (ASF) under one |
| # or more contributor license agreements. See the NOTICE file |
| # distributed with this work for additional information |
| # regarding copyright ownership. The ASF licenses this file |
| # to you under the Apache License, Version 2.0 (the |
| # "License"); you may not use this file except in compliance |
| # with the License. You may obtain a copy of the License at |
| # |
| # http://www.apache.org/licenses/LICENSE-2.0 |
| # |
| # Unless required by applicable law or agreed to in writing, |
| # software distributed under the License is distributed on an |
| # "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| # KIND, either express or implied. See the License for the |
| # specific language governing permissions and limitations |
| # under the License. |
| # |
| # ************************************************************* |
| |
| # dumper settings ============================================================ |
| |
| # Path to additional configuration data, relative to this file. |
| include-config-file=dumperbase.ini |
| include-config-file=dffdumper.ini |
| include-config-file=oledumper.ini |
| |
| # Enable entire dumper. This option does not affect the option 'enable-import'. |
| # 0=off, 1=on, missing = use setting from dumperbase.ini |
| # enable-dumper=1 |
| |
| # Enable import after dumping. Disabling this option allows to dump a file |
| # without loading it. This option is independent from the 'enable-dumper' |
| # option. |
| # 0=off, 1=on, missing = use setting from dumperbase.ini |
| # enable-import=1 |
| |
| # BIFF record settings ------------------------------------------------------- |
| |
| # Merge CONTINUE records with leading record (default=on). |
| # 0=off - show CONTINUE records separately (hex dump) |
| # 1=on - show contents of leading record together with following CONTINUE |
| merge-continue-record=1 |
| |
| # name lists ================================================================= |
| |
| # common --------------------------------------------------------------------- |
| |
| unitconverter=CONV-PERCENT-NEG,-1,% |
| unitconverter=CONV-COLWIDTH,/256,chars |
| unitconverter=CONV-TINT,/327.67,% |
| |
| shortlist=BIFF,0,biff2,biff3,biff4,biff5,biff8 |
| |
| constlist=ERRORCODES |
| 0x00=#NULL! |
| 0x07=#DIV/0! |
| 0x0F=#VALUE! |
| 0x17=#REF! |
| 0x1D=#NAME? |
| 0x24=#NUM! |
| 0x2A=#N/A |
| end |
| |
| shortlist=WINDOWS-PALETTE-0,0,black,white,red,green,blue,yellow,magenta,cyan |
| shortlist=WINDOWS-PALETTE-8,8,black,white,red,green,blue,yellow,magenta,cyan |
| shortlist=WINDOWS-PALETTE-16,16,dark-red,dark-green,dark-blue,dark-yellow,dark-magenta,dark-cyan,light-grey,dark-grey |
| |
| multilist=WINDOWS-SYSCOLORS-BIFF2 |
| 24=sys-window-text,sys-window-bg |
| 0x7FFF=sys-window-text |
| end |
| |
| multilist=WINDOWS-SYSCOLORS-BIFF5 |
| 64=sys-window-text,sys-window-bg,,sys-button-face |
| 77=sys-window-text-chart,sys-window-bg-chart,auto-border-chart,sys-tooltip-bg,sys-tooltip-text |
| 0x7FFF=sys-window-text |
| end |
| |
| constlist=COLORS-BIFF2 |
| include=WINDOWS-PALETTE-0 |
| include=WINDOWS-SYSCOLORS-BIFF2 |
| end |
| |
| constlist=COLORS-BIFF3 |
| include=WINDOWS-PALETTE-0 |
| include=WINDOWS-PALETTE-8 |
| include=WINDOWS-PALETTE-16 |
| include=WINDOWS-SYSCOLORS-BIFF2 |
| end |
| |
| multilist=COLORS-BIFF5 |
| include=WINDOWS-PALETTE-0 |
| include=WINDOWS-PALETTE-8 |
| include=WINDOWS-PALETTE-16 |
| 24=0x8080FF,0x802060,0xFFFFC0,0xA0E0E0,0x600080,0xFF8080,0x0080C0,0xC0C0FF |
| 32=0x000080,0xFF00FF,0xFFFF00,0x00FFFF,0x800080,0x800000,0x008080,0x0000FF |
| 40=0x00CFFF,0x69FFFF,0xE0FFE0,0xFFFF80,0xA6CAF0,0xDD9CB3,0xB38FEE,0xE3E3E3 |
| 48=0x2A6FF9,0x3FB8CD,0x488436,0x958C41,0x8E5E42,0xA0627A,0x624FAC,0x969696 |
| 56=0x1D2FBE,0x286676,0x004500,0x453E01,0x6A2813,0x85396A,0x4A3285,0x424242 |
| include=WINDOWS-SYSCOLORS-BIFF5 |
| end |
| |
| multilist=COLORS-BIFF8 |
| include=WINDOWS-PALETTE-0 |
| include=WINDOWS-PALETTE-8 |
| include=WINDOWS-PALETTE-16 |
| 24=0x9999FF,0x993366,0xFFFFCC,0xCCFFFF,0x660066,0xFF8080,0x0066CC,0xCCCCFF |
| 32=0x000080,0xFF00FF,0xFFFF00,0x00FFFF,0x800080,0x800000,0x008080,0x0000FF |
| 40=0x00CCFF,0xCCFFFF,0xCCFFCC,0xFFFF99,0x99CCFF,0xFF99CC,0xCC99FF,0xFFCC99 |
| 48=0x3366FF,0x33CCCC,0x99CC00,0xFFCC00,0xFF9900,0xFF6600,0x666699,0x969696 |
| 56=0x003366,0x339966,0x003300,0x333300,0x993300,0x993366,0x333399,0x333333 |
| include=WINDOWS-SYSCOLORS-BIFF5 |
| end |
| |
| shortlist=BORDERSTYLES-BIFF3,0,none,thin,medium,dash,dot,thick,double,hair |
| |
| multilist=BORDERSTYLES-BIFF8 |
| include=BORDERSTYLES-BIFF3 |
| 8=medium-dash,thin-dash-dot,medium-dash-dot,thin-dash-dot-dot,medium-dash-dot-dot,slant-dash-dot |
| end |
| |
| multilist=FILLPATTERNS-BIFF3 |
| 0=no-fill,solid-fill,50%-grey,75%-grey,25%-grey |
| 5=hor-stripe,ver-stripe,rev-diag-stripe,diag-stripe,diag-crosshatch |
| 10=thick-diag-crosshatch,thin-hor-stripe,thin-ver-stripe,thin-rev-diag-stripe,thin-diag-stripe |
| 15=thin-hor-crosshatch,thin-diag-crosshatch,12.5%-grey,6.25%-grey |
| end |
| |
| shortlist=TEXTORIENTATION,0,horizontal,stacked,90°-ccw,90°-cw |
| |
| constlist=TEXTROTATION-BIFF8 |
| default= |
| 255=stacked |
| end |
| |
| multilist=BUILTIN-FORMATS |
| quote-names=1 |
| 0=General,0,0.00,'#,##0','#,##0.00' |
| 5='"$"#,##0_);\("$"#,##0\)','"$"#,##0_);[Red]\("$"#,##0\)','"$"#,##0.00_);\("$"#,##0.00\)','"$"#,##0.00_);[Red]\("$"#,##0.00\)',0% |
| 10=0.00%,0.00E+00,# ?/?,# ??/??,M/D/YYYY |
| 15=D-MMM-YY,D-MMM,MMM-YY,h:mm AM/PM,h:mm:ss AM/PM |
| 20=h:mm,h:mm:ss,M/D/YYYY h:mm,General,General |
| 25=General,General,M/D/YYYY,M/D/YYYY,M/D/YYYY |
| 30=M/D/YYYY,M/D/YYYY,h:mm:ss,h:mm:ss,h:mm:ss |
| 35=h:mm:ss,M/D/YYYY,'#,##0_);(#,##0)','#,##0_);[Red](#,##0)','#,##0.00_);(#,##0.00)' |
| 40='#,##0.00_);[Red](#,##0.00)' |
| 41='_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)' |
| 42='_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_)' |
| 43='_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)' |
| 44='_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)' |
| 45=mm:ss,[h]:mm:ss,mm:ss.0,##0.0E+0,@ |
| 50=M/D/YYYY,M/D/YYYY,M/D/YYYY,M/D/YYYY,M/D/YYYY |
| 55=M/D/YYYY,M/D/YYYY,M/D/YYYY,M/D/YYYY,0 |
| 60=0.00,'#,##0','#,##0.00','$#,##0_);($#,##0)','$#,##0_);[Red]($#,##0)' |
| 65='$#,##0.00_);($#,##0.00)','$#,##0.00_);[Red]($#,##0.00)',0%,0.00%,# ?/? |
| 70=# ??/??,M/D/YYYY,M/D/YYYY,D-MMM-YY,D-MMM |
| 75=MMM-YY,h:mm,h:mm:ss,M/D/YYYY h:mm,mm:ss |
| 80=[h]:mm:ss,mm:ss.0 |
| end |
| |
| constlist=CONSTVALUE-TYPE |
| 0=empty |
| 1=number |
| 2=string |
| 4=boolean |
| 16=error |
| end |
| |
| constlist=PIVOT-NAMELEN |
| default= |
| 0xFFFF=name-in-cache |
| end |
| |
| flagslist=FR-FLAGS |
| 0x0001=has-ref |
| 0x0002=alert-unsupported |
| end |
| |
| shortlist=EXTCOLOR-TYPE,0,auto,indexed,rgb,theme,n/a |
| |
| combilist=EXTCOLOR-FLAGS |
| 0x01=rgb-valid |
| 0xFE=uint8,dec,type,EXTCOLOR-TYPE |
| end |
| |
| shortlist=EXTGRADIENT-TYPE,0,linear,path |
| |
| shortlist=EXTFONT-SCHEME,-1,n/a,none,major,minor |
| |
| # DFF ------------------------------------------------------------------------ |
| |
| flagslist=DFF-CLIENTANCHOR-FLAGS |
| 0x0001=pos-locked |
| 0x0002=size-locked |
| end |
| |
| # formulas ------------------------------------------------------------------- |
| |
| multilist=BASETOKENS-BIFF2 |
| 0x00=,tExp,tTbl,tAdd,tSub,tMul,tDiv,tPower |
| 0x08=tConcat,tLT,tLE,tEQ,tGE,tGT,tNE,tIsect |
| 0x10=tList,tRange,tUplus,tUminus,tPercent,tParen,tMissArg,tStr |
| 0x18=,tAttr,tSheet,tEndSheet,tErr,tBool,tInt,tNum |
| end |
| |
| constlist=BASETOKENS-BIFF5 |
| include=BASETOKENS-BIFF2 |
| exclude=0x1A,0x1B |
| end |
| |
| constlist=BASETOKENS-BIFF8 |
| include=BASETOKENS-BIFF5 |
| 0x18=tNlr |
| end |
| |
| constlist=TOKENCLASSES |
| 0x20=R |
| 0x40=V |
| 0x60=A |
| end |
| |
| multilist=CLASSTOKENS-BIFF2 |
| 0x00=tArray,tFunc,tFuncVar,tName,tRef,tArea,tMemArea,tMemErr |
| 0x08=tMemNoMem,tMemFunc,tRefErr,tAreaErr,tRefN,tAreaN,tMemAreaN,tMemNoMemN |
| 0x18=tFuncCE |
| end |
| |
| constlist=CLASSTOKENS-BIFF4 |
| include=CLASSTOKENS-BIFF2 |
| exclude=0x18 |
| end |
| |
| multilist=CLASSTOKENS-BIFF5 |
| include=CLASSTOKENS-BIFF4 |
| 0x19=tNameX,tRef3d,tArea3d,tRefErr3d,tAreaErr3d |
| end |
| |
| combilist=FUNCID |
| 0x7FFF=uint16,dec,func-id |
| 0x8000=command |
| end |
| |
| combilist=PARAMCOUNT-CMD |
| 0x7F=uint8,dec,count |
| 0x80=prompt |
| end |
| |
| combilist=REFRELFLAGS |
| 0x3FFF=uint16,dec,value |
| 0x4000=col-rel |
| 0x8000=row-rel |
| end |
| |
| multilist=NLRTYPES |
| 0x00=,tNlrErr,tNlrRowR,tNlrColR,,,tNlrRowV,tNlrColV |
| 0x08=,,tNlrRange,tNlrSRange,tNlrSRowR,tNlrSColR,tNlrSRowV,tNlrSColV |
| 0x10=tNlrRangeErr,,,,,,, |
| 0x18=,,,,,tNlrSxName,, |
| end |
| |
| combilist=NLRADDFLAGS |
| 0x3FFFFFFF=uint32,dec,count |
| 0x80000000=rel |
| end |
| |
| flagslist=ATTRTYPES |
| 0x00=skip |
| 0x01=volatile |
| 0x02=if |
| 0x04=choose |
| 0x08=skip |
| 0x10=sum |
| 0x20=assign |
| 0x40=space |
| end |
| |
| shortlist=ATTRSPACETYPES,0,space-before-token,cr-before-token,space-before-open,cr-before-open,space-before-close,cr-before-close,leading-space |
| |
| # record names --------------------------------------------------------------- |
| |
| multilist=RECORD-NAMES-BIFF2 |
| # worksheet records |
| 0x0000=DIMENSION,BLANK,INTEGER,NUMBER,LABEL,BOOLERR,FORMULA,STRING |
| 0x0008=ROW,BOF,EOF,INDEX,CALCCOUNT,CALCMODE,PRECISION,REFMODE |
| 0x0010=DELTA,ITERATION,PROTECT,PASSWORD,HEADER,FOOTER,EXTERNCOUNT,EXTERNSHEET |
| 0x0018=DEFINEDNAME,WINDOWPROTECT,VERTICALPAGEBREAKS,HORIZONTALPAGEBREAKS,NOTE,SELECTION,FORMAT,BUILTINFMTCOUNT |
| 0x0020=COLUMNDEFAULT,ARRAY,DATEMODE,EXTERNALNAME,COLWIDTH,DEFAULTROWHEIGHT,LEFTMARGIN,RIGHTMARGIN |
| 0x0028=TOPMARGIN,BOTTOMMARGIN,PRINTHEADERS,PRINTGRIDLINES,,,,FILEPASS |
| 0x0030=,FONT,FONT2,PRINTSIZE,,INFOOPTS,DATATABLE,DATATABLE2 |
| 0x0038=WNDESK,,BEGINPREF,ENDPREF,CONTINUE,WINDOW1,WINDOW2, |
| 0x0040=BACKUP,PANE,CODEPAGE,XF,IXFE,EFONT,SHOWSCROLL,SHOWFORMULA |
| 0x0048=STATUSBAR,SHORTMENUS,DDEENABLED,AUTODEC,MENUKEY,PLS|ZOOM,MENUUND,MOVESEL |
| 0x0050=DCON,DCONREF,DCONNAME,,,DEFCOLWIDTH,, |
| # worksheet records new in BIFF3, but supported in BIFF2 streams |
| 0x0200=DIMENSION,BLANK,,NUMBER,LABEL,BOOLERR,, |
| 0x0208=,,,INDEX,,,, |
| 0x027E=RK |
| # BIFF5 style BOF |
| 0x0809=BOF |
| # chart records |
| 0x1000=,CHUNITS,CHCHART,CHSERIES,CHSOURCELINK,,CHDATAFORMAT,CHLINEFORMAT |
| 0x1008=,CHMARKERFORMAT,CHAREAFORMAT,CHPIEFORMAT,CHATTACHEDLABEL,CHSTRING,, |
| 0x1010=,,,,CHTYPEGROUP,CHLEGEND,CHSERIESLIST,CHBAR |
| 0x1018=CHLINE,CHPIE,CHAREA,CHSCATTER,CHCHARTLINE,CHAXIS,CHTICK,CHVALUERANGE |
| 0x1020=CHLABELRANGE,CHAXISLINE,CHFORMATLINK,,CHDEFAULTTEXT,CHTEXT,CHFONT,CHOBJECTLINK |
| 0x1028=,,,,,CHARROW,,CHARROWHEAD |
| 0x1030=,,CHFRAME,CHBEGIN,CHEND,CHPLOTFRAME,CHCHARTSIZE,CHRELPOSITION |
| 0x1038=CHARROWRELPOS,,CHCHART3D,,,,, |
| end |
| |
| multilist=RECORD-NAMES-BIFF3 |
| include=RECORD-NAMES-BIFF2 |
| # worksheet records |
| exclude=0x0006,0x0008,0x0009,0x000B,0x0018,0x0020,0x0023,0x0024,0x0025,0x0031,0x0036,0x0037,0x003E,0x0043,0x0044,0x0045 |
| 0x0050=,,,,,,BUILTINFMTCOUNT, |
| 0x0058=TOOLBAR,XCT,CRN,FILESHARING,WRITEACCESS,OBJ,UNCALCED,SAFERECALC |
| 0x0060=TEMPLATE,INTL,,OBJECTPROTECT,,,, |
| 0x0068=,,,,,,, |
| 0x0070=,,,,,,, |
| 0x0078=,,,,,COLINFO,,IMGDATA |
| 0x0080=GUTS,SHEETPR,GRIDSET,HCENTER,VCENTER,,WRITEPROT,ADDIN |
| 0x0088=EDG,PUB,NOTEOFF,LH,COUNTRY,HIDEOBJ,, |
| 0x0090=SORT,SUB,PALETTE,,LHRECORD,LHNGRAPH,, |
| 0x0200=,,,,,,FORMULA,STRING |
| 0x0208=ROW,BOF,,,,,, |
| 0x0218=DEFINEDNAME |
| 0x0221=ARRAY |
| 0x0223=EXTERNALNAME |
| 0x0225=DEFAULTROWHEIGHT |
| 0x0231=FONT |
| 0x0236=DATATABLE |
| 0x023E=WINDOW2 |
| 0x0243=XF |
| 0x0293=STYLE |
| # chart records |
| 0x103C=CHPICFORMAT |
| end |
| |
| multilist=RECORD-NAMES-BIFF4 |
| include=RECORD-NAMES-BIFF3 |
| # worksheet/workbook records |
| exclude=0x0206,0x0209,0x001E,0x0243 |
| 0x0085=SHEET |
| 0x0088=,,,,,,SHEETSOFFSET,SHEETHEADER |
| 0x0090=,,,,,,NOTESOUND,SYNC |
| 0x0098=LPR,STANDARDWIDTH,FNGROUPNAME,,FNGROUPCOUNT,,, |
| 0x00A0=SCL,PAGESETUP,FNPROTO,PROJEXTSHEET,,,, |
| 0x00A8=DRAGDROP,COORDLIST,,GCW,,,, |
| 0x0406=FORMULA |
| 0x0409=BOF |
| 0x041E=FORMAT |
| 0x0443=XF |
| # chart records |
| 0x1038=,,,CHMULTILINK,,CHDROPBAR,CHRADARLINE,CHSURFACE |
| end |
| |
| multilist=RECORD-NAMES-BIFF5 |
| include=RECORD-NAMES-BIFF4 |
| # worksheet/workbook records |
| exclude=0x0409,0x0218,0x0223,0x0231,0x0443 |
| 0x0006=FORMULA |
| 0x0018=DEFINEDNAME |
| 0x0023=EXTERNALNAME |
| 0x0031=FONT |
| 0x0098=,,,FILTERMODE,,AUTOFILTER,FILTERCOLUMN, |
| 0x00A8=,,,,,,SCENARIOS,SCENARIO |
| 0x00B0=PTDEFINITION,PTFIELD,PTFITEM,,PTROWCOLFIELDS,PTROWCOLITEMS,PTPAGEFIELDS, |
| 0x00B8=DOCROUTE,RECIPNAME,,,,MULTRK,MULTBLANK,TOOLBARHDR |
| 0x00C0=TOOLBAREND,MMS,ADDMENU,DELMENU,,PTDATAFIELD,PCDEFINITION,PCDFIELD |
| 0x00C8=PCITEM_INDEXLIST,PCITEM_DOUBLE,PCITEM_BOOL,PCITEM_ERROR,PCITEM_INTEGER,PCITEM_STRING,PCITEM_DATE,PCITEM_MISSING |
| 0x00D0=SXTBL,SXTBRGITEM,SXTBPG,VBAPROJECT,,PIVOTCACHE,RSTRING,DBCELL |
| 0x00D8=PCDFRANGEPR,PCDFDISCRETEPR,BOOKBOOL,REVERT,DBORPARAMQUERY,SCENPROTECT,OLESIZE,UDDESC |
| 0x00E0=XF,INTERFACEHDR,INTERFACEEND,PCDSOURCE,,,, |
| 0x0206=FORMULA |
| 0x04BC=SHAREDFMLA |
| # chart records |
| exclude=0x1004,0x102D,0x102F,0x1036,0x1037,0x1038,0x103B |
| 0x1040=CHRADARAREA,CHAXESSET,,CHLEGENDENTRY,CHPROPERTIES,CHSERGROUP,CHUSEDAXESSETS, |
| 0x1048=CHPIVOTRANGE,,CHSERPARENT,CHSERTRENDLINE,,,CHFORMAT,CHFRAMEPOS |
| 0x1050=CHFORMATRUNS,CHSOURCELINK,,,,,, |
| 0x1058=,,,CHSERERRORBAR,,CHSERIESFORMAT,, |
| end |
| |
| multilist=RECORD-NAMES-BIFF8 |
| include=RECORD-NAMES-BIFF5 |
| # worksheet/workbook records |
| 0x00E0=,,,,,CELLMERGING,, |
| 0x00E8=,IMGDATA,,MSODRAWINGGROUP,MSODRAWING,MSODRAWINGSELECTION,,PHONETICPR |
| 0x00F0=,PTDEFINITION2,,,,,, |
| 0x00F8=,PCDFORMULAFIELD,,,SST,LABELSST,,EXTSST |
| 0x0100=PTFIELD2,,,PCDFIELDINDEX,,,, |
| 0x0120=,,PCDEFINITION2,,,,, |
| 0x0130=,,,,,,,CHTRINSERT |
| 0x0138=CHTRINFO,,,CHTRCELLCONTENT,,TABID,, |
| 0x0140=CHTRMOVERANGE,,,,,,, |
| 0x0148=,,,,,CHTRINSERTTAB,, |
| 0x0158=,,,,,,,LABELRANGES |
| 0x0160=USESELFS,DSF,XL5MODIFY,,,,, |
| 0x0190=,,,,,,CHTRHEADER, |
| 0x01A8=,USERBVIEW,USERSVIEWBEGIN,USERSVIEWEND,,QUERYTABLE,EXTERNALBOOK,PROT4REV |
| 0x01B0=CFHEADER,CFRULE,DATAVALIDATIONS,,,DCONBINAME,TXO,REFRESHALL |
| 0x01B8=HYPERLINK,NLRDELNAME,CODENAME,PCDFSQLTYPE,PROT4REVPASS,VBAPROJECTEMPTY,DATAVALIDATION, |
| 0x01C0=XL9FILE,RECALCID,INTCACHEDDATA,,,,, |
| # future records |
| 0x0800=SCREENTIP,,QUERYTABLEREFRESH,QUERYTABLESETTINGS,QUERYTABLESTRING,,, |
| 0x0850=CHFRINFO,CHFRWRAPPER,CHFRBLOCKBEGIN,CHFRBLOCKEND,,,CHFRCATEGORYPROPS,CHFRUNITPROPS |
| 0x0858=CHPIVOTREF,CHPIVOTFLAGS,,,,,, |
| 0x0860=,,SHEETEXT,BOOKEXT,,,,SHAREDFEATHEAD |
| 0x0868=,,,CHFRLABELPROPS,,,, |
| 0x0870=,,,,,,CONNECTION, |
| 0x0878=,,CFRULE12,CFRULEEXT,XFCRC,XFEXT,FILTERCOLUMN12,CONTINUE12 |
| 0x0888=,,,PAGELAYOUTVIEW,CHECKCOMPAT,DXF,TABLESTYLES, |
| 0x0890=,,STYLEEXT,,,,THEME, |
| 0x0898=,,MTHREADSETTINGS,COMPRESSPICS,HEADERFOOTER,CHFRLAYOUT,CHFREXTPROPS,CHFREXTPROPSCONT |
| 0x08A0=,,,FORCEFULLCALC,CHFRSHAPEPROPS,CHFRTEXTPROPS,,CHFRPLOTAREALAYOUT |
| # chart records |
| 0x1058=,,,,,,,CH3DDATAFORMAT |
| 0x1060=CHFONTBASE,CHPIEEXT,CHDATERANGE,CHDATATABLE,CHPLOTGROWTH,CHSERINDEX,CHESCHERFORMAT,CHPIEEXTSETT |
| end |
| |
| # simple records ------------------------------------------------------------- |
| |
| constlist=SIMPLE-RECORDS-BIFF2 |
| 0x000C=uint16,dec,max-iterations |
| 0x000D=int16,dec,calc-mode,CALCMODE |
| 0x000E=uint16,bool,calc-precise |
| 0x000F=uint16,dec,ref-mode,REFMODE |
| 0x0010=double,dec,epsilon |
| 0x0011=uint16,bool,iterate-recursive |
| 0x0012=uint16,bool,contents-protected |
| 0x0013=uint16,hex,password-hash |
| 0x0016=uint16,dec,externsheets |
| 0x0019=uint16,bool,window-protected |
| 0x001F=uint16,dec,builtin-fmt-count |
| 0x0022=uint16,dec,null-date,DATEMODE |
| 0x0025=uint16,hex,rowheight-flags,DEFROWHEIGHT-FLAGS |
| 0x0026=double,dec,left-margin,CONV-INCH-TO-CM |
| 0x0027=double,dec,right-margin,CONV-INCH-TO-CM |
| 0x0028=double,dec,top-margin,CONV-INCH-TO-CM |
| 0x0029=double,dec,bottom-margin,CONV-INCH-TO-CM |
| 0x002A=uint16,bool,print-sheet-headers |
| 0x002B=uint16,bool,print-gridlines |
| 0x0040=uint16,bool,backup-on-save |
| 0x0044=uint16,dec,xf-idx |
| 0x0045=uint16,dec,font-color-idx,COLORS |
| 0x0055=uint16,dec,base-col-width |
| 0x100B=uint16,dec,extrusion,CONV-PERCENT |
| 0x100C=uint16,hex,flags,CHATTACHEDLABEL-FLAGS |
| 0x1018=uint16,hex,flags,CHLINE-FLAGS |
| 0x101A=uint16,hex,flags,CHAREA-FLAGS |
| 0x101C=uint16,dec,line-type,CHCHARTLINE-TYPE |
| 0x1021=uint16,dec,axisline-id,CHAXISLINE-ID |
| 0x1024=uint16,dec,text-idx |
| 0x1026=uint16,dec,font-idx,FONTNAMES |
| 0x1045=uint16,dec,group-idx |
| 0x1046=uint16,dec,used-axessets |
| 0x104A=uint16,dec,series-idx |
| 0x104E=uint16,dec,fmt-idx,FORMATS |
| end |
| |
| constlist=SIMPLE-RECORDS-BIFF3 |
| include=SIMPLE-RECORDS-BIFF2 |
| 0x0056=uint16,dec,builtin-fmt-count |
| 0x005E=uint16,unused |
| 0x005F=uint16,bool,recalc-on-save |
| 0x0063=uint16,bool,objects-protected |
| 0x0081=uint16,hex,flags,SHEETPR-FLAGS |
| 0x0082=uint16,bool,print-gridlines-changed |
| 0x0083=uint16,bool,horizontal-centered |
| 0x0084=uint16,bool,vertical-centered |
| 0x008D=uint16,dec,object-mode,HIDEOBJ |
| end |
| |
| constlist=SIMPLE-RECORDS-BIFF4 |
| include=SIMPLE-RECORDS-BIFF3 |
| 0x008E=uint32,hex,stream-pos,CONV-DEC |
| 0x0099=uint16,dec,default-col-width,CONV-COLWIDTH |
| 0x009C=uint16,dec,func-group-count |
| 0x103D=uint16,dec,bar-dist |
| 0x103E=uint16,hex,flags,CHRADAR-FLAGS |
| 0x103F=uint16,hex,flags,CHSURFACE-FLAGS |
| end |
| |
| constlist=SIMPLE-RECORDS-BIFF5 |
| include=SIMPLE-RECORDS-BIFF4 |
| 0x009D=uint16,dec,column-count |
| 0x00C9=double,dec,value |
| 0x00CA=uint16,bool,value |
| 0x00CB=uint16,hex,error-code,ERRORCODES |
| 0x00CC=int16,dec,value |
| 0x00D5=uint16,hex,cache-id |
| 0x00D8=uint16,hex,flags,PCDFRANGEPR-FLAGS |
| 0x00DA=uint16,bool,strip-cached-values |
| 0x00DD=uint16,bool,scenarios-protected |
| 0x00E3=uint16,dec,source-type,PCDSOURCE-TYPE |
| 0x1040=uint16,hex,flags,CHRADAR-FLAGS |
| 0x105D=uint16,hex,flags,CHSERIESFORMAT-FLAGS |
| end |
| |
| constlist=SIMPLE-RECORDS-BIFF8 |
| include=SIMPLE-RECORDS-BIFF5 |
| 0x00E1=uint16,dec,codepage,CODEPAGES |
| 0x0160=uint16,bool,use-nat-lang-refs |
| 0x0161=uint16,bool,double-stream |
| 0x01AF=uint16,bool,revlog-protected |
| 0x01B7=uint16,bool,refresh-all |
| 0x01BB=uint16,dec,sql-data-type,PCDFSQLTYPE-DATATYPE |
| 0x01BC=uint16,hex,password-hash |
| 0x1065=uint16,dec,series-idx |
| end |
| |
| # ARRAY ---------------------------------------------------------------------- |
| |
| flagslist=ARRAY-FLAGS-BIFF2 |
| 0x0001=recalc-always |
| end |
| |
| flagslist=ARRAY-FLAGS-BIFF3 |
| include=ARRAY-FLAGS-BIFF2 |
| 0x0002=recalc-onload |
| end |
| |
| # BOF ------------------------------------------------------------------------ |
| |
| constlist=BOF-BIFFTYPE |
| 0x0000=from-id |
| 0x0007=biff2 |
| 0x0200=biff2 |
| 0x0300=biff3 |
| 0x0400=biff4 |
| 0x0500=biff5 |
| 0x0600=biff8 |
| end |
| |
| constlist=BOF-SHEETTYPE |
| 0x0005=globals |
| 0x0006=vb-module |
| 0x0010=sheet |
| 0x0020=chart |
| 0x0040=macro |
| 0x0100=workspace |
| end |
| |
| shortlist=BOF-EXCELVERSION,0,excel-97,excel-2000,excel-2002,excel-2003,excel-2007,,excel-2010 |
| shortlist=BOF-LOWESTVERSION-BIFF,6,biff8 |
| |
| combilist=BOF-HISTORY-FLAGS |
| ignore=0x000000C0 |
| 0x00000001=windows |
| 0x00000002=risc |
| 0x00000004=beta |
| 0x00000008=win-any |
| 0x00000010=mac-any |
| 0x00000020=beta-any |
| 0x00000100=risc-any |
| 0x00000200=out-of-mem |
| 0x00000400=out-of-mem-renderer |
| 0x00002000=font-limit-255 |
| 0x0003C000=uint8,dec,max-version-saved,BOF-EXCELVERSION |
| end |
| |
| combilist=BOF-LOWESTVERSION-FLAGS |
| 0x000000FF=uint8,dec,biff-version,BOF-LOWESTVERSION-BIFF |
| 0x00000F00=uint8,dec,version-saved,BOF-EXCELVERSION |
| end |
| |
| # BOOKEXT -------------------------------------------------------------------- |
| |
| combilist=BOOKEXT-FLAGS1 |
| 0x00000001=no-auto-recover |
| 0x00000002=hide-pivot-list |
| 0x00000004=filter-privacy |
| 0x00000008=embed-smarttags |
| 0x00000030=uint8,dec,display-smarttags,BOOKEXT-DISPLAY-SMARTTAGS |
| 0x00000040=saved-on-recovery |
| 0x00000080=minimal-save |
| 0x00000100=opened-on-recovery |
| 0x00000200=opened-in-save-mode |
| end |
| |
| shortlist=BOOKEXT-DISPLAY-SMARTTAGS,0,button-and-indicator,button,nothing |
| |
| flagslist=BOOKEXT-FLAGS2 |
| 0x01=warn-smart-doc-manifest |
| 0x02=show-inc-annotations |
| end |
| |
| flagslist=BOOKEXT-FLAGS3 |
| 0x02=!all-published!selected-items-published |
| 0x04=show-pivot-chart-filter |
| end |
| |
| # CALCMODE ------------------------------------------------------------------- |
| |
| shortlist=CALCMODE,-1,automatic-no-table,manual,automatic |
| |
| # CFHEADER ------------------------------------------------------------------- |
| |
| combilist=CFHEADER-FLAGS |
| 0x0001=complex |
| 0xFFFE=uint16,dec,id |
| end |
| |
| # CFRULE --------------------------------------------------------------------- |
| |
| shortlist=CFRULE-TYPE,1,value,formula |
| shortlist=CFRULE-OPERATOR,0,none,between,not-between,equal,not-equal,greater-than,less-than,greater-equal,less-equal |
| |
| flagslist=CFRULE-FLAGS1 |
| ignore=0x00200000 |
| 0x00000001=!hor-align-used |
| 0x00000002=!vert-align-used |
| 0x00000004=!text-wrap-used |
| 0x00000008=!rotation-used |
| 0x00000010=!justify-lastline-used |
| 0x00000020=!indent-used |
| 0x00000040=!shrinktofit-used |
| 0x00000080=!cell-merged-used |
| 0x00000100=!cell-locked-used |
| 0x00000200=!cell-hidden-used |
| 0x00000400=!left-border-used |
| 0x00000800=!right-border-used |
| 0x00001000=!top-border-used |
| 0x00002000=!bottom-border-used |
| 0x00004000=!tl-to-br-used |
| 0x00008000=!bl-to-tr-used |
| 0x00010000=!fill-pattern-used |
| 0x00020000=!fg-color-idx-used |
| 0x00040000=!bg-color-idx-used |
| 0x00080000=!fmt-idx-used |
| 0x00100000=!def-font-used |
| 0x02000000=numfmt-block |
| 0x04000000=font-block |
| 0x08000000=alignment-block |
| 0x10000000=border-block |
| 0x20000000=pattern-block |
| 0x40000000=protection-block |
| 0x80000000=!text-dir-used |
| end |
| |
| flagslist=CFRULE-FLAGS2 |
| ignore=0x0002 |
| 0x0001=!numfmt-id!numfmt-string |
| 0x0004=outline-border |
| 0x8000=use-text-dir |
| end |
| |
| combilist=CFRULE-ALIGNMENT |
| 0x07=uint8,dec,hor-align,XF-HORALIGN |
| 0x08=text-wrap |
| 0x70=uint8,dec,ver-align,XF-VERALIGN |
| 0x80=justify-lastline |
| end |
| |
| combilist=CFRULE-INDENT |
| 0x000F=uint8,dec,indent |
| 0x0010=shrink-to-fit |
| 0x0020=cell-merged |
| 0x00C0=uint8,dec,text-dir,XF-TEXTDIRECTION |
| end |
| |
| flagslist=CFRULE-FONTFLAGS |
| 0x00000002=italic |
| 0x00000008=outline |
| 0x00000010=shadow |
| 0x00000020=condense |
| 0x00000040=extend |
| 0x00000080=strikeout |
| end |
| |
| constlist=CFRULE-FONTWEIGHT |
| include=FONT-WEIGHT |
| -1=unused |
| end |
| |
| constlist=CFRULE-FONTESCAPEMENT |
| include=FONT-ESCAPEMENT |
| -1=unused |
| end |
| |
| constlist=CFRULE-FONTUNDERLINE |
| include=FONT-UNDERLINE |
| -1=unused |
| end |
| |
| constlist=CFRULE-FONTCOLOR |
| include=COLORS-BIFF8 |
| -1=unused |
| end |
| |
| flagslist=CFRULE-FONTUSEDFLAGS |
| ignore=0xFFFFFF00 |
| 0x00000002=!italic-used |
| 0x00000008=!outline-used |
| 0x00000010=!shadow-used |
| 0x00000020=!condense-used |
| 0x00000040=!extend-used |
| 0x00000080=!strikeout-used |
| end |
| |
| constlist=CFRULE-FONTUSED |
| 0=used |
| 1=not-used |
| end |
| |
| combilist=CFRULE-BORDERCOLOR2 |
| 0x0000007F=uint8,dec,top-color,COLORS |
| 0x00003F80=uint8,dec,bottom-color,COLORS |
| 0x001FC000=uint8,dec,diag-color,COLORS |
| 0x01E00000=uint8,dec,diag-style,BORDERSTYLES |
| end |
| |
| combilist=CFRULE-FILLBLOCK |
| 0x0000FC00=uint8,dec,fill-pattern,FILLPATTERNS |
| 0x007F0000=uint8,dec,fg-color-idx,COLORS |
| 0x3F800000=uint8,dec,bg-color-idx,COLORS |
| end |
| |
| flagslist=CFRULE-PROTECTION-FLAGS |
| 0x0001=locked |
| 0x0002=formula-hidden |
| end |
| |
| # CFRULE12 ------------------------------------------------------------------- |
| |
| shortlist=CFRULE12-TYPE,1,cell-is,expression,color-scale,data-bar,top-ten,icon-set |
| |
| flagslist=CFRULE12-FLAGS |
| 0x0002=stop-if-true |
| end |
| |
| multilist=CFRULE12-SUBTYPE |
| 0=cell-is,expression,color-scale,data-bar,icon-set,top-ten,,unique-values,contains-text,contains-blanks |
| 10=not-contains-blanks,contains-errors,not-contains-errors,,,today,tomorrow,yesterday,last-7-days,last-month |
| 20=next-month,this-week,next-week,last-week,this-month,above-average,below-average,duplicate-values,,equal-above-average |
| 30=equal-below-average |
| end |
| |
| flagslist=CFRULE12-TOP10-FLAGS |
| 0x01=!bottom!top |
| 0x02=percent |
| end |
| |
| shortlist=CFRULE12-TEXT-OPERATOR,0,contains,not-contains,begins-with,ends-with |
| shortlist=CFRULE12-DATE-OPERATOR,0,today,yesterday,last-7-days,this-week,last-week,last-month,tomorrow,next-week,next-month,this-month |
| |
| # CFRULEEXT ------------------------------------------------------------------ |
| |
| flagslist=CFRULEEXT-FLAGS |
| 0x0001=active |
| 0x0002=stop-if-true |
| end |
| |
| # CH3DDATAFORMAT ------------------------------------------------------------- |
| |
| shortlist=CH3DDATAFORMAT-BASE,0,rectangular,circular |
| shortlist=CH3DDATAFORMAT-TOP,0,straight,sharp,trunc |
| |
| # CHAREA --------------------------------------------------------------------- |
| |
| flagslist=CHAREA-FLAGS |
| 0x0001=stacked |
| 0x0002=percent |
| 0x0004=shadow |
| end |
| |
| # CHAREAFORMAT --------------------------------------------------------------- |
| |
| flagslist=CHAREAFORMAT-FLAGS |
| 0x0001=auto |
| 0x0002=swap-negative |
| end |
| |
| # CHATTACHEDLABEL ------------------------------------------------------------ |
| |
| flagslist=CHATTACHEDLABEL-FLAGS |
| 0x0001=show-value |
| 0x0002=show-percent |
| 0x0004=show-categ-percent |
| 0x0008=smoothed |
| 0x0010=show-categ |
| 0x0020=show-bubble |
| end |
| |
| # CHAXESSET ------------------------------------------------------------------ |
| |
| shortlist=CHAXESSET-ID,0,primary,secondary |
| |
| # CHAXIS --------------------------------------------------------------------- |
| |
| shortlist=CHAXIS-TYPE,0,x-axis,y-axis,z-axis |
| |
| # CHAXISLINE ----------------------------------------------------------------- |
| |
| shortlist=CHAXISLINE-ID,0,axisline,major-grid,minor-grid,wall |
| |
| # CHBAR ---------------------------------------------------------------------- |
| |
| flagslist=CHBAR-FLAGS |
| 0x0001=horizontal |
| 0x0002=stacked |
| 0x0004=percent |
| 0x0008=shadow |
| end |
| |
| # CHCHART3D ------------------------------------------------------------------ |
| |
| flagslist=CHCHART3D-FLAGS |
| ignore=0x0010 |
| 0x0001=real3d |
| 0x0002=clustered |
| 0x0004=auto-height |
| 0x0020=2d-plotarea |
| end |
| |
| # CHTYPEGROUP ---------------------------------------------------------------- |
| |
| flagslist=CHTYPEGROUP-FLAGS |
| 0x0001=varied-colors |
| end |
| |
| # CHCHARTLINE ---------------------------------------------------------------- |
| |
| shortlist=CHCHARTLINE-TYPE,0,drop-line,hi-lo-line,series-connector |
| |
| # CHDATAFORMAT --------------------------------------------------------------- |
| |
| constlist=CHDATAFORMAT-POINTIDX |
| default= |
| -1=all-points |
| end |
| |
| constlist=CHDATAFORMAT-FORMATIDX |
| default= |
| -3=axesset-global |
| end |
| |
| flagslist=CHDATAFORMAT-FLAGS |
| 0x0001=excel4-colors |
| end |
| |
| # CHDATERANGE ---------------------------------------------------------------- |
| |
| shortlist=CHDATERANGE-UNIT,0,days,months,years |
| |
| flagslist=CHDATERANGE-FLAGS |
| 0x0001=auto-minimum |
| 0x0002=auto-maximum |
| 0x0004=auto-major |
| 0x0008=auto-minor |
| 0x0010=date-axis |
| 0x0020=auto-base |
| 0x0040=auto-axis-cross |
| 0x0080=auto-date |
| end |
| |
| # CHFRAME -------------------------------------------------------------------- |
| |
| shortlist=CHFRAME-FORMAT,0,standard,,,,shadow |
| |
| flagslist=CHFRAME-FLAGS |
| 0x0001=auto-size |
| 0x0002=auto-pos |
| end |
| |
| # CHFRAMEPOS ----------------------------------------------------------------- |
| |
| shortlist=CHFRAMEPOS-POSMODE,0,rel-points,abssize-points,parent-dependent,offset-plotarea-size,,chartsize |
| |
| # CHFRBLOCKBEGIN, CHFRBLOCKEND ----------------------------------------------- |
| |
| shortlist=CHFRBLOCK-TYPE,0,axes-set,,text,,axis,type-group,data-table,frame,,legend,legend-exception,,series,chart,data-format,drop-bar |
| |
| # CHFRCATEGORYPROPS ---------------------------------------------------------- |
| |
| shortlist=CHFRCATEGORYPROPS-ALIGN,1,top-left,center,bottom-right |
| |
| flagslist=CHFRCATEGORYPROPS-FLAGS |
| ignore=0xFFFE |
| 0x0001=auto-label-frequency |
| end |
| |
| # CHFREXTPROPS --------------------------------------------------------------- |
| |
| constlist=CHFREXTPROPS-PARENT |
| 0x0001=log-scaling |
| 0x0002=style |
| 0x0004=category-scaling |
| 0x0005=chart-props |
| 0x000F=legend |
| 0x0013=marker |
| 0x0016=plot-area |
| 0x0019=chart-title |
| 0x0037=3d-props |
| end |
| |
| constlist=CHFREXTPROPS-TYPE |
| 0=start |
| 1=end |
| 2=bool |
| 3=double |
| 4=int32 |
| 5=string |
| 6=uint16 |
| 7=blob |
| end |
| |
| constlist=CHFREXTPROPS-TAG |
| 0x0000=log-base |
| 0x0003=style |
| 0x001E=chart-formatting |
| 0x0020=text-formatting |
| 0x0022=symbol-type |
| 0x002E=no-multi-level |
| 0x002F=overlay |
| 0x0033=theme-override |
| 0x0034=color-mapping-override |
| 0x0035=backwall-thickness |
| 0x0036=floor-thickness |
| 0x004D=perspective |
| 0x004E=rotation-x |
| 0x004F=rotation-y |
| 0x0050=right-angled-axes-off |
| 0x0052=tick-mark-skip |
| 0x0051=tick-label-skip |
| 0x0053=major-unit |
| 0x0054=minor-unit |
| 0x0055=max |
| 0x0056=min |
| 0x0059=side-wall |
| 0x005B=show-data-labels-over-max |
| 0x005C=tick-label-pos |
| 0x005E=pie-combination |
| 0x005F=basetime-unit |
| 0x0064=format-code |
| 0x0065=height-percent |
| 0x0066=display-blanks-as |
| 0x006A=major-unit-type |
| 0x006B=minor-unit-type |
| 0x0076=edit-language |
| end |
| |
| constlist=CHFREXTPROPS-TAG-NAMELIST |
| default= |
| 0x0022=CHFREXTPROPS-SYMBOLTYPE |
| 0x0035=CONV-PERCENT |
| 0x0036=CONV-PERCENT |
| 0x004E=CONV-DEG |
| 0x004F=CONV-DEG |
| 0x005C=CHFREXTPROPS-TICKLABELPOS |
| 0x005F=CHFREXTPROPS-TIMEUNIT |
| 0x0065=CONV-PERCENT |
| 0x0066=CHFREXTPROPS-DISPBLANKSAS |
| 0x006A=CHFREXTPROPS-TIMEUNIT |
| 0x006B=CHFREXTPROPS-TIMEUNIT |
| end |
| |
| shortlist=CHFREXTPROPS-DISPBLANKSAS,0x0067,gap,,spanned |
| shortlist=CHFREXTPROPS-SYMBOLTYPE,0x0023,none,diamond,square,triangle,x,star,dot,dash,circle,plus |
| shortlist=CHFREXTPROPS-TICKLABELPOS,0x005D,center |
| shortlist=CHFREXTPROPS-TIMEUNIT,0x0060,days,months,years |
| |
| # CHFRINFO ------------------------------------------------------------------- |
| |
| shortlist=CHFRINFO-APPVERSION,9,excel-2000,excel-xp-2003,,excel-2007 |
| |
| # CHFRLABELPROPS ------------------------------------------------------------- |
| |
| flagslist=CHFRLABELPROPS-FLAGS |
| 0x0001=show-series |
| 0x0002=show-categ |
| 0x0004=show-value |
| 0x0008=show-percent |
| 0x0010=show-bubble |
| end |
| |
| # CHFRLAYOUT ----------------------------------------------------------------- |
| |
| combilist=CHFRLAYOUT-FLAGS |
| 0x001E=uint8,dec,legend-pos,CHFRLAYOUT-LEGENDPOS |
| end |
| |
| shortlist=CHFRLAYOUT-LEGENDPOS,0,bottom,top-right,top,right,left |
| |
| shortlist=CHFRLAYOUT-MODE,0,auto,factor,egde |
| |
| # CHFRPLOTAREALAYOUT --------------------------------------------------------- |
| |
| flagslist=CHFRPLOTAREALAYOUT-FLAGS |
| 0x0001=!outer!inner |
| end |
| |
| shortlist=CHFRLAYOUT-LEGENDPOS,0,bottom,top-right,top,right,left |
| |
| shortlist=CHFRLAYOUT-MODE,0,auto,factor,egde |
| |
| # CHFRUNITPROPS -------------------------------------------------------------- |
| |
| shortlist=CHFRUNITPROPS-PRESET,-1,manual,none,hundred,thousand,10000,100000,million,10-million,100-million,billion,trillion |
| |
| flagslist=CHFRUNITPROPS-FLAGS |
| 0x0002=show-unit |
| end |
| |
| # CHLABELRANGE --------------------------------------------------------------- |
| |
| flagslist=CHLABELRANGE-FLAGS |
| 0x0001=cross-between-categ |
| 0x0002=maximum-axis-cross |
| 0x0004=reverse-order |
| end |
| |
| # CHLEGEND ------------------------------------------------------------------- |
| |
| shortlist=CHLEGEND-DOCKPOS,0,bottom,top-right,top,right,left,,,manual |
| shortlist=CHLEGEND-SPACING,0,close,medium,open |
| |
| flagslist=CHLEGEND-FLAGS |
| 0x0001=docked |
| 0x0002=auto-series |
| 0x0004=auto-pos-x |
| 0x0008=auto-pos-y |
| 0x0010=stacked |
| 0x0020=data-table |
| end |
| |
| # CHLINE --------------------------------------------------------------------- |
| |
| flagslist=CHLINE-FLAGS |
| 0x0001=stacked |
| 0x0002=percent |
| 0x0004=shadow |
| end |
| |
| # CHLINEFORMAT --------------------------------------------------------------- |
| |
| shortlist=CHLINEFORMAT-LINETYPE,0,solid,dash,dot,dash-dot,dash-dot-dot,none,25%-pattern,50%-pattern,75%-pattern |
| shortlist=CHLINEFORMAT-LINEWEIGHT,-1,hair,thin,medium,thick |
| |
| flagslist=CHLINEFORMAT-FLAGS |
| 0x0001=auto |
| 0x0004=axis-enabled |
| 0x0008=system-color |
| end |
| |
| # CHMARKERFORMAT ------------------------------------------------------------- |
| |
| shortlist=CHMARKERFORMAT-TYPE,0,none,square,diamond,triangle,cross,star,dow-jones,std-dev,circle,plus |
| |
| flagslist=CHMARKERFORMAT-FLAGS |
| 0x0001=auto |
| 0x0010=no-fill |
| 0x0020=no-border |
| end |
| |
| # CHOBJECTLINK --------------------------------------------------------------- |
| |
| shortlist=CHOBJECTLINK-TARGET,0,none,title,y-axis,x-axis,datapoint,legend,none,z-axis,,,,,axis-unit |
| |
| constlist=CHOBJECTLINK-POINT |
| default= |
| -2=unknown |
| -1=all-points |
| end |
| |
| # CHPICFORMAT ---------------------------------------------------------------- |
| |
| shortlist=CHPICFORMAT-BITMAP-MODE,1,stretched,stacked,stacked-scaled |
| |
| combilist=CHPICFORMAT-FLAGS |
| 0x0200=top-bottom |
| 0x0400=front-back |
| 0x0800=left-right |
| end |
| |
| # CHPIE ---------------------------------------------------------------------- |
| |
| flagslist=CHPIE-FLAGS |
| 0x0001=shadow |
| 0x0002=connectors |
| end |
| |
| # CHPIVOTFLAGS --------------------------------------------------------------- |
| |
| flagslist=CHPIVOTFLAGS-FLAGS |
| 0x0001=hide-field-captions |
| end |
| |
| # CHRADAR, CHRADARAREA ------------------------------------------------------- |
| |
| flagslist=CHRADAR-FLAGS |
| 0x0001=axis-labels |
| 0x0002=shadow |
| end |
| |
| # CHPROPERTIES --------------------------------------------------------------- |
| |
| shortlist=CHPROPERTIES-EMPTYCELLS,0,do-not-plot,as-zero,interpolated |
| |
| flagslist=CHPROPERTIES-FLAGS |
| 0x0001=manual-series |
| 0x0002=plot-visible-only |
| 0x0004=fixed-size |
| 0x0008=manual-plotarea |
| 0x0010=apply-plotarea-pos |
| end |
| |
| # CHSCATTER ------------------------------------------------------------------ |
| |
| shortlist=CHSCATTER-SIZETYPE,0,none,area,width |
| |
| flagslist=CHSCATTER-FLAGS |
| 0x0001=bubbles |
| 0x0002=show-negative |
| 0x0004=shadow |
| end |
| |
| # CHSERERRORBAR -------------------------------------------------------------- |
| |
| shortlist=CHSERERRORBAR-TYPE,1,x-plus,x-minus,y-plus,y-minus |
| shortlist=CHSERERRORBAR-SOURCE,1,percent,fixed,std-deviation,custom,std-error |
| |
| # CHSERIES ------------------------------------------------------------------- |
| |
| shortlist=CHSERIES-TYPE,0,date,numeric,sequence,text |
| |
| # CHSERIESFORMAT ------------------------------------------------------------- |
| |
| flagslist=CHSERIESFORMAT-FLAGS |
| 0x0001=spline |
| 0x0002=bubbles-3d |
| 0x0004=shadow |
| end |
| |
| # CHSERTRENDLINE ------------------------------------------------------------- |
| |
| shortlist=CHSERTRENDLINE-TYPE,0,poynomial,exponential,logarithmic,power,moving-average |
| |
| # CHSOURCELINK --------------------------------------------------------------- |
| |
| shortlist=CHSOURCELINK-TARGET,0,title,values,category,bubbles |
| shortlist=CHSOURCELINK-TYPE,0,default,constant,sheet-link |
| |
| flagslist=CHSOURCELINK-FLAGS |
| 0x0001=custom-numfmt |
| end |
| |
| # CHSTRING ------------------------------------------------------------------- |
| |
| shortlist=CHSTRING-TYPE,0,text,category-default,value-default,x-prefix,x-postfix,y-prefix,y-postfix,comment |
| |
| # CHSURFACE ------------------------------------------------------------------ |
| |
| flagslist=CHSURFACE-FLAGS |
| 0x0001=filled |
| 0x0002=shadow |
| end |
| |
| # CHTEXT --------------------------------------------------------------------- |
| |
| shortlist=CHTEXT-HORALIGN,1,left,center,right,block,distribute |
| shortlist=CHTEXT-VERALIGN,1,top,center,bottom,block,distribute |
| shortlist=CHTEXT-FILLMODE,1,transparent,opaque |
| |
| flagslist=CHTEXT-FLAGS1-BIFF2 |
| 0x0001=auto-color |
| 0x0002=show-symbol |
| 0x0004=show-value |
| 0x0008=vertical |
| 0x0010=auto-text |
| 0x0020=default-format |
| 0x0040=deleted |
| 0x0080=auto-fill |
| end |
| |
| combilist=CHTEXT-FLAGS1-BIFF3 |
| include=CHTEXT-FLAGS1-BIFF2 |
| 0x0700=uint8,dec,orientation,TEXTORIENTATION |
| end |
| |
| combilist=CHTEXT-FLAGS1-BIFF5 |
| include=CHTEXT-FLAGS1-BIFF3 |
| 0x0800=show-categ-percent |
| 0x1000=show-percent |
| end |
| |
| combilist=CHTEXT-FLAGS1-BIFF8 |
| include=CHTEXT-FLAGS1-BIFF5 |
| 0x2000=show-bubble-size |
| 0x4000=show-categ |
| end |
| |
| combilist=CHTEXT-FLAGS2 |
| ignore=0x3FF0 |
| 0x000F=uint8,dec,placement,CHTEXT-PLACEMENT |
| 0xC000=uint8,dec,text-dir,XF-TEXTDIRECTION |
| end |
| |
| shortlist=CHTEXT-PLACEMENT,0,context,outside,inside,center,axis,above,below,left,right,auto,manual |
| |
| # CHTICK --------------------------------------------------------------------- |
| |
| shortlist=CHTICK-TYPE,0,none,inside,outside,both |
| # TODO: really different label positions in BIFF2-BIFF4? |
| shortlist=CHTICK-LABELPOS-BIFF2,0,none,near,below,above |
| shortlist=CHTICK-LABELPOS-BIFF5,0,none,below,above,near |
| |
| flagslist=CHTICK-FLAGS-BIFF2 |
| 0x0001=auto-color |
| 0x0002=auto-fill |
| end |
| |
| combilist=CHTICK-FLAGS-BIFF3 |
| include=CHTICK-FLAGS-BIFF2 |
| 0x001C=uint8,dec,orientation,TEXTORIENTATION |
| 0x0020=auto-rotation |
| end |
| |
| # CHVALUERANGE --------------------------------------------------------------- |
| |
| flagslist=CHVALUERANGE-FLAGS |
| ignore=0x0100 |
| 0x0001=auto-minimum |
| 0x0002=auto-maximum |
| 0x0004=auto-major |
| 0x0008=auto-minor |
| 0x0010=auto-axis-cross |
| 0x0020=logarithmic |
| 0x0040=reverse-order |
| 0x0080=maximum-axis-cross |
| end |
| |
| # COLINFO -------------------------------------------------------------------- |
| |
| combilist=COLINFO-FLAGS |
| 0x0001=hidden |
| 0x0002=custom-width |
| 0x0004=best-fit |
| 0x0008=show-phonetic |
| 0x0700=uint8,dec,outline-level |
| 0x1000=outline-collapsed |
| end |
| |
| # CONNECTION ----------------------------------------------------------------- |
| |
| shortlist=CONNECTION-SOURCETYPE,1,odbc,dao,file,html,ole-db,text,ado,dsp |
| |
| flagslist=CONNECTION-FLAGS |
| 0x0001=save-password |
| 0x0002=html-tables |
| 0x0004=table-names |
| 0x0008=deleted |
| 0x0010=stand-alone |
| 0x0020=only-use-conn-file |
| 0x0040=background |
| 0x0080=refresh-on-load |
| 0x0100=save-data |
| end |
| |
| shortlist=CONNECTION-RECONNECTTYPE,0,as-required,always,never |
| shortlist=CONNECTION-CREDENTIALS,0,integrated,none,stored-sso,prompt |
| shortlist=CONNECTION-LINKEDOBJECTTYPE,0,none,query-table,pivot-cache |
| |
| # DATATABLE ------------------------------------------------------------------ |
| |
| flagslist=DATATABLE-FLAGS-BIFF3 |
| 0x0001=recalc-always |
| 0x0002=recalc-on-load |
| 0x0004=row-table |
| 0x0008=table-2d |
| end |
| |
| flagslist=DATATABLE-FLAGS-BIFF8 |
| include=DATATABLE-FLAGS-BIFF3 |
| 0x0010=ref1-deleted |
| 0x0020=ref2-deleted |
| end |
| |
| # DATAVALIDATION ------------------------------------------------------------- |
| |
| combilist=DATAVALIDATION-FLAGS |
| 0x0000000F=uint8,dec,type,DATAVALIDATION-TYPE |
| 0x00000070=uint8,dec,error-style,DATAVALIDATION-ERRORSTYLE |
| 0x00000080=string-list |
| 0x00000100=ignore-empty |
| 0x00000200=no-dropdown |
| 0x00040000=show-input-box |
| 0x00080000=show-error-box |
| 0x00F00000=uint8,dec,operator,DATAVALIDATION-OPERATOR |
| end |
| |
| shortlist=DATAVALIDATION-TYPE,0,any,whole,decimal,list,date,time,text-length,custom |
| shortlist=DATAVALIDATION-OPERATOR,0,between,not-between,equal,not-equal,greater-than,less-than,greater-equal,less-equal |
| shortlist=DATAVALIDATION-ERRORSTYLE,0,error,warning,info |
| |
| # DATAVALIDATIONS ------------------------------------------------------------ |
| |
| flagslist=DATAVALIDATIONS-FLAGS |
| 0x0001=input-box-visible |
| 0x0002=input-box-at-cell |
| 0x0004=cached |
| end |
| |
| # DATEMODE ------------------------------------------------------------------- |
| |
| shortlist=DATEMODE,0,1899-12-31,1904-01-01 |
| |
| # DBQUERY -------------------------------------------------------------------- |
| |
| combilist=DBQUERY-FLAGS |
| 0x0007=uint8,dec,source-type,CONNECTION-SOURCETYPE |
| 0x0008=odbc-connection |
| 0x0010=sql-query |
| 0x0020=server-sql |
| 0x0040=html-query |
| 0x0080=save-password |
| 0x0100=html-tables |
| end |
| |
| # DEFINEDNAME ---------------------------------------------------------------- |
| |
| flagslist=DEFINEDNAME-FLAGS-BIFF2 |
| 0x02=macro |
| 0x04=complex |
| end |
| |
| shortlist=DEFINEDNAME-MACROTYPE-BIFF2,0,none,function,procedure |
| |
| flagslist=DEFINEDNAME-FLAGS-BIFF3 |
| 0x0001=hidden |
| 0x0002=function |
| 0x0004=command |
| 0x0008=macro |
| 0x0010=complex |
| 0x0020=builtin |
| end |
| |
| shortlist=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 |
| |
| combilist=DEFINEDNAME-FLAGS-BIFF4 |
| include=DEFINEDNAME-FLAGS-BIFF3 |
| 0x0FC0=uint16,dec,func-group,DEFINEDNAME-FUNCGROUP |
| end |
| |
| combilist=DEFINEDNAME-FLAGS-BIFF5 |
| include=DEFINEDNAME-FLAGS-BIFF4 |
| 0x0004=vba |
| 0x1000=binary |
| end |
| |
| shortlist=DEFINEDNAME-FUNCGROUP,0,none,financial,date-time,math-trig,statistical,lookup-ref,database,text,logical,information,commands,customizing,macro-control,dde-external,user-definded |
| |
| constlist=DEFINEDNAME-SHEETIDX |
| default= |
| 0=global |
| end |
| |
| # DEFROWHEIGHT --------------------------------------------------------------- |
| |
| combilist=DEFROWHEIGHT-FLAGS-BIFF2 |
| 0x7FFF=uint16,dec,row-height,CONV-TWIP-TO-PT |
| 0x8000=unchanged |
| end |
| |
| flagslist=DEFROWHEIGHT-FLAGS-BIFF3 |
| 0x0001=custom-height |
| 0x0002=hidden |
| 0x0004=thick-top |
| 0x0008=thick-bottom |
| end |
| |
| # DXF ------------------------------------------------------------------------ |
| |
| flagslist=DXF-FLAGS |
| 0x0001=!swap-fg-bg-color |
| 0x0002=use-internal-borders |
| end |
| |
| multilist=DXF-SUBREC |
| 0=FILL-PATTERN,FILL-FGCOLOR,FILL-BGCOLOR,FILL-GRADIENT,FILL-STOP |
| 5=FONT-COLOR,BORDER-TOP,BORDER-BOTTOM,BORDER-LEFT,BORDER-RIGHT |
| 10=BORDER-DIAGONAL,BORDER-VERTICAL,BORDER-HORIZONTAL,BORDER-DIAGUP,BORDER-DIAGDOWN |
| 15=ALIGN-HORIZONTAL,ALIGN-VERTICAL,ALIGN-ROTATION,ALIGN-INDENT,ALIGN-READINGORDER |
| 20=ALIGN-WRAPTEXT,ALIGN-JUSTLASTLINE,ALIGN-SHRINKTOFIT,ALIGN-MERGED,FONT-NAME |
| 25=FONT-WEIGHT,FONT-UNDERLINE,FONT-ESCAPEMENT,FONT-ITALIC,FONT-STRIKE |
| 30=FONT-OUTLINE,FONT-SHADOW,FONT-CONDENSE,FONT-EXTEND,FONT-CHARSET |
| 35=FONT-PITCHFAMILY,FONT-HEIGHT,FONT-SCHEME,NUMFMT-CODE, |
| 40=,NUMFMT-ID,ALIGN-RELINDENT,PROT-LOCKED,PROT-HIDDEN |
| end |
| |
| # EXTERNALBOOK --------------------------------------------------------------- |
| |
| constlist=EXTERNALBOOK-KEY |
| 0x0401=self-reference |
| 0x3A01=analysis-addin |
| end |
| |
| # EXTERNALNAME --------------------------------------------------------------- |
| |
| flagslist=EXTERNALNAME-FLAGS-BIFF3 |
| 0x0001=builtin |
| 0x0002=automatic |
| 0x0004=pic-link |
| 0x0008=dde-stddocumentname |
| end |
| |
| combilist=EXTERNALNAME-FLAGS-BIFF5 |
| include=EXTERNALNAME-FLAGS-BIFF3 |
| 0x0010=ole-link |
| 0x7FE0=uint16,dec,clipboard-format |
| 0x8000=iconified |
| end |
| |
| # EXTERNSHEET ---------------------------------------------------------------- |
| |
| constlist=EXTERNSHEET-IDX-BIFF8 |
| default= |
| -1=deleted |
| -2=special |
| end |
| |
| # FILEPASS ------------------------------------------------------------------- |
| |
| shortlist=FILEPASS-TYPE,0,xor,rc4 |
| shortlist=FILEPASS-MAJOR,1,rc4,crypto-api-2003,crypto-api-2007 |
| |
| # FILTERCOLUMN --------------------------------------------------------------- |
| |
| combilist=FILTERCOLUMN-FLAGS |
| 0x0001=!and!or |
| 0x0004=op-1-simple |
| 0x0008=op-2-simple |
| 0x0010=top-10 |
| 0x0020=!bottom!top |
| 0x0040=percent |
| 0xFF80=uint16,dec,top-10-count |
| end |
| |
| constlist=FILTERCOLUMN-DATATYPE |
| 0=none |
| 2=rk |
| 4=double |
| 6=string |
| 8=boolean |
| 12=blank |
| 14=not-blank |
| end |
| |
| shortlist=FILTERCOLUMN-OPERATOR,0,none,less,equal,less-equal,greater,not-equal,greater-equal |
| |
| # FONT ----------------------------------------------------------------------- |
| |
| flagslist=FONT-FLAGS |
| 0x0001=bold |
| 0x0002=italic |
| 0x0004=underline |
| 0x0008=strikeout |
| 0x0010=outline |
| 0x0020=shadow |
| 0x0040=condense |
| 0x0080=extend |
| end |
| |
| multilist=FONT-UNDERLINE |
| 0x00=none,single,double |
| 0x21=single-acc,double-acc |
| end |
| |
| shortlist=FONT-ESCAPEMENT,0,none,superscript,subscript |
| |
| # FORMULA -------------------------------------------------------------------- |
| |
| flagslist=FORMULA-FLAGS-BIFF2 |
| 0x0001=recalc-always |
| end |
| |
| flagslist=FORMULA-FLAGS-BIFF3 |
| include=FORMULA-FLAGS-BIFF2 |
| 0x0002=recalc-onload |
| end |
| |
| flagslist=FORMULA-FLAGS-BIFF5 |
| include=FORMULA-FLAGS-BIFF3 |
| 0x0008=shared-fmla |
| end |
| |
| shortlist=FORMULA-RESULTTYPE,0,string,boolean,error,empty |
| |
| # GUTS ----------------------------------------------------------------------- |
| |
| shortlist=GUTS-LEVELS,0,none,,1-level,2-levels,3-levels,4-levels,5-levels,6-levels,7-levels |
| |
| # HEADERFOOTER --------------------------------------------------------------- |
| |
| flagslist=HEADERFOOTER-FLAGS |
| ignore=0xFFF0 |
| 0x0001=has-even-hf |
| 0x0002=has-first-hf |
| 0x0004=scale-with-sheet |
| 0x0008=align-with-margins |
| end |
| |
| # HIDEOBJ -------------------------------------------------------------------- |
| |
| shortlist=HIDEOBJ,0,show,placeholder,hide |
| |
| # IMGDATA -------------------------------------------------------------------- |
| |
| constlist=IMGDATA-FORMAT |
| -1=none |
| 2=wmf-pict |
| 9=dib |
| 14=native |
| end |
| |
| shortlist=IMGDATA-ENV,1,windows,apple |
| |
| # NOTE ----------------------------------------------------------------------- |
| |
| flagslist=NOTE-FLAGS-BIFF8 |
| 0x0002=visible |
| 0x0080=row-hidden |
| 0x0100=col-hidden |
| end |
| |
| # NOTESOUND ------------------------------------------------------------------ |
| |
| constlist=NOTESOUND-FORMAT |
| 1=pcm |
| 3=ieee-float |
| 6=a-law |
| 7=mu-law |
| 0xFFFE=extensible |
| end |
| |
| # OBJ ------------------------------------------------------------------------ |
| |
| # object types --- |
| |
| multilist=OBJ-TYPE-BIFF3 |
| 0=group,line,rectangle,oval,arc,chart,textbox,button,picture |
| end |
| |
| multilist=OBJ-TYPE-BIFF4 |
| include=OBJ-TYPE-BIFF3 |
| 9=polygon |
| end |
| |
| multilist=OBJ-TYPE-BIFF5 |
| include=OBJ-TYPE-BIFF4 |
| 10=,checkbox,optionbutton,edit,label,dialog,spin,scrollbar,listbox,groupbox |
| 20=dropdown |
| end |
| |
| multilist=OBJ-TYPE-BIFF8 |
| include=OBJ-TYPE-BIFF5 |
| 25=note |
| 30=drawing |
| end |
| |
| # flags and constants --- |
| |
| flagslist=OBJ-FLAGS-BIFF3 |
| 0x0001=selected |
| 0x0002=auto-size |
| 0x0004=auto-move |
| 0x0010=protected |
| 0x0080=grouped |
| 0x0100=hidden |
| 0x0200=visible |
| end |
| |
| flagslist=OBJ-FLAGS-BIFF4 |
| include=OBJ-FLAGS-BIFF3 |
| 0x0400=printable |
| end |
| |
| flagslist=OBJ-AUTO-FLAGS |
| 0x01=auto |
| end |
| |
| multilist=OBJ-LINETYPE |
| 0=solid,dash,dot,dash-dot,dash-dot-dot,25%-pattern,50%-pattern,75%-pattern |
| 255=none |
| end |
| |
| shortlist=OBJ-LINEWEIGHT,0,hair,thin,medium,thick |
| |
| shortlist=OBJ-ARROWHEAD-TYPE,0,none,open,filled,double-end-open,double-end-filled |
| shortlist=OBJ-ARROWHEAD-WIDTH,0,narrow,medium,wide |
| shortlist=OBJ-ARROWHEAD-LENGTH,0,short,medium,long |
| |
| combilist=OBJ-LINEENDS |
| 0x000F=uint8,dec,arrowhead-type,OBJ-ARROWHEAD-TYPE |
| 0x00F0=uint8,dec,arrowhead-width,OBJ-ARROWHEAD-WIDTH |
| 0x0F00=uint8,dec,arrowhead-length,OBJ-ARROWHEAD-LENGTH |
| end |
| |
| shortlist=OBJ-LINEDIR,0,topleft-to-bottomright,topright-to-bottomleft,bottomright-to-topleft,bottomleft-to-topright |
| |
| shortlist=OBJ-ARC-QUADRANT,0,upper-right,upper-left,lower-left,lower-right |
| |
| combilist=OBJ-FRAMESTYLE-FLAGS |
| 0x0001=rounded |
| 0x0002=shadow |
| 0x03FC=uint16,dec,rounded-diameter |
| end |
| |
| shortlist=OBJ-HORALIGN,0,none,left,center,right,justify |
| shortlist=OBJ-VERALIGN,0,none,top,center,bottom,justify |
| |
| combilist=OBJ-TEXT-FLAGS |
| 0x000E=uint16,dec,hor-align,OBJ-HORALIGN |
| 0x0070=uint16,dec,ver-align,OBJ-VERALIGN |
| 0x0080=auto-size |
| 0x0200=text-locked |
| 0x0400=selected |
| end |
| |
| flagslist=OBJ-PICTURE-FLAGS |
| 0x0001=auto-size |
| 0x0002=linked |
| 0x0008=symbol |
| end |
| |
| flagslist=OBJ-POLYGON-FLAGS |
| 0x0100=closed |
| end |
| |
| flagslist=OBJ-CHART-FLAGS-BIFF5 |
| 0x0001=linked-to-sheet |
| end |
| |
| flagslist=OBJ-BUTTON-FLAGS-BIFF5 |
| 0x0001=default-btn |
| 0x0002=help-btn |
| 0x0004=cancel-btn |
| 0x0008=close-btn |
| end |
| |
| shortlist=OBJ-CHECKBOX-STATE-BIFF5,0,unchecked,checked,tristate |
| |
| flagslist=OBJ-CHECKBOX-FLAGS-BIFF5 |
| 0x0001=flat |
| 0x0002=box-only |
| end |
| |
| shortlist=OBJ-EDIT-TYPE-BIFF5,0,text,integer,double,reference,formula |
| |
| flagslist=OBJ-SCROLLBAR-FLAGS-BIFF5 |
| 0x0001=visible |
| 0x0002=slider-only |
| 0x0004=tracking |
| 0x0008=flat |
| end |
| |
| combilist=OBJ-LISTBOX-FLAGS-BIFF5 |
| 0x0004=linked-edit |
| 0x0008=flat |
| 0x0030=uint8,dec,selection-type,OBJ-LISTBOX-SELTYPE-BIFF5 |
| end |
| |
| shortlist=OBJ-LISTBOX-SELTYPE-BIFF5,0,single,multi,range |
| |
| flagslist=OBJ-GROUPBOX-FLAGS-BIFF5 |
| 0x0001=flat |
| end |
| |
| combilist=OBJ-DROPDOWN-FLAGS-BIFF5 |
| 0x0003=uint8,dec,type,OBJ-DROPDOWN-TYPE-BIFF5 |
| 0x0008=filtered |
| end |
| |
| shortlist=OBJ-DROPDOWN-TYPE-BIFF5,0,listbox,combobox,simple,max |
| |
| multilist=OBJ-RECNAMES-BIFF8 |
| 0x0000=OBJEND,,,,OBJMACRO,,OBJGMO,OBJCF |
| 0x0008=OBJFLAGS,OBJPICTFMLA,OBJCBLS,OBJRBO,OBJSBS,OBJNTS,OBJSBSFMLA,OBJGBODATA |
| 0x0010=OBJEDODATA,OBJRBODATA,OBJCBLSDATA,OBJLBSDATA,OBJCBLSFMLA,OBJCMO,, |
| end |
| |
| flagslist=OBJFLAGS-FLAGS |
| 0x0001=manual-size |
| 0x0002=linked |
| 0x0004=update-on-print |
| 0x0008=symbol |
| 0x0010=control |
| 0x0020=ctls-stream |
| 0x0080=camera-pic |
| 0x0100=default-size |
| 0x0200=auto-load |
| end |
| |
| flagslist=OBJCMO-FLAGS |
| 0x0001=locked |
| 0x0004=default-size |
| 0x0008=published |
| 0x0010=printable |
| 0x0080=disabled |
| 0x0100=auxiliary |
| 0x0200=recalc-on-load |
| 0x1000=recalc-always |
| 0x2000=auto-line |
| 0x4000=auto-area |
| end |
| |
| # PAGELAYOUTVIEW ------------------------------------------------------------- |
| |
| flagslist=PAGELAYOUTVIEW-FLAGS |
| ignore=0xFFF8 |
| 0x0001=page-layout-view |
| 0x0002=show-ruler |
| 0x0004=hide-margins |
| end |
| |
| # PAGESETUP ------------------------------------------------------------------ |
| |
| multilist=PAGESETUP-PAPERSIZE |
| 0=undefined,letter,letter-small,tabloid,ledger,legal,statement,executive,a3,a4 |
| 10=a4-small,a5,b4,b5,folio,quarto,10x14,11x17,note,envelope-9 |
| 20=envelope-10,envelope-11,envelope-12,envelope-14,c,d,e,envelope-dl,envelope-c5,envelope-c3 |
| 30=envelope-c4,envelope-c6,envelope-c65,envelope-b4,envelope-b5,envelope-b6,envelope-italy,envelope-monarch,envelope-6-3/4,us-standard-fanfold |
| 40=german-standard-fanfold,german-legal-fanfold,b4,japanese-dbl-postcaed,9x11,10x11,15x11,, |
| 50=envelope-invite,letter-extra,legal-extra,tabloid-extra,a4-extra,letter-transverse,a4-transverse,letter-extra-transverse,super-a-a4,super-b-a3,letter-plus |
| 60=a4-plus,a5-transverse,jis-b5-transverse,a3-extra,a5-extra,b5-extra,a2,a3-transverse,a3-extra-transverse |
| end |
| |
| constlist=PAGESETUP-SCALETOPAGES |
| default= |
| 0=automatic |
| end |
| |
| flagslist=PAGESETUP-FLAGS-BIFF4 |
| 0x0001=print-in-rows |
| 0x0002=portrait |
| 0x0004=uninitialized |
| 0x0008=black-and-white |
| end |
| |
| flagslist=PAGESETUP-FLAGS-BIFF5 |
| include=PAGESETUP-FLAGS-BIFF4 |
| 0x0010=draft-quality |
| 0x0020=print-notes |
| 0x0040=default-orientation |
| 0x0080=use-first-page |
| end |
| |
| combilist=PAGESETUP-FLAGS-BIFF8 |
| include=PAGESETUP-FLAGS-BIFF5 |
| 0x0200=print-notes-at-end |
| 0x0C00=uint8,dec,print-errors,PAGESETUP-PRINTERRORS |
| end |
| |
| shortlist=PAGESETUP-PRINTERRORS,0,displayed,none,as-dashes,as-na |
| |
| unitconverter=PAGESETUP-DPI,1,dpi |
| |
| # PANE ----------------------------------------------------------------------- |
| |
| shortlist=PANE-ID,0,bottom-right,top-right,bottom-left,top-left |
| |
| # PCDEFINITION --------------------------------------------------------------- |
| |
| flagslist=PCDEFINITION-FLAGS |
| 0x0001=save-data |
| 0x0002=invalid |
| 0x0004=refresh-on-load |
| 0x0008=optimize-memory |
| 0x0010=background-query |
| 0x0020=enable-refresh |
| end |
| |
| # PCDFIELD ------------------------------------------------------------------- |
| |
| flagslist=PCDFIELD-FLAGS |
| 0x0001=has-items |
| 0x0002=has-unshared-items |
| 0x0004=calculated |
| 0x0008=has-parent |
| 0x0010=range-group |
| 0x0020=is-numeric |
| 0x0040=is-integer |
| 0x0080=has-semi-mixed-types |
| 0x0100=has-min-max |
| 0x0200=16bit-indexes |
| 0x0400=has-non-date |
| 0x0800=has-date |
| end |
| |
| # PCDFRANGEPR ---------------------------------------------------------------- |
| |
| combilist=PCDFRANGEPR-FLAGS |
| ignore=0xFFE0 |
| 0x0001=auto-start |
| 0x0002=auto-end |
| 0x001C=uint8,dec,group-by,PCDFRANGEPR-GROUPBY |
| end |
| |
| shortlist=PCDFRANGEPR-GROUPBY,0,numeric,seconds,minutes,hours,days,months,quarters,years |
| |
| # PCDFSQLTYPE ---------------------------------------------------------------- |
| |
| shortlist=PCDFSQLTYPE-DATATYPE,0,unknown,char,numeric,decimal,int32,int16,float,real,double,,,datetime,var-char |
| |
| # PCDSOURCE ------------------------------------------------------------------ |
| |
| flagslist=PCDSOURCE-TYPE |
| 0x0001=spreadsheet |
| 0x0002=extern |
| 0x0004=consolidation-area |
| 0x0010=scenario |
| end |
| |
| # PHONETICPR ----------------------------------------------------------------- |
| |
| shortlist=PHONETICPR-TYPE,0,halfwidth-katakana,fullwidth-katakana,hiragana,no-conversion |
| shortlist=PHONETICPR-ALIGNMENT,0,no-control,left,center,distributed |
| |
| combilist=PHONETICPR-FLAGS |
| ignore=0xFFF0 |
| 0x0003=uint8,dec,type,PHONETICPR-TYPE |
| 0x000C=uint8,dec,alignment,PHONETICPR-ALIGNMENT |
| end |
| |
| # PROJEXTSHEET --------------------------------------------------------------- |
| |
| shortlist=PROJEXTSHEET-TYPE,0,sheet,macro,chart |
| |
| # PTDATAFIELD ---------------------------------------------------------------- |
| |
| shortlist=PTDATAFIELD-SUBTOTAL,0,sum,count-all,average,max,min,product,count-num,std-dev,std-dev-p,variance,variance-p |
| shortlist=PTDATAFIELD-SHOWDATAAS,0,normal,diff-from,percent-of,percent-diff-from,running-total-in,percent-of-row,percent-of-column,percent-of-total,index |
| |
| multilist=PTDATAFIELD-BASEITEM |
| default= |
| 0x7FFB=previous-item,next-item |
| end |
| |
| # PTDEFINITION --------------------------------------------------------------- |
| |
| flagslist=PTDEFINITION-FLAGS |
| 0x0001=row-grandtotals |
| 0x0002=column-grandtotals |
| 0x0008=auto-format |
| 0x0010=size-auto-format |
| 0x0020=font-auto-format |
| 0x0040=align-auto-format |
| 0x0080=border-auto-format |
| 0x0100=pattern-auto-format |
| 0x0200=number-auto-format |
| end |
| |
| constlist=PTDEFINITION-DATAFIELD-POS |
| default= |
| -1=append |
| end |
| |
| # PTDEFINITION2 -------------------------------------------------------------- |
| |
| combilist=PTDEFINITION2-FLAGS |
| 0x00000001=page-over-then-down |
| 0x000001FE=dec,uint8,page-wrap |
| 0x00010000=enable-wizard |
| 0x00020000=enable-drill |
| 0x00040000=enable-field-props |
| 0x00080000=preserve-formatting |
| 0x00100000=merge-labels |
| 0x00200000=show-error |
| 0x00400000=show-missing |
| 0x00800000=multiple-page-items |
| end |
| |
| # PTFIELD -------------------------------------------------------------------- |
| |
| flagslist=PTFIELD-AXISTYPE |
| 0x0001=row |
| 0x0002=column |
| 0x0004=page |
| 0x0008=data |
| end |
| |
| flagslist=PTFIELD-SUBTOTALS |
| 0x0001=default |
| 0x0002=sum |
| 0x0004=count-all |
| 0x0008=average |
| 0x0010=max |
| 0x0020=min |
| 0x0040=product |
| 0x0080=count-num |
| 0x0100=std-dev |
| 0x0200=std-dev-p |
| 0x0400=variance |
| 0x0800=variance-p |
| end |
| |
| # PTFIELD2 ------------------------------------------------------------------- |
| |
| combilist=PTFIELD2-FLAGS |
| 0x00000001=show-all-items |
| 0x00000002=drag-to-row |
| 0x00000004=drag-to-column |
| 0x00000008=drag-to-page |
| 0x00000010=drag-to-hide |
| 0x00000080=server-based |
| 0x00000200=autosort |
| 0x00000400=ascend-sort |
| 0x00000800=autoshow |
| 0x00001000=autoshow-top |
| 0x00002000=calculated |
| 0x00200000=outline |
| 0x00400000=insert-blank-row |
| 0x00800000=subtotal-top |
| 0xFF000000=uint8,dec,autoshow-item-count |
| end |
| |
| # PTFITEM -------------------------------------------------------------------- |
| |
| multilist=PTFITEM-ITEMTYPE |
| 0=data,default,sum,count-all,average,max,min,product,count-num,std-dev,std-dev-p,variance,variance-p,grandtotal |
| 254=page,none |
| end |
| |
| flagslist=PTFITEM-FLAGS |
| 0x0001=hidden |
| 0x0002=hide-detail |
| 0x0008=calculated |
| 0x0010=missing |
| end |
| |
| constlist=PTFITEM-CACHEIDX |
| default= |
| -1=no-cache-item |
| end |
| |
| # PTPAGEFIELDS --------------------------------------------------------------- |
| |
| constlist=PTPAGEFIELDS-ITEM |
| default= |
| 0x7FFD=all |
| end |
| |
| # PTROWCOLITEMS -------------------------------------------------------------- |
| |
| shortlist=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 |
| |
| combilist=PTROWCOLITEMS-FLAGS |
| ignore=0xC000 |
| 0x0001=field-name |
| 0x01FE=uint16,dec,data-field-idx |
| 0x0200=subtotal |
| 0x0400=blocktotal |
| 0x0800=grandtotal |
| 0x1000=multi-data |
| end |
| |
| # QUERYTABLE ----------------------------------------------------------------- |
| |
| combilist=QUERYTABLE-FLAGS |
| 0x0001=headers |
| 0x0002=row-numbers |
| 0x0004=disable-refresh |
| 0x0008=background |
| 0x0010=first-background |
| 0x0020=refresh-on-load |
| 0x0040=delete-unused |
| 0x0080=fill-formulas |
| 0x0100=adjust-column-width |
| 0x0200=save-data |
| 0x0400=disable-edit |
| 0x2000=overwrite-existing |
| end |
| |
| combilist=QUERYTABLE-AUTOFORMAT-FLAGS |
| 0x0001=apply-num-fmt |
| 0x0002=apply-font |
| 0x0004=apply-alignment |
| 0x0008=apply-border |
| 0x0010=apply-fill |
| 0x0020=apply-protection |
| end |
| |
| # QUERYTABLEREFRESH ---------------------------------------------------------- |
| |
| flagslist=QUERYTABLEREFRESH-FLAGS |
| 0x0001=enable-refresh |
| 0x0002=pivot-cache-invalid |
| 0x0004=olap-pivot-table |
| end |
| |
| flagslist=QUERYTABLEREFRESH-PTFLAGS |
| 0x00000001=disable-draw-drop |
| 0x00000002=hide-totals-annotation |
| 0x00000008=include-empty-rows |
| 0x00000010=include-empty-columns |
| end |
| |
| flagslist=QUERYTABLEREFRESH-QTFLAGS |
| 0x00000001=preserve-formatting |
| 0x00000002=adjust-column-width |
| 0x00000010=ext-data-list |
| 0x00000040=create-table-list |
| 0x00000080=create-dummy-list |
| end |
| |
| # QUERYTABLESETTINGS --------------------------------------------------------- |
| |
| flagslist=QUERYTABLESETTINGS-FLAGS |
| 0x0001=keep-alive |
| 0x0002=new |
| 0x0004=source-data |
| 0x0008=web-based-prov |
| 0x0010=reinit-list |
| 0x0080=xml |
| end |
| |
| flagslist=QUERYTABLESETTINGS-HTML-FLAGS |
| 0x0001=parse-pre |
| 0x0002=consecutive-delimiters |
| 0x0004=first-row |
| 0x0008=xl97-created |
| 0x0010=text-dates |
| 0x0020=xl2000-refreshed |
| end |
| |
| combilist=QUERYTABLESETTINGS-OLEDB-FLAGS |
| 0x0007=uint8,dec,command-type,QUERYTABLESETTINGS-OLEDB-COMMANDTYPE |
| 0x0008=alt-connection-string |
| 0x0010=no-refresh-cube |
| 0x0020=olap-has-locale |
| 0x0040=server-num-fmt |
| 0x0080=server-fill-color |
| 0x0100=server-font-color |
| 0x0200=server-font-format |
| 0x0400=olap-member-l10n |
| end |
| |
| shortlist=QUERYTABLESETTINGS-OLEDB-COMMANDTYPE,0,none,cube,sql,table,default,list |
| |
| flagslist=QUERYTABLESETTINGS-ADO-FLAGS |
| 0x0100=ado-refreshable |
| end |
| |
| flagslist=QUERYTABLESETTINGS-EXT-FLAGS |
| 0x0001=text-query |
| 0x0002=table-names |
| end |
| |
| unitconverter=QUERYTABLESETTINGS-INTERVAL,60,sec |
| shortlist=QUERYTABLESETTINGS-HTMLFORMAT,1,none,rtf,all |
| |
| # REFMODE -------------------------------------------------------------------- |
| |
| shortlist=REFMODE,0,R1C1,A1 |
| |
| # ROW ------------------------------------------------------------------------ |
| |
| combilist=ROW-HEIGHT |
| 0x7FFF=uint16,dec,height,CONV-TWIP-TO-PT |
| 0x8000=default-height |
| end |
| |
| combilist=ROW-FLAGS |
| ignore=0x00000100 |
| 0x00000007=uint8,dec,outline-level |
| 0x00000010=outline-collapsed |
| 0x00000020=hidden |
| 0x00000040=custom-height |
| 0x00000080=custom-format |
| 0x0FFF0000=uint16,dec,custom-xf-idx |
| 0x10000000=thick-top |
| 0x20000000=thick-bottom |
| 0x40000000=show-phonetic |
| end |
| |
| # SHAREDFEATHEAD ------------------------------------------------------------- |
| |
| shortlist=SHAREDFEATHEAD-TYPE,2,protection,ignored-formula-errors,smarttag,table |
| |
| flagslist=SHAREDFEATHEAD-PROT-FLAGS |
| 0x00000001=edit-object |
| 0x00000002=edit-scenario |
| 0x00000004=format-cell |
| 0x00000008=format-column |
| 0x00000010=format-row |
| 0x00000020=insert-column |
| 0x00000040=insert-row |
| 0x00000080=insert-hyperlink |
| 0x00000100=delete-column |
| 0x00000200=delete-row |
| 0x00000400=select-locked |
| 0x00000800=sort |
| 0x00001000=use-autofilter |
| 0x00002000=pivottable-report |
| 0x00004000=select-unlocked |
| end |
| |
| # SHEET ---------------------------------------------------------------------- |
| |
| shortlist=SHEET-STATE,0,visible,hidden,very-hidden |
| shortlist=SHEET-TYPE,0,worksheet,macrosheet,chartsheet,,,,vb-module |
| |
| # SHEETEXT ------------------------------------------------------------------- |
| |
| combilist=SHEETEXT-FLAGS1 |
| 0x0000007F=uint8,dec,color-idx,SHEETEXT-COLOR |
| end |
| |
| constlist=SHEETEXT-COLOR |
| include=COLORS |
| 0x7F=undefined |
| end |
| |
| combilist=SHEETEXT-FLAGS2 |
| include=SHEETEXT-FLAGS1 |
| 0x00000080=eval-cond-formats |
| 0x00000100=!published!unpublished |
| end |
| |
| # SHEETPR -------------------------------------------------------------------- |
| |
| shortlist=SHEETPR-WINDOWPOS,0,tiled,horizontal,vertical,cascaded |
| |
| flagslist=SHEETPR-FLAGS-BIFF3 |
| 0x0001=show-autopagebreaks |
| 0x0020=outline-auto-style |
| 0x0040=outline-symbols-below |
| 0x0080=outline-symbols-right |
| 0x0100=fit-to-pages |
| 0x0200=skip-linked-values |
| 0x0400=show-row-outline |
| 0x0800=show-column-outline |
| end |
| |
| flagslist=SHEETPR-FLAGS-BIFF4 |
| include=SHEETPR-FLAGS-BIFF3 |
| 0x3000=uint8,dec,window-pos,SHEETPR-WINDOWPOS |
| 0x4000=lotus-expr-eval |
| 0x8000=lotus-formula-edit |
| end |
| |
| flagslist=SHEETPR-FLAGS-BIFF5 |
| include=SHEETPR-FLAGS-BIFF4 |
| exclude=0x0200,0x3000 |
| 0x0010=dialog-sheet |
| end |
| |
| # STYLE ---------------------------------------------------------------------- |
| |
| combilist=STYLE-FLAGS |
| 0x0FFF=uint16,dec,xf-idx |
| 0x8000=builtin |
| end |
| |
| shortlist=STYLE-BUILTIN,-1,user-defined,normal,rowlevel,collevel,comma,currency,percent,comma-0,currency-0,hyperlink,followed-hyperlink |
| |
| # STYLEEXT ------------------------------------------------------------------- |
| |
| flagslist=STYLEEXT-FLAGS |
| 0x01=builtin |
| 0x02=hidden |
| 0x04=custom |
| end |
| |
| shortlist=STYLEEXT-CATEGORY,0,custom,good-bad-neutral,data-model,title-heading,themed,number-format |
| |
| multilist=STYLEEXT-BUILTIN |
| include=STYLE-BUILTIN |
| 10=note,warning-text,,,,title,heading-1,heading-2,heading-3,heading-4 |
| 20=input,output,calculation,check-cell,linked-cell,total,good,bad,neutral,accent1 |
| 30=20%-accent1,40%-accent1,60%-accent1,accent2,20%-accent2,40%-accent2,60%-accent2,accent3,20%-accent3,40%-accent3 |
| 40=60%-accent3,accent4,20%-accent4,40%-accent4,60%-accent4,accent5,20%-accent5,40%-accent5,60%-accent5,accent6 |
| 50=20%-accent6,40%-accent6,60%-accent6,explanatory-text |
| end |
| |
| # THEME ---------------------------------------------------------------------- |
| |
| constlist=THEME-VERSION |
| 0=custom |
| 123820=default |
| 124226=default |
| end |
| |
| # TXO ------------------------------------------------------------------------ |
| |
| combilist=TXO-FLAGS |
| 0x000E=uint16,dec,hor-align,OBJ-HORALIGN |
| 0x0070=uint16,dec,ver-align,OBJ-VERALIGN |
| 0x0200=text-locked |
| end |
| |
| # WINDOW1 -------------------------------------------------------------------- |
| |
| flagslist=WINDOW1-FLAGS |
| 0x0001=hidden |
| 0x0002=minimized |
| 0x0008=show-horizontal-scroll |
| 0x0010=show-vertical-scroll |
| 0x0020=show-tabbar |
| end |
| |
| unitconverter=WINDOW1-TABBARRATIO,/10,% |
| |
| # WINDOW2 -------------------------------------------------------------------- |
| |
| flagslist=WINDOW2-FLAGS-BIFF3 |
| 0x0001=show-formulas |
| 0x0002=show-gridlines |
| 0x0004=show-headings |
| 0x0008=frozen-panes |
| 0x0010=show-zeros |
| 0x0020=default-gridcolor |
| 0x0040=right-to-left |
| 0x0080=show-outline-symbols |
| 0x0100=remove-split-with-freeze |
| end |
| |
| flagslist=WINDOW2-FLAGS-BIFF5 |
| include=WINDOW2-FLAGS-BIFF3 |
| 0x0200=sheet-selected |
| 0x0400=sheet-active |
| end |
| |
| flagslist=WINDOW2-FLAGS-BIFF8 |
| include=WINDOW2-FLAGS-BIFF5 |
| 0x0800=pagebreak-mode |
| end |
| |
| # XF ------------------------------------------------------------------------- |
| |
| shortlist=XF-HORALIGN,0,general,left,center,right,fill,block,center-across-sel,distribute |
| shortlist=XF-VERALIGN,0,top,center,bottom,justify,distribute |
| shortlist=XF-TEXTDIRECTION,0,context,left-to-right,right-to-left |
| |
| flagslist=XF-PROTECTION-FLAGS |
| 0x01=locked |
| 0x02=formula-hidden |
| 0x04=style-xf |
| 0x08=apostroph-quote |
| end |
| |
| flagslist=XF-USEDATTRIBS-FLAGS |
| 0x04=format |
| 0x08=font |
| 0x10=alignment |
| 0x20=border |
| 0x40=area |
| 0x80=protection |
| end |
| |
| combilist=XF-STYLEFLAGS-BIFF2 |
| 0x07=uint8,dec,hor-align,XF-HORALIGN |
| 0x08=left-border |
| 0x10=right-border |
| 0x20=top-border |
| 0x40=bottom-border |
| 0x80=fill |
| end |
| |
| combilist=XF-TYPEFLAGS-BIFF2 |
| 0x3F=uint8,dec,fmt-idx,FORMATS |
| 0x40=locked |
| 0x80=formula-hidden |
| end |
| |
| flagslist=XF-TYPEFLAGS-BIFF3 |
| include=XF-PROTECTION-FLAGS |
| end |
| |
| combilist=XF-TYPEFLAGS-BIFF4 |
| include=XF-TYPEFLAGS-BIFF3 |
| 0xFFF0=uint16,dec,parent-xf-idx |
| end |
| |
| combilist=XF-ALIGNMENT-BIFF3 |
| 0x0007=uint8,dec,hor-align,XF-HORALIGN |
| 0x0008=text-wrap |
| 0xFFF0=uint16,dec,parent-xf-idx |
| end |
| |
| combilist=XF-ALIGNMENT-BIFF4 |
| 0x07=uint8,dec,hor-align,XF-HORALIGN |
| 0x08=text-wrap |
| 0x30=uint8,dec,ver-align,XF-VERALIGN |
| 0xC0=uint8,dec,orientation,TEXTORIENTATION |
| end |
| |
| combilist=XF-ALIGNMENT-BIFF5 |
| 0x07=uint8,dec,hor-align,XF-HORALIGN |
| 0x08=text-wrap |
| 0x70=uint8,dec,ver-align,XF-VERALIGN |
| 0x80=justify-lastline |
| end |
| |
| combilist=XF-ORIENTATTRIBS-BIFF5 |
| include=XF-USEDATTRIBS-FLAGS |
| 0x03=uint8,dec,orientation,TEXTORIENTATION |
| end |
| |
| combilist=XF-TEXTFLAGS-BIFF8 |
| 0x0F=uint8,dec,indent |
| 0x10=shrink-to-fit |
| 0xC0=uint8,dec,text-dir,XF-TEXTDIRECTION |
| end |
| |
| combilist=XF-FILL-BIFF3 |
| 0x003F=uint8,dec,fill-pattern,FILLPATTERNS |
| 0x07C0=uint8,dec,fg-color-idx,COLORS |
| 0xF800=uint8,dec,bg-color-idx,COLORS |
| end |
| |
| combilist=XF-BORDER-BIFF3 |
| 0x00000007=uint8,dec,top-style,BORDERSTYLES |
| 0x000000F8=uint8,dec,top-color,COLORS |
| 0x00000700=uint8,dec,left-style,BORDERSTYLES |
| 0x0000F800=uint8,dec,left-color,COLORS |
| 0x00070000=uint8,dec,bottom-style,BORDERSTYLES |
| 0x00F80000=uint8,dec,bottom-color,COLORS |
| 0x07000000=uint8,dec,right-style,BORDERSTYLES |
| 0xF8000000=uint8,dec,right-color,COLORS |
| end |
| |
| combilist=XF-FILL-BIFF5 |
| 0x0000007F=uint8,dec,fg-color-idx,COLORS |
| 0x00003F80=uint8,dec,bg-color-idx,COLORS |
| 0x003F0000=uint8,dec,fill-pattern,FILLPATTERNS |
| 0x01C00000=uint8,dec,bottom-style,BORDERSTYLES |
| 0xFE000000=uint8,dec,bottom-color,COLORS |
| end |
| |
| combilist=XF-BORDER-BIFF5 |
| 0x00000007=uint8,dec,top-style,BORDERSTYLES |
| 0x00000038=uint8,dec,left-style,BORDERSTYLES |
| 0x000001C0=uint8,dec,right-style,BORDERSTYLES |
| 0x0000FE00=uint8,dec,top-color,COLORS |
| 0x007F0000=uint8,dec,left-color,COLORS |
| 0x3F800000=uint8,dec,right-color,COLORS |
| end |
| |
| combilist=XF-BORDERSTYLE-BIFF8 |
| 0x000F=uint8,dec,left-style,BORDERSTYLES |
| 0x00F0=uint8,dec,right-style,BORDERSTYLES |
| 0x0F00=uint8,dec,top-style,BORDERSTYLES |
| 0xF000=uint8,dec,bottom-style,BORDERSTYLES |
| end |
| |
| combilist=XF-BORDERCOLOR1-BIFF8 |
| 0x007F=uint8,dec,left-color,COLORS |
| 0x3F80=uint8,dec,right-color,COLORS |
| 0x4000=diag-tl-to-br |
| 0x8000=diag-bl-to-tr |
| end |
| |
| combilist=XF-BORDERCOLOR2-BIFF8 |
| 0x0000007F=uint8,dec,top-color,COLORS |
| 0x00003F80=uint8,dec,bottom-color,COLORS |
| 0x001FC000=uint8,dec,diag-color,COLORS |
| 0x01E00000=uint8,dec,diag-style,BORDERSTYLES |
| 0xFC000000=uint8,dec,fill-pattern,FILLPATTERNS |
| end |
| |
| combilist=XF-FILLCOLOR-BIFF8 |
| 0x007F=uint8,dec,fg-color-idx,COLORS |
| 0x3F80=uint8,dec,bg-color-idx,COLORS |
| end |
| |
| # BIFF2 cell records ---------------------------------------------------------- |
| |
| constlist=XFINDEX-BIFF2 |
| default= |
| 63=from-ixfe |
| end |
| |
| combilist=CELL-XFINDEX-BIFF2 |
| 0x3F=uint8,dec,xf-idx,XFINDEX-BIFF2 |
| 0x40=locked |
| 0x80=formula-hidden |
| end |
| |
| combilist=CELL-XFFORMAT-BIFF2 |
| 0x3F=uint8,dec,fmt-idx,FORMATS |
| 0xC0=uint8,dec,font-idx,FONTNAMES |
| end |
| |
| combilist=CELL-XFSTYLE-BIFF2 |
| include=XF-STYLEFLAGS-BIFF2 |
| end |
| |
| # XFEXT ---------------------------------------------------------------------- |
| |
| multilist=XFEXT-SUBREC |
| 0=,,,,FILL-FGCOLOR |
| 5=FILL-BGCOLOR,FILL-GRADIENT,BORDER-TOP-COLOR,BORDER-BOTTOM-COLOR,BORDER-LEFT-COLOR |
| 10=BORDER-RIGHT-COLOR,BORDER-DIAG-COLOR,,TEXT-COLOR,FONT-SCHEME |
| 15=INDENT |
| end |
| |
| # ============================================================================ |