Skip to content

History / command reference

Revisions

  • docs: fold 'check' command into 'view issues' The standalone check command was merged into view <file> issues. Replace command-check.md with a migration stub, remove check row from Home/command-reference tables, and document overflow detection (ID prefix O, Format+Warning) in the view issues section.

    @goworm goworm committed Apr 19, 2026
  • Update wiki for v1.0.53: check command, PPT features, Excel round-15 New check command documented (text overflow detection for .pptx/.xlsx). PowerPoint: - ppt-placeholder: document placeholder Add (phType, text, name) - ppt-slide-set: showFooter/showSlideNumber/showDate/showHeader toggles - ppt-picture-add: fill=stretch/contain/cover/tile + tilescale/align/flip - ppt-shape-add/set: pattern fill, blur effect, hyperlink tooltip + internal slide-jump links - ppt-paragraph-add: level, lineSpacing, spaceBefore, spaceAfter Excel (round-15 property audit): - excel-cell-add: type=error tokens, value+formula conflict warning, 32767-char limit, ISO datetime with time, cell-ref path tail, _xlfn. auto-prefix for dynamic-array functions, --from row copy - excel-cell-set: merge comma-list, hyperlink location attr for internal - excel-chart-add: legend topRight, gradientFill, series{N}.color, name, anchor, logBase/logScale/yAxisScale=log, axis labelRotation, dataLabels.show{Value,Percent,CatName,SerName,LegendKey} - excel-conditionalformatting-add: aboveAverage stdDev/equalAverage, cellIs+operators+dxf, full font sub-props - excel-picture-add: flipH/flipV/flipBoth, cropLeft/Right/Top/Bottom, anchor cell-range syntax - excel-shape-add: flipH/flipV/flipBoth aliases, anchor/ref cell-range, all OOXML ST_ShapeType presets via reflection - excel-table-add: showTotals alias - excel-slicer: anchor cell-range syntax - excel-namedrange-add: /namedrange[NAME] path bracket - excel-workbook-set: activeTab, firstSheet Word: - word-run-set: full OOXML underline enum (wavy/wavyHeavy/dottedHeavy/...) - word-paragraph-set: firstLineIndent accepts unit-qualified strings - word-section-set: /body/sectPr[N] canonical path accepted Added command-check.md to Home and command-reference index. Bump all version footers + version.json/md to v1.0.53.

    @goworm goworm committed Apr 19, 2026
  • Update wiki for v1.0.52: Excel property audit — wire up dropped props Excel round-14 audit wired up many previously silently-dropped properties: - excel-validation-add: errorStyle, inCellDropdown, time/date/custom formula normalization, list formula-ref pass-through - excel-namedrange-add: refersTo alias, name validated per OOXML §18.2.5 - excel-conditionalformatting-add: stopIfTrue, dataBar showValue, colorScale midpoint, CF types (topN rank, aboveAverage/belowAverage, containsBlanks, contains, beginsWith/endsWith, dateoccurring) - excel-table-add: showHeader alias, totalsRowFunction per-column, showBandedRows/Columns, showFirstColumn/LastColumn, style whitelist - excel-picture-add: name/altText/title, rotation/flip, EMU auto-detect - excel-shape-add: preset/geometry, rotation, flip - excel-comment-add: duplicate-cell rejection, \n → LF - excel-autofilter-add: range validation - excel-sparkline-add: winloss/win-loss aliases - excel-sheet: tabColor scheme color names (accent1-6, lt1/dk1, etc.) - excel-cell-set: hyperlink tooltip/screenTip, row/col unit-qualified sizes (pt/px/cm/in), internal hyperlink as location attr - excel-cell-add: array formula literal braces rejected, literal value clears stale formula - excel-chart-add: legend topRight (→ OOXML 'tr') Bump all version footers + version.json/md to v1.0.52

    @goworm goworm committed Apr 18, 2026
  • Update wiki for v1.0.51: Excel table name/column sanitization - excel-table-add: document auto-sanitization of table names that look like cell references (tbl1 → tbl1_), numeric header cells auto-retyped as inlineStr, and duplicate column names auto-deduped with suffix - Bump all version footers + version.json/md to v1.0.51

    @goworm goworm committed Apr 17, 2026
  • Update wiki for v1.0.50: expanded Word HTML preview capability list - command-view-word: broaden html mode feature list to cover v1.0.50 rendering additions (tracked del + ins, line numbers, tab stops, per-section layout, rotation/flip/border/shadow on images, SVG-preferred blips, CJK emphasis, ruby/furigana, bidi, altChunk, VML watermarks, form field glyphs, theme fallback, lvlOverride, etc.) - Bump all version footers + version.json/md to v1.0.50

    @goworm goworm committed Apr 17, 2026
  • Update wiki for v1.0.49: expanded Word field types, HTML preview fixes - word-field-add: rewrite with 22 zero-param types + 6 parameterized types (mergefield, ref/pageref/noteref, seq, styleref, docproperty, if) - word-field: update description to reflect new field categories - Bump all version footers + version.json/md to v1.0.49

    @goworm goworm committed Apr 16, 2026
  • Update wiki for v1.0.48: Excel sort, Pareto chart, SVG import - excel-sheet: document sort/sortHeader properties with examples, sidecar movement, merge/formula rejection, protection rules - excel-chart-add: add pareto chart type with auto-sort + cumulative-% overlay line example - word-picture-add, excel-picture-add, ppt-picture-add: document SVG import with dual representation (SVG + PNG fallback) and fallback prop - Bump all version footers + version.json/md to v1.0.48

    @goworm goworm committed Apr 16, 2026
  • Update wiki for v1.0.47: box-whisker rendering, Excel Get date/% formatting - excel-chart-boxwhisker: document HTML preview (IQR fences, outliers, mean marker), per-group multi-series usage with colors= - excel-cell-get: note value is formatted via cell number format for date/percent cells (e.g. "2024-01-15" not 45306) - Bump all version footers + version.json/md to v1.0.47

    @goworm goworm committed Apr 14, 2026
  • Update wiki for v1.0.46: Windows install fix, version bump Co-Authored-By: zmworm <noreply@github.com>

    @goworm goworm committed Apr 14, 2026
  • Update wiki for v1.0.45: Excel inline editing, chart drag, range selection, auto-resident - command-watch.md: document Excel double-click inline cell editing (shows formula, commits via POST /api/edit → officecli set), drag-to-reposition charts (absolute overlay, persists across SSE refresh), rectangular range selection (click+drag, Shift+click, fill handle) - command-open.md: auto-start resident on ANY first command (not just create); document OFFICECLI_NO_AUTO_RESIDENT=1 opt-out env var - command-query-excel.md: path-style /Sheet1/cell now normalized (not rejected) — both Sheet1!cell and /Sheet1/cell work identically - version bump: all pages v1.0.44 → v1.0.45; version.json + version.md updated

    @goworm goworm committed Apr 13, 2026
  • Update wiki for v1.0.44: grep-friendly output, formula auto-detect, chart SVG, Excel selection - command-get.md: rewrite text output format section — now single-line grep-friendly records (path (type) "text" key=val ...) instead of indented tree layout - excel-cell-add.md: document formula auto-detect (value="=SUM(...)" auto-treated as formula, no separate formula property needed) - ppt-picture-add.md: document auto aspect-ratio when only width or height is supplied - command-watch.md: Excel native-style green selection (#217346) with crosshair row/column header highlighting; initial HTML render via resident handler to avoid file lock - command-query-excel.md: note that path-style selectors (/Sheet1/cell) are now rejected with helpful error suggesting Sheet1!cell syntax - version bump: all 211 pages from v1.0.43 → v1.0.44

    @goworm goworm committed Apr 13, 2026
  • Update wiki for v1.0.43: OLE lifecycle, slicers, cx:chart Set, auto-start resident New pages: - excel-slicer.md: pivot-backed slicers with SlicerCachePart/SlicersPart, pivotTable+field binding, position/size/style Updated pages: - word-ole.md: expanded from get-only to full Add/Set/Query/Get/Remove lifecycle; --save for extracting embedded binary; canonical Format schema; attribute filters - excel-reference.md: add slicer and OLE rows - powerpoint-reference.md: add OLE row - command-get.md: --save flag for extracting OLE embedded binary - excel-chart-set.md: x/y/width/height position+size Set; cx:chart full vocabulary (histogram/funnel/treemap/sunburst/boxWhisker) title/axis/gridline/styling - word-chart-set.md: same x/y/width/height and cx:chart support - command-open.md: auto-start resident on create (60s idle), open upgrades timeout to interactive default (12min) via __set-idle-timeout__ RPC - All 198 pages bumped to v1.0.43 Other notable changes (already in wiki via user edits): - command-add-word/ppt/excel: OLE section with src/progId/width/height/display/icon - Use Cases link added to Home.md Bug fixes: - Pivot-backed slicer survives Excel open - Histogram binning renders correctly - ChartStyle/ChartColorStyle sidecars for extended charts - Install: atomic binary replace via staged .new + mv - Update: redirect child stdio, enable MCP auto-upgrade

    @goworm goworm committed Apr 11, 2026
  • Update wiki for v1.0.41-42: OLE objects, image positioning, formula refs New pages: - word-ole.md: OLE object detection (Visio/Excel/Equation), get attributes (progId, dimensions, previewImage), ole/object/embed selectors Updated pages: - word-picture.md: add set properties (wrap, hposition, vposition, hrelative, vrelative, behindText); get attributes for inline/anchor layouts - word-reference.md: add OLE Object element row; picture now has set/get - command-query-word.md: add ole/object/embed selectors - command-view-word.md: heading auto-numbering from style chain, OLE object preview (EMF/WMF auto-converted to PNG) - command-watch.md: OFFICECLI_WATCH_IDLE_SECONDS env var for idle timeout - excel-reference.md: formula evaluator now supports entire-column/row refs (A:A, 1:1) and defined name resolution - excel-pivottable-add.md / -set.md: repeatLabels, blankRows, grandTotalCaption (already updated by user) Other notable changes: - Pivot fixes: tabular subtotal labels, compact+N=2+subtotals=off routing, 0x0/0x1/0x2 rendering, 2x0xK rendering, K>1 col grand caption placement - Excel formulas: chart series re-evaluates instead of trusting cachedValue - Word: picture --index, auto aspect ratio, body-level find: fix - Resident/watch: ordered shutdown, signal handling, socket cleanup - All 196 pages bumped to v1.0.42

    @goworm goworm committed Apr 10, 2026
  • Update wiki for v1.0.40: pivot layout forms, Excel watch row-level diff - excel-pivottable-add.md: add layout property (compact/outline/tabular) - excel-pivottable-set.md: add layout property with description - command-watch.md: Excel watch now uses row-level incremental diff (only changed rows sent via SSE, fallback to full refresh for >60% changes) - Pivot table fixes: 0x0/0x1/0x2/2x0xK rendering, Excel recovery errors - Install: skip binary copy when managed by Homebrew - All 195 pages bumped to v1.0.40

    @goworm goworm committed Apr 9, 2026
  • docs(xlsx/pivot): document sort/showDataAs/grandTotals/subtotals props

    @goworm goworm committed Apr 9, 2026
  • Update wiki for v1.0.38: interactive selection, marks, selected pseudo-path New pages: - command-mark.md: mark/unmark/get-marks for attaching review annotations to elements (find, color, note, tofix); watch-based live rendering via SSE; supports selected pseudo-path for marking currently-selected elements Updated pages: - command-watch.md: interactive click/rubber-band selection in browser preview for PPT (shapes, pictures, tables, charts, connectors, groups) and Word (top-level paragraphs, tables); CLI integration section with get/set/mark selected examples; marks section - command-get.md: selected pseudo-path returns array of DocumentNode for currently-selected elements; empty array if nothing selected; error if no watch running - command-set.md: selected pseudo-path applies properties to each selected element - Home.md / command-reference.md: mark/unmark/get-marks command entries - agent-guide.md: interactive selection and review section Other changes: - Default shape width changed from full slide to 10cm to avoid overlap - expect property deprecated in favor of tofix (auto-aliased with warning) - Picture Format["size"] renamed to "fileSize" - Word emits data-path="/p[N]" and /table[N] on top-level elements - PPT emits data-path="/slide[N]/shape[@id=X]" using stable @id form - All 188 pages bumped to v1.0.38

    @goworm goworm committed Apr 8, 2026
  • Update wiki for v1.0.37: size alias, bug fixes - excel-cell-set.md: add size as alias for font.size - Bug fixes: gradient angle accepts deg suffix, numlevel alias for Word lists, built-in styles no longer marked customStyle, pie/doughnut per-slice colors, PPT bullet character color/size, Word page break for nextPage section breaks, chart legend font from defRPr, data label type from OOXML, table auto-fit width - All 187 pages bumped to v1.0.37

    @goworm goworm committed Apr 6, 2026
  • Update wiki for v1.0.36: bug fixes for Excel HTML preview and formula evaluator Bug fixes only: - Excel HTML preview: dataBar/iconSet rendering, chart positioning, number formatting - Replace hardcoded chart/preview values with OOXML properties - Excel HTML preview: chart rendering and frozen pane improvements - Formula evaluator: COUNTIF, COUNTA, SUMIF return 0 for string criteria - All 187 pages bumped to v1.0.36

    @goworm goworm committed Apr 5, 2026
  • Update wiki for v1.0.35: deterministic IDs, morph name matching - powerpoint-reference.md: deterministic shape ID generation (global increment counter for reproducible batch scripts); morph !! prefix-aware name matching (shape[@name=MyBox] matches both MyBox and !!MyBox) - Word paraId/textId also uses deterministic increment instead of random - All 187 pages bumped to v1.0.35

    @goworm goworm committed Apr 5, 2026
  • Update wiki for v1.0.34: regex=true, move --after/--before, swap in batch Updates: - word-document-set.md: regex=true prop as alternative to r"..." prefix for find - command-move.md: --after/--before flags with auto-inferred --to from anchor path - command-batch.md: swap command, after/before fields for add/move, path2 for swap - command-add.md: find: anchors also support regex=true - agent-guide.md: regex=true in find+format task description - Find output now includes match count: "Updated ... (N matched)" - add/set --json returns node data for the affected element - All 187 pages bumped to v1.0.34

    @goworm goworm committed Apr 4, 2026
  • Update wiki for v1.0.33: find+format, text-anchored insert, stable ID addressing Major features: - word-document-set.md: find+format (apply bold/color/highlight to matched text without replacing), regex support (r"..." prefix), find+replace+format combo; scope now controlled by path instead of scope= param - ppt-presentation-set.md: find+format and regex support for PPT - command-add.md: --after/--before flags with find:text and find:r"regex" anchors; Word inline insert (run, image, hyperlink) and block insert (table, paragraph — auto-splits paragraph); PPT inline run insert at text position - powerpoint-reference.md: stable ID addressing (@id=, @name= for shapes/pictures/ tables/charts/connectors/groups); Get returns stable paths - word-reference.md: add @commentId= and @sdtId= stable paths; Get returns @paraId= paths instead of positional indices - agent-guide.md: find+format, text-anchored insert, stable ID tasks - All 187 pages bumped to v1.0.33

    @goworm goworm committed Apr 4, 2026
  • Update wiki for v1.0.32: paraId stable addressing, LaTeX extensions, watch block diff Updates: - word-reference.md: stable element addressing via w14:paraId/textId and docPr ID (/body/p[@paraId=XXXX], /picture[@id=N], /chart[@id=N]); paraId assigned on creation, textId refreshes on content change, docPr IDs auto-deduped on open - word-equation-add.md: expanded LaTeX command reference — boxed, underbrace, overbrace, cancel, color, align/gathered/split/array environments, angle/ceil/floor delimiters, arc-trig functions, operatorname, set notation symbols, spacing - command-watch.md: Word watch upgraded to server-side block diff with incremental SSE patches (replace/add/remove/style), version numbering with gap detection, fallback to full refresh when >60% blocks changed - w14 text effects (textFill, glow, reflection) now rendered in Word HTML preview - Chart rendering fixes (radar/line color, NaN guard, axis subnormal values) - All 187 pages bumped to v1.0.32

    @goworm goworm committed Apr 4, 2026
  • Update wiki for v1.0.31: Word watch paragraph-level diff - command-watch.md: Word watch mode now uses paragraph-level diff instead of full DOM replacement, preserving scroll position and minimizing re-render - All 187 pages bumped to v1.0.31

    @goworm goworm committed Apr 3, 2026
  • Update wiki for v1.0.30: batch improvements, query enhancements, stability fixes Updates: - command-batch.md: --force flag, spill-to-file for large output, error includes original item, stop-on-first-error default (user updated) - command-query-word.md: style and hyperlink selectors, p[last()] support, equation query scans inside table cells - Word HTML preview: responsive scaling, scroll preservation on SSE refresh - Batch: raw command requires explicit part field, inline JSON no longer double-encodes, resident envelope unwrapped for consistent format - PPT readback normalizations: lineWidth in pt, list canonical names, table cell valign top/bottom, friendly tc/tr query paths - Word fixes: accept-changes=all alias, protection=none without --force, hyperlink relationship cleanup on URL change, equation Set on oMathPara - Excel fixes: TotalsRowCount toggle, formula cross-sheet in preview - All 187 pages bumped to v1.0.30

    @goworm goworm committed Apr 3, 2026
  • Update wiki for v1.0.29: document L2 properties, --page filter, formula preview Major updates: - word-document-set.md: 50+ new L2 properties (docDefaults, docGrid, CJK spacing, compatibility, settings flags, theme, extended) — already updated by user - ppt-presentation-set.md: show/print/theme/extended properties — already updated by user - command-view-word.md: --page filter (--page 1,3,5 or --page 2-5), font-metrics line-height, CJK auto-spacing - command-view-excel.md: live formula evaluation in HTML preview (cross-sheet refs), sheet tab color styling - word-style-set.md: lineSpacing property at style level - agent-guide.md: document-level settings, --page filter tasks All 185 pages bumped to v1.0.29

    @goworm goworm committed Apr 2, 2026
  • Update wiki for v1.0.28: find-replace, sheet ops, pivot set, CJK overflow, slide master Excel updates: - excel-reference.md: find-replace (document/sheet level), sheet index addressing (/[1]), sheet reorder (move --index), column autoFit, gridlines/headings toggles - excel-chart-add.md: dataRange property for cell range references PowerPoint updates: - ppt-presentation-set.md: defaultFont, find-replace across all slides - ppt-slide-set.md: layout property to change slide layout - powerpoint-reference.md: slide master/layout paths, table cell[R,C] shorthand, equation set support Word updates: - command-view-word.md: word count in stats output - word-run-set.md: charSpacing/letterSpacing property Cross-format updates: - command-batch.md: inline JSON via --commands parameter - command-reference.md: create/new alias - agent-guide.md: find-replace, autoFit, gridlines, sheet reorder, layout set, defaultFont, slide master, equation set, CJK overflow check, batch inline JSON, sheet index, dataRange All 185 pages bumped to v1.0.28

    @goworm goworm committed Mar 31, 2026
  • Update wiki for v1.0.27: form fields, document protection, PPT coordinates New pages: - word-formfield.md: legacy form fields (text, checkbox, dropdown) with add/set/get Updated pages: - word-document-set.md: document protection modes (readOnly, comments, trackedChanges, forms, none) - word-reference.md: form field element entry - command-add-word.md: formfield type - command-view-word.md: SDT and form field annotations in text/annotated output - command-skills.md: OpenCode agent support - PPT Add/Set now returns coordinates and warns on position overlap - All 185 pages bumped to v1.0.27

    @goworm goworm committed Mar 30, 2026
  • Update wiki for v1.0.26: Word HTML fidelity, watch auto-scroll, query-selector Set Updates: - command-view-word.md: expanded HTML preview support list (drop caps, floating tables, multi-column sections, table conditional formatting, theme borders, anchored images, TOC rendering, footnote numbering format, run borders/shading, CJK punctuation, fonts) - command-watch.md: auto-scroll to changed element; expanded Word preview details - command-set.md: query-selector paths in PPT/Excel Set; auto-create styles in Word - command-query-word.md: footnote and endnote selectors - word-style-set.md: paragraph border (pbdr.*) support at style level - All 184 pages bumped to v1.0.26

    @goworm goworm committed Mar 29, 2026
  • Update wiki for v1.0.25: Word HTML preview, formula evaluator, Excel HTML, skills overhaul Major features: - command-view-word.md: Word HTML preview (view html, --browser) with full formatting, tables, images, footnotes/endnotes, charts (SVG), equations (KaTeX), page layout - command-view-excel.md: Excel HTML preview with formatting, charts (SVG), sheet tabs, frozen panes, hidden rows/cols, RTL/i18n, accessibility (ARIA), print CSS - command-watch.md: now supports .docx and .xlsx in addition to .pptx - excel-reference.md: built-in formula evaluator (150+ functions, auto-eval at write time) - command-skills.md: per-skill install (officecli skills install <name>), skills list, 8 specialized skills (pptx, docx, xlsx, morph-ppt, pitch-deck, academic-paper, data-dashboard, financial-model), officecli- naming convention - All 184 pages bumped to v1.0.25

    @goworm goworm committed Mar 28, 2026
  • Update wiki for v1.0.24: chart overhaul, extended chart types, path aliases, remove support Chart overhaul (all formats): - 6 new chart types: waterfall, funnel, treemap, sunburst, histogram, boxWhisker (cx:chart) - 30+ new chart properties: manual layout (plotArea/title/legend/dataLabel x/y/w/h), reference lines, conditional coloring, axis line styling, tick marks, display units, log scale, individual data label text/positioning, series name/values Set, data point colors, error bars, explosion, smooth, markers, data table, rounded corners - Chart Remove support for Excel and Word Other updates: - word-reference.md: human-friendly path aliases (paragraph→p, table→tbl, row→tr, cell→tc, run→r) - excel-reference.md: table and chart now support remove - command-remove.md: Excel chart/table, Word chart/toc/footnote/endnote remove examples - All 184 pages bumped to v1.0.24

    @goworm goworm committed Mar 27, 2026