summaryrefslogtreecommitdiff
path: root/oox/source/dump/xlsbdumper.ini
blob: 9a28f8268537c0ec2abf8cfcb172bf7efe789c66 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
#
# This file is part of the LibreOffice project.
#
# This Source Code Form is subject to the terms of the Mozilla Public
# License, v. 2.0. If a copy of the MPL was not distributed with this
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
# This file incorporates work covered by the following license notice:
#
#   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 .
#

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

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

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

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

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

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

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

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

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

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

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

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

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

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

constlist=TEXTROTATION
  default=
  255=stacked
end

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

flagslist=CHARTSHEETPR-FLAGS
  0x0001=published
end

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

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

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

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

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

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

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

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

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

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

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

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

shortlist=CUSTOMFILTERS-RELATION,0,and,or

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

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

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

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

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

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

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

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

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

shortlist=DEFINEDNAME-FUNCGROUP,0,none,financial,date-time,math-trig,statistical,lookup-ref,database,text,logical,information,commands,customizing,macro-control,dde-external,user-definded

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

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

shortlist=DISCRETEFILTERS-CALTYPE,0,none,gregorian,gregorian-us,japan,taiwan,korea,hijri,thai,hebrew,gregorian-mideast-fr,gregorian-ar,gregorian-xlit-en,gregorian-xlit-fr

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

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

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

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

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

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

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

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

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

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

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

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

shortlist=FILL-GRADIENTTYPE,0,linear,path

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

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

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

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

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

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

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

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

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

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

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

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

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

constlist=PAGESETUP-SCALETOPAGES
  default=
  0=automatic
end

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

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

unitconverter=PAGESETUP-DPI,1,dpi

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

multilist=PTFILTER-TYPE
  0=unknown,count,percent,sum,caption-equal,caption-not-equal,caption-begins-width,caption-not-begins-with,caption-ends-width,caption-not-ends-with
  10=caption-contains,caption-not-contains,caption-greater-than,caption-greater-equal,caption-less-than,caption-less-equal,caption-between,caption-not-between,value-equal,value-not-equal
  20=value-greater-than,value-greater-equal,value-less-than,value-less-equal,value-between,value-not-between,date-equal,date-older-than,date-newer-than,date-between
  30=date-tomorrow,date-today,date-yesterday,date-next-week,date-this-week,date-last-week,date-next-month,date-this-month,date-last-month,date-next-quarter
  40=date-this-quarter,date-last-quarter,date-next-year,date-this-year,date-last-year,year-to-date,date-q1,date-q2,date-q3,date-q4
  50=date-jan,date-feb,date-mar,date-apr,date-may,date-jun,date-jul,date-aug,date-sep,date-oct
  60=date-nov,date-dec,date-not-equal,date-older-equal,date-newer-equal,date-not-between
end

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

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

shortlist=PTFITEM-TYPE,0,data,default,sum,count-all,average,max,min,product,count-numbers,std-dev,std-dev-p,var,var-p,grand-total,blank

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

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

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

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

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

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

flagslist=PTREFERENCE-FLAGS2
  0x01=selected
end

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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