Hi, it seems I was the last one touching this around 2 1/2 years ago, but unfortunately I do not remember exactly why/how.
I found the file functionMetadataCetab-PDF.txt still lying around on my disk, it seems to be some extract of the PDF-SPECS that I did at that time. I attach it here, maybe it helps you in some way with this topic. Dominik.. On Fri, Oct 22, 2021 at 3:39 PM PJ Fanning <[email protected]> wrote: > Hi, > > Does anyone know anything about ExcelCetabFunctionExtractor > and functionMetadataCetab.txt? > > The file that ExcelCetabFunctionExtractor needs seems to be missing. > -- org/apache/poi/ss/formula/function/functionMetadataCetab-PDF.txt > > There is an issue related to FILTER function and how POI thinks that this > function takes 0 params (when it should take many params). > > https://bz.apache.org/bugzilla/show_bug.cgi?id=65643 > > > > Regards, > PJ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
0x0000 BEEP beep-params = [val] 0x0001 OPEN open-params = *17(val) 0x0002 OPEN.LINKS open-links-params = *15(val) 0x0003 CLOSE.ALL This function takes no parameters 756 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x0004 SAVE This function takes no parameters 0x0005 SAVE.AS save-as-params = *7(val) 0x0006 FILE.DELETE file-delete-params = [val] 0x0007 PAGE.SETUP page-setup-params = *30(val) 0x0008 PRINT print-params = *17(val) 0x0009 PRINTER.SETUP printer-setup-params = [val] 0x000A QUIT This function takes no parameters 0x000B NEW.WINDOW This function takes no parameters 0x000C ARRANGE.ALL arrange-All-params = *4(val) 0x000D WINDOW.SIZE window-size-params = *3(val) 0x000E WINDOW.MOVE window-move-params = *3(val) 0x000F FULL full-params = [val] 0x0010 CLOSE close-params = *2(val) 0x0011 RUN run-params = [(ref / val), [val]] 0x0016 SET.PRINT.AREA set-print-area-params = [ref / val] 757 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x0017 SET.PRINT.TITLES set-print-titles-params = *2(ref / val) 0x0018 SET.PAGE.BREAK This function takes no parameters 0x0019 REMOVE.PAGE.BREAK remove-page-break-params = *2(val) 0x001A FONT font-params = *2(val) 0x001B DISPLAY display-params = *9(val) 0x001C PROTECT.DOCUMENT protect-document-params = *7(val) 0x001D PRECISION precision-params = [val] 0x001E A1.R1C1 a1-r1c1-params = [val] 0x001F CALCULATE.NOW This function takes no parameters 0x0020 CALCULATION calculation-params = *11(val) 0x0022 DATA.FIND data-find-params = [val] 0x0023 EXTRACT extract-params = [val] 0x0024 DATA.DELETE This function takes no parameters 0x0025 SET.DATABASE This function takes no parameters 0x0026 SET.CRITERIA This function takes no parameters 758 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x0027 SORT sort-params = [val, [(ref / val), [(ref / val), [(ref / val), [(ref / val), [(ref / val), [(ref / val), *10(val)]]]]]]] 0x0028 DATA.SERIES data-series-params = *6(val) 0x0029 TABLE table-params = *2(ref / val) 0x002A FORMAT.NUMBER format-number-params = [val] 0x002B ALIGNMENT alignment-params = *10(val) 0x002C STYLE style-params = *2(val) 0x002D BORDER border-params = *27(val) 0x002E CELL.PROTECTION cell-protection-params = *2(val) 0x002F COLUMN.WIDTH column-width-params = [val, *4(ref / val)] 0x0030 UNDO This function takes no parameters 0x0031 CUT cut-params = *2(ref / val) 0x0032 COPY copy-params = *2(ref / val) 0x0033 PASTE paste-params = [ref / val] 0x0034 CLEAR clear-params = [val] 0x0035 PASTE.SPECIAL 759 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning paste-special-params = *7(val) 0x0036 EDIT.DELETE edit-delete-params = [val] 0x0037 INSERT insert-params = *2(val) 0x0038 FILL.RIGHT This function takes no parameters 0x0039 FILL.DOWN This function takes no parameters 0x003D DEFINE.NAME define-name-params = [val, [(ref / val), [(ref / val), [(ref / val), [(ref / val), [(ref / val),[val]]]]]]] 0x003E CREATE.NAMES create-names-params = *4(val) 0x003F FORMULA.GOTO formula-goto-params = [(ref / val), [val]] 0x0040 FORMULA.FIND formula-find-params = *12(val) 0x0041 SELECT.LAST.CELL This function takes no parameters 0x0042 SHOW.ACTIVE.CELL This function takes no parameters 0x0043 GALLERY.AREA gAllery-area-params = *2(val) 0x0044 GALLERY.BAR gAllery-bar-params = *2(val) 0x0045 GALLERY.COLUMN gAllery-column-params = *2(val) 0x0046 GALLERY.LINE gAllery-line-params = *2(val) 760 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x0047 GALLERY.PIE gAllery-pie-params = *2(val) 0x0048 GALLERY.SCATTER gAllery-scatter-params = *2(val) 0x0049 COMBINATION combination-params = [val] 0x004A PREFERRED This function takes no parameters 0x004B ADD.OVERLAY This function takes no parameters 0x004C GRIDLINES gridlines-params = *7(val) 0x004D SET.PREFERRED set-preferred-params = [val] 0x004E AXES axes-params = *6(val) 0x004F LEGEND legend-params = [val] 0x0050 ATTACH.TEXT attach-text-params = *3(val) 0x0051 ADD.ARROW This function takes no parameters 0x0052 SELECT.CHART This function takes no parameters 0x0053 SELECT.PLOT.AREA This function takes no parameters 0x0054 PATTERNS patterns-params = *13(val) 0x0055 MAIN.CHART main-chart-params = *10(val) 761 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x0056 OVERLAY overlay-params = *12(val) 0x0057 SCALE scale-params = *10(val) 0x0058 FORMAT.LEGEND format-legend-params = [val] 0x0059 FORMAT.TEXT format-text-params = *11(val) 0x005A EDIT.REPEAT This function takes no parameters 0x005B PARSE parse-params = [val, [ref / val]] 0x005C JUSTIFY This function takes no parameters 0x005D HIDE This function takes no parameters 0x005E UNHIDE unhide-params = [val] 0x005F WORKSPACE workspace-params = *16(val) 0x0060 FORMULA formula-params = [val, [ref / val]] 0x0061 FORMULA.FILL formula-fill-params = [val, [ref / val]] 0x0062 FORMULA.ARRAY formula-array-params = [val, [ref / val]] 0x0063 DATA.FIND.NEXT This function takes no parameters 0x0064 DATA.FIND.PREV This function takes no parameters 762 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x0065 FORMULA.FIND.NEXT This function takes no parameters 0x0066 FORMULA.FIND.PREV This function takes no parameters 0x0067 ACTIVATE activate-params = *2(val) 0x0068 ACTIVATE.NEXT activate-next-params = [val] 0x0069 ACTIVATE.PREV activate-prev-params = [val] 0x006A UNLOCKED.NEXT This function takes no parameters 0x006B UNLOCKED.PREV This function takes no parameters 0x006C COPY.PICTURE copy-picture-params = *3(val) 0x006D SELECT select-params = *2(ref / val) 0x006E DELETE.NAME delete-name-params = [val] 0x006F DELETE.FORMAT delete-format-params = [val] 0x0070 VLINE vline-params = [val] 0x0071 HLINE hline-params = [val] 0x0072 VPAGE vpage-params = [val] 0x0073 HPAGE hpage-params = [val] 763 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x0074 VSCROLL vscroll-params = *2(val) 0x0075 HSCROLL hscroll-params = *2(val) 0x0076 ALERT alert-params = *3(val) 0x0077 NEW new-params = *3(val) 0x0078 CANCEL.COPY cancel-copy-params = [val] 0x0079 SHOW.CLIPBOARD This function takes no parameters 0x007A MESSAGE message-params = *2(val) 0x007C PASTE.LINK This function takes no parameters 0x007D APP.ACTIVATE app-activate-params = *2(val) 0x007E DELETE.ARROW This function takes no parameters 0x007F ROW.HEIGHT row-height-params = [val, *3(ref / val)] 0x0080 FORMAT.MOVE format-move-params = [val, *2(ref / val)] 0x0081 FORMAT.SIZE format-size-params = [val, *2(ref / val)] 0x0082 FORMULA.REPLACE formula-replace-params = *11(val) 0x0083 SEND.KEYS send-keys-params = *2(val) 764 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x0084 SELECT.SPECIAL select-special-params = *3(val) 0x0085 APPLY.NAMES apply-names-params = *7(val) 0x0086 REPLACE.FONT replace-font-params = *10(val) 0x0087 FREEZE.PANES freeze-panes-params = *3(val) 0x0088 SHOW.INFO show-info-params = [val] 0x0089 SPLIT split-params = *2(val) 0x008A ON.WINDOW on-window-params = *2(val) 0x008B ON.DATA on-data-params = *2(val) 0x008C DISABLE.INPUT disable-input-params = [val] 0x008E OUTLINE outline-params = *4(val) 0x008F LIST.NAMES This function takes no parameters 0x0090 FILE.CLOSE file-close-params = *2(val) 0x0091 SAVE.WORKBOOK save-workbook-params = *6(val) 0x0092 DATA.FORM This function takes no parameters 0x0093 COPY.CHART copy-chart-params = [val] 765 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x0094 ON.TIME on-time-params = *4(val) 0x0095 WAIT wait-params = [val] 0x0096 FORMAT.FONT format-font-params = *15(val) 0x0097 FILL.UP This function takes no parameters 0x0098 FILL.LEFT This function takes no parameters 0x0099 DELETE.OVERLAY This function takes no parameters 0x009B SHORT.MENUS short-menus-params = [val] 0x009F SET.UPDATE.STATUS set-update-status-params = *3(val) 0x00A1 COLOR.PALETTE color-palette-params = [val] 0x00A2 DELETE.STYLE delete-style-params = [val] 0x00A3 WINDOW.RESTORE window-restore-params = [val] 0x00A4 WINDOW.MAXIMIZE window-maximize-params = [val] 0x00A6 CHANGE.LINK change-link-params = *3(val) 0x00A7 CALCULATE.DOCUMENT This function takes no parameters 0x00A8 ON.KEY on-key-params = *2(val) 766 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x00A9 APP.RESTORE This function takes no parameters 0x00AA APP.MOVE app-move-params = *2(val) 0x00AB APP.SIZE app-size-params = *2(val) 0x00AC APP.MINIMIZE This function takes no parameters 0x00AD APP.MAXIMIZE This function takes no parameters 0x00AE BRING.TO.FRONT This function takes no parameters 0x00AF SEND.TO.BACK This function takes no parameters 0x00B9 MAIN.CHART.TYPE main-chart-type-params = [val] 0x00BA OVERLAY.CHART.TYPE overlay-chart-type-params = [val] 0x00BB SELECT.END select-end-params = [val] 0x00BC OPEN.MAIL open-mail-params = *2(val) 0x00BD SEND.MAIL send-mail-params = [(ref / val), *2(val)] 0x00BE STANDARD.FONT standard-font-params = *9(val) 0x00BF CONSOLIDATE consolidate-params = *5(val) 0x00C0 SORT.SPECIAL sort-special-params = [val, [val, [(ref / val), [(ref / val), [(ref / val), [(ref / val), [(ref / val), [(ref / val), *6(val)]]]]]]]] 0x00C1 GALLERY.3D.AREA gAllery-3d-area-params = [val] 0x00C2 GALLERY.3D.COLUMN gAllery-3d-column-params = [val] 0x00C3 GALLERY.3D.LINE gAllery-3d-line-params = [val] 0x00C4 GALLERY.3D.PIE gAllery-3d-pie-params = [val] 0x00C5 VIEW.3D view-3d-params = *6(val) 0x00C6 GOAL.SEEK goal-seek-params = *3(ref / val) 0x00C7 WORKGROUP workgroup-params = [val] 0x00C8 FILL.GROUP fill-group-params = [val] 0x00C9 UPDATE.LINK update-link-params = *2(val) 0x00CA PROMOTE promote-params = [val] 0x00CB DEMOTE demote-params = [val] 0x00CC SHOW.DETAIL show-detail-params = *4(val) 0x00CE UNGROUP This function takes no parameters 0x00CF OBJECT.PROPERTIES object-properties-params = *2(val) 0x00D0 SAVE.NEW.OBJECT 768 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning save-new-object-params = [val] 0x00D1 SHARE This function takes no parameters 0x00D2 SHARE.NAME share-name-params = [val] 0x00D3 DUPLICATE This function takes no parameters 0x00D4 APPLY.STYLE apply-style-params = [val] 0x00D5 ASSIGN.TO.OBJECT assign-to-object-params = [ref / val] 0x00D6 OBJECT.PROTECTION object-protection-params = *2(val) 0x00D7 HIDE.OBJECT hide-object-params = *2(val) 0x00D8 SET.EXTRACT This function takes no parameters 0x00D9 CREATE.PUBLISHER create-publisher-params = *4(val) 0x00DA SUBSCRIBE.TO subscribe-to-params = *2(val) 0x00DB ATTRIBUTES attributes-params = *2(val) 0x00DC SHOW.TOOLBAR show-toolbar-params = *10(val) 0x00DE PRINT.PREVIEW print-preview-params = [val] 0x00DF EDIT.COLOR edit-color-params = *4(val) 0x00E0 SHOW.LEVELS 769 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning show-levels-params = *2(val) 0x00E1 FORMAT.MAIN format-main-params = *14(val) 0x00E2 FORMAT.OVERLAY format-overlay-params = *14(val) 0x00E3 ON.RECALC on-recalc-params = *2(val) 0x00E4 EDIT.SERIES edit-series-params = [val, *6(ref / val)] 0x00E5 DEFINE.STYLE define-style-params = *14(val) 0x00F0 LINE.PRINT line-print-params = *11(val) 0x00F3 ENTER.DATA enter-data-params = [ref / val] 0x00F9 GALLERY.RADAR gAllery-radar-params = *2(val) 0x00FA MERGE.STYLES merge-styles-params = [val] 0x00FB EDITION.OPTIONS edition-options-params = [val, *6(ref / val)] 0x00FC PASTE.PICTURE This function takes no parameters 0x00FD PASTE.PICTURE.LINK This function takes no parameters 0x00FE SPELLING spelling-params = *6(val) 0x0100 ZOOM zoom-params = [val] 0x0103 INSERT.OBJECT 770 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning insert-object-params = [val, [val, [val, [val, [val, [val, [val, [(ref / val), [val, [val, [(ref / val), *2(val)]]]]]]]]]]] 0x0104 WINDOW.MINIMIZE window-minimize-params = [val] 0x0109 SOUND.NOTE sound-note-params = [(ref / val), *2(val)] 0x010A SOUND.PLAY sound-play-params = [(ref / val), *2(val)] 0x010B FORMAT.SHAPE format-shape-params = [val, [val, [(ref / val), *2(val)]]] 0x010C EXTEND.POLYGON extend-polygon-params = [val] 0x010D FORMAT.AUTO format-auto-params = *7(val) 0x0110 GALLERY.3D.BAR gAllery-3d-bar-params = [val] 0x0111 GALLERY.3D.SURFACE gAllery-3d-surface-params = [val] 0x0112 FILL.AUTO fill-auto-params = [(ref / val), [val]] 0x0114 CUSTOMIZE.TOOLBAR customize-toolbar-params = [val] 0x0115 ADD.TOOL add-tool-params = *3(val) 0x0116 EDIT.OBJECT edit-object-params = [val] 0x0117 ON.DOUBLECLICK on-doubleclick-params = *2(val) 0x0118 ON.ENTRY on-entry-params = *2(val) 771 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x0119 WORKBOOK.ADD workbook-add-params = *3(val) 0x011A WORKBOOK.MOVE workbook-move-params = *3(val) 0x011B WORKBOOK.COPY workbook-copy-params = *3(val) 0x011C WORKBOOK.OPTIONS workbook-options-params = *3(val) 0x011D SAVE.WORKSPACE save-workspace-params = [val] 0x0120 CHART.WIZARD chart-wizard-params = [val, [(ref / val), *12(val)]] 0x0121 DELETE.TOOL delete-tool-params = *2(val) 0x0122 MOVE.TOOL move-tool-params = *6(val) 0x0123 WORKBOOK.SELECT workbook-select-params = *3(val) 0x0124 WORKBOOK.ACTIVATE workbook-activate-params = *2(val) 0x0125 ASSIGN.TO.TOOL assign-to-tool-params = [val, [val, [ref / val]]] 0x0127 COPY.TOOL copy-tool-params = *2(val) 0x0128 RESET.TOOL reset-tool-params = *2(val) 0x0129 CONSTRAIN.NUMERIC constrain-numeric-params = [val] 0x012A PASTE.TOOL paste-tool-params = *2(val) 772 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x012E WORKBOOK.NEW workbook-new-params = *3(val) 0x0131 SCENARIO.CELLS scenario-cells-params = [ref / val] 0x0132 SCENARIO.DELETE scenario-delete-params = [val] 0x0133 SCENARIO.ADD scenario-add-params = [val, [val, [(ref / val), *3(val)]]] 0x0134 SCENARIO.EDIT scenario-edit-params = [val, [val, [val, [(ref / val), *3(val)]]]] 0x0135 SCENARIO.SHOW scenario-show-params = [val] 0x0136 SCENARIO.SHOW.NEXT This function takes no parameters 0x0137 SCENARIO.SUMMARY scenario-summary-params = [(ref / val), [val]] 0x0138 PIVOT.TABLE.WIZARD pivot-table-wizard-params = [val, [(ref / val), [(ref / val), *13(val)]]] 0x0139 PIVOT.FIELD.PROPERTIES pivot-field-properties-params = *7(val) 0x013A PIVOT.FIELD pivot-field-params = *4(val) 0x013B PIVOT.ITEM pivot-item-params = *4(val) 0x013C PIVOT.ADD.FIELDS pivot-add-fields-params = *5(val) 0x013E OPTIONS.CALCULATION options-calculation-params = *10(val) 0x013F OPTIONS.EDIT options-edit-params = *11(val) 773 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x0140 OPTIONS.VIEW options-view-params = *18(val) 0x0141 ADDIN.MANAGER addin-manager-params = *3(val) 0x0142 MENU.EDITOR This function takes no parameters 0x0143 ATTACH.TOOLBARS This function takes no parameters 0x0144 VBAActivate vbaactivate-params = *2(val) 0x0145 OPTIONS.CHART options-chart-params = *3(val) 0x0148 VBA.INSERT.FILE vba-insert-file-params = [val] 0x014A VBA.PROCEDURE.DEFINITION This function takes no parameters 0x0150 ROUTING.SLIP routing-slip-params = [(ref / val), *5(val)] 0x0152 ROUTE.DOCUMENT This function takes no parameters 0x0153 MAIL.LOGON mail-logon-params = [(ref / val), [(ref / val), [val]]] 0x0156 INSERT.PICTURE insert-picture-params = *2(val) 0x0157 EDIT.TOOL edit-tool-params = *2(val) 0x0158 GALLERY.DOUGHNUT gAllery-doughnut-params = *2(val) 0x015E CHART.TREND chart-trend-params = *8(val) 774 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x0160 PIVOT.ITEM.PROPERTIES pivot-item-properties-params = *7(val) 0x0162 WORKBOOK.INSERT workbook-insert-params = [val] 0x0163 OPTIONS.TRANSITION options-transition-params = *5(val) 0x0164 OPTIONS.GENERAL options-general-params = *14(val) 0x0172 FILTER.ADVANCED filter-advanced-params = [val, [(ref / val), [(ref / val), [(ref / val), [val]]]]] 0x0175 MAIL.ADD.MAILER This function takes no parameters 0x0176 MAIL.DELETE.MAILER This function takes no parameters 0x0177 MAIL.REPLY This function takes no parameters 0x0178 MAIL.REPLY.ALL This function takes no parameters 0x0179 MAIL.FORWARD This function takes no parameters 0x017A MAIL.NEXT.LETTER This function takes no parameters 0x017B DATA.LABEL data-label-params = *10(val) 0x017C INSERT.TITLE insert-title-params = *5(val) 0x017D FONT.PROPERTIES font-properties-params = *14(val) 0x017E MACRO.OPTIONS macro-options-params = *10(val) 775 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x017F WORKBOOK.HIDE workbook-hide-params = *2(val) 0x0180 WORKBOOK.UNHIDE workbook-unhide-params = [val] 0x0181 WORKBOOK.DELETE workbook-delete-params = [val] 0x0182 WORKBOOK.NAME workbook-name-params = *2(val) 0x0184 GALLERY.CUSTOM gAllery-custom-params = [val] 0x0186 ADD.CHART.AUTOFORMAT add-chart-autoformat-params = *2(val) 0x0187 DELETE.CHART.AUTOFORMAT delete-chart-autoformat-params = [val] 0x0188 CHART.ADD.DATA chart-add-data-params = [val, [(ref / val), *4(val)]] 0x0189 AUTO.OUTLINE This function takes no parameters 0x018A TAB.ORDER This function takes no parameters 0x018B SHOW.DIALOG show-dialog-params = [val] 0x018C SELECT.ALL This function takes no parameters 0x018D UNGROUP.SHEETS This function takes no parameters 0x018E SUBTOTAL.CREATE subtotal-create-params = *6(val) 0x018F SUBTOTAL.REMOVE This function takes no parameters 776 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x0190 RENAME.OBJECT rename-object-params = [val] 0x019C WORKBOOK.SCROLL workbook-scroll-params = *2(val) 0x019D WORKBOOK.NEXT This function takes no parameters 0x019E WORKBOOK.PREV This function takes no parameters 0x019F WORKBOOK.TAB.SPLIT workbook-tab-split-params = [val] 0x01A0 FULL.SCREEN full-screen-params = [val] 0x01A1 WORKBOOK.PROTECT workbook-protect-params = *3(val) 0x01A4 SCROLLBAR.PROPERTIES scrollbar-properties-params = *7(val) 0x01A5 PIVOT.SHOW.PAGES pivot-show-pages-params = *2(val) 0x01A6 TEXT.TO.COLUMNS text-to-columns-params = [val, [(ref / val), *12(val)]] 0x01A7 FORMAT.CHARTTYPE format-charttype-params = *4(val) 0x01A8 LINK.FORMAT This function takes no parameters 0x01A9 TRACER.DISPLAY tracer-display-params = *2(val) 0x01AE TRACER.NAVIGATE tracer-navigate-params = *3(val) 0x01AF TRACER.CLEAR This function takes no parameters 777 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x01B0 TRACER.ERROR This function takes no parameters 0x01B1 PIVOT.FIELD.GROUP pivot-field-group-params = *4(val) 0x01B2 PIVOT.FIELD.UNGROUP This function takes no parameters 0x01B3 CHECKBOX.PROPERTIES checkbox-properties-params = *5(val) 0x01B4 LABEL.PROPERTIES label-properties-params = *3(val) 0x01B5 LISTBOX.PROPERTIES listbox-properties-params = *5(val) 0x01B6 EDITBOX.PROPERTIES editbox-properties-params = *4(val) 0x01B7 PIVOT.REFRESH pivot-refresh-params = [val] 0x01B8 LINK.COMBO link-combo-params = [val] 0x01B9 OPEN.TEXT open-text-params = *17(val) 0x01BA HIDE.DIALOG hide-dialog-params = [val] 0x01BB SET.DIALOG.FOCUS set-dialog-focus-params = [val] 0x01BC ENABLE.OBJECT enable-object-params = *2(val) 0x01BD PUSHBUTTON.PROPERTIES pushbutton-properties-params = *6(val) 0x01BE SET.DIALOG.DEFAULT set-dialog-default-params = [val] 778 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x01BF FILTER filter-params = *6(val) 0x01C0 FILTER.SHOW.ALL This function takes no parameters 0x01C1 CLEAR.OUTLINE This function takes no parameters 0x01C2 FUNCTION.WIZARD function-wizard-params = [val] 0x01C3 ADD.LIST.ITEM add-list-item-params = *2(val) 0x01C4 SET.LIST.ITEM set-list-item-params = *2(val) 0x01C5 REMOVE.LIST.ITEM remove-list-item-params = *2(val) 0x01C6 SELECT.LIST.ITEM select-list-item-params = *2(val) 0x01C7 SET.CONTROL.VALUE set-control-value-params = [val] 0x01C8 SAVE.COPY.AS save-copy-as-params = [val] 0x01CA OPTIONS.LISTS.ADD options-lists-add-params = [val, [ref / val]] 0x01CB OPTIONS.LISTS.DELETE options-lists-delete-params = [val] 0x01CC SERIES.AXES series-axes-params = [val] 0x01CD SERIES.X series-x-params = [ref / val] 0x01CE SERIES.Y series-y-params = *2(ref / val) 779 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x01CF ERRORBAR.X errorbar-x-params = [val, [val, [val, [ref / val]]]] 0x01D0 ERRORBAR.Y errorbar-y-params = [val, [val, [val, [ref / val]]]] 0x01D1 FORMAT.CHART format-chart-params = [(ref / val), *17(val)] 0x01D2 SERIES.ORDER series-order-params = *3(val) 0x01D3 MAIL.LOGOFF This function takes no parameters 0x01D4 CLEAR.ROUTING.SLIP clear-routing-slip-params = [val] 0x01D5 APP.ACTIVATE.MICROSOFT app-activate-microsoft-params = [val] 0x01D6 MAIL.EDIT.MAILER mail-edit-mailer-params = [val, [(ref / val), [(ref / val), [(ref / val), [val, [ref / val]]]]]] 0x01D7 ON.SHEET on-sheet-params = *3(val) 0x01D8 STANDARD.WIDTH standard-width-params = [val] 0x01D9 SCENARIO.MERGE scenario-merge-params = [val] 0x01DA SUMMARY.INFO summary-info-params = *5(val) 0x01DB FIND.FILE This function takes no parameters 0x01DC ACTIVE.CELL.FONT active-cell-font-params = *14(val) 0x01DD ENABLE.TIPWIZARD enable-tipwizard-params = [val] 780 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x01DE VBA.MAKE.ADDIN vba-make-addin-params = [val] 0x01E0 INSERTDATATABLE insertdatatable-params = [val] 0x01E1 WORKGROUP.OPTIONS This function takes no parameters 0x01E2 MAIL.SEND.MAILER mail-send-mailer-params = *2(val) 0x01E5 AUTOCORRECT autocorrect-params = *2(val) 0x01E9 POST.DOCUMENT post-document-params = [val] 0x01EB PICKLIST This function takes no parameters 0x01ED VIEW.SHOW view-show-params = [val] 0x01EE VIEW.DEFINE view-define-params = *3(val) 0x01EF VIEW.DELETE view-delete-params = [val] 0x01FD SHEET.BACKGROUND sheet-background-params = *2(val) 0x01FE INSERT.MAP.OBJECT This function takes no parameters 0x01FF OPTIONS.MENONO options-menono-params = *5(val) 0x0205 MSOCHECKS This function takes no parameters 0x0206 NORMAL This function takes no parameters 781 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x0207 LAYOUT This function takes no parameters 0x0208 RM.PRINT.AREA rm-print-area-params = [ref / val] 0x0209 CLEAR.PRINT.AREA This function takes no parameters 0x020A ADD.PRINT.AREA This function takes no parameters 0x020B MOVE.BRK move-brk-params = *4(val) 0x0221 HIDECURR.NOTE hidecurr-note-params = [(ref / val), [val]] 0x0222 HIDEALL.NOTES hideall-notes-params = [val] 0x0223 DELETE.NOTE delete-note-params = [ref / val] 0x0224 TRAVERSE.NOTES traverse-notes-params = [(ref / val), [val]] 0x0225 ACTIVATE.NOTES activate-notes-params = [(ref / val), [val]] 0x026C PROTECT.REVISIONS This function takes no parameters 0x026D UNPROTECT.REVISIONS This function takes no parameters 0x0287 OPTIONS.ME options-me-params = [(ref / val), *8(val)] 0x028D WEB.PUBLISH web-publish-params = *9(val) 0x029B NEWWEBQUERY newwebquery-params = [val] 782 / 1185 [MS-XLS] — v20141018 Excel Binary File Format (.xls) Structure Copyright © 2014 Microsoft Corporation. Release: October 30, 2014Value Meaning 0x02A1 PIVOT.TABLE.CHART pivot-table-chart-params = [val, [(ref / val), [(ref / val), *13(val)]]] 0x02F1 OPTIONS.SAVE options-save-params = *4(val) 0x02F3 OPTIONS.SPELL options-spell-params = *12(val) 0x0328 HIDEALL.INKANNOTS hideall-inkannots-params = [val]
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
