Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

History / command add excel

Revisions

  • Update wiki for v1.0.62-v1.0.64: i18n + RTL, wordWrap, merge=sweep New page: - i18n: consolidated multilingual + RTL guide — per-script font slots (font.latin/ea/cs), complex-script bold.cs/italic.cs/size.cs, direction=rtl|ltr cascading, locale-aware pageNumFmt enum (Hebrew, Hindi, Arabic, Thai, CJK counting/ideograph, Korean), default-font policy change, HTML preview lang/dir emission Updates: - Home: link i18n guide - word-run-set: font.latin/ea/cs, bold.cs/italic.cs/size.cs, direction - word-paragraph-set: direction (cascades to runs+mark), font slots, bold.cs/italic.cs/size.cs, wordWrap toggle - word-paragraph-add: direction, font slots, bold.cs/italic.cs/size.cs, wordWrap (mirrors Set) - word-section-set: pageNumFmt full ECMA-376 enum, direction - ppt-shape-set: per-script font slots & RTL note - excel-cell-set: direction (alignment.readingOrder alias), merge=sweep on range path

    @goworm goworm committed Apr 29, 2026
  • Update wiki for v1.0.57–v1.0.61: PPT slide comments, Excel features, parity fixes New page: - ppt-comment: full add/get/query/set/remove lifecycle for slide-anchored comments (CommentAuthorsPart + SlideCommentsPart, author dedup, anchor position, auto-cleanup) Updates: - Home / powerpoint-reference: add Comment element row - ppt-slide-set: hidden prop (sld@show=0) - ppt-picture-set: brightness, contrast, glow, shadow - word-picture / word-picture: rotation, crop (all sides + per-side), brightness, contrast - word-section-set: pageNumFmt, titlePage, pageStart, break alias, headerRef.*/footerRef.* surfaced on Get - word-run-set: scheme color names on font color (accent1, dark2, hyperlink, etc.) - word-paragraph-set: break alias (newPage → pageBreakBefore), listLevel/numLevel/ilvl alias unification - excel-sheet: visibility (visible/hidden/veryHidden), print margin (margin.top/bottom/left/right/header/footer), fittopage, cascade-aware rename note - excel-workbook-set: workbook.password (legacy hash, presence-only get) - excel-cell-set: type=richtext + runs symmetric, type=date validation, formula cell-ref bounds, merge=range on range path - excel-namedrange-add: volatile flag, [@name=X] selector - excel-conditionalformatting-add: dataBar direction/length/colors with full Get readback for cellIs/colorScale/dataBar - command-goto: missing-anchor exit 1 note Bump all version footers + version.json/md to v1.0.61

    @goworm goworm committed Apr 28, 2026
  • Update wiki for v1.0.55–v1.0.56: numbering subsystem, goto cmd, Word/Excel polish New pages: - command-goto: scroll-target push to watching browser(s); resolves Word /body/p[N], /body/table[N]/tr[R][/tc[C]] via data-path, plus PPT /slide[N] - word-numbering: full Word numbering subsystem — abstractNum / num / lvl element types with per-level dotted props (level0..8.format, text, indent, font, etc.), three num modes (auto-create / reuse / per-level start overrides), style-borne numPr, paragraph tab stops via --type tab, validation rules Updates: - Home / command-reference: register `goto` command - Home / word-reference: add Numbering element row - word-reference: document Tier-3 dotted-attr fallback (any OOXML attribute settable on paragraph/run/table/row/cell/section/styles) - word-paragraph-set: contextualSpacing toggle, numId/ilvl with validation - word-run-set: allCaps alias for caps - excel-cell-add: ref/address aliases, `path` rejected with hint - excel-cell-set: font.color accepts full OOXML scheme color names, value honors existing text numberformat across two-step Set - ppt-shape-set: font.<attr> dotted aliases note - command-view-word: style integrity issues reported under Structure Bump all version footers + version.json/md to v1.0.56

    @goworm goworm committed Apr 27, 2026
  • Update wiki for v1.0.54: Word run color query, watch refresh scope - command-query-word: document hex-normalized run[color=...] matching (both #FF0000 and FF0000 accepted) and run traversal inside table cells - command-watch: clarify refresh scope — triggers only on officecli- mediated edits (set/add/remove/move/raw-set or resident/MCP server); external edits (opening in Office, other tools) do NOT trigger refresh - Bump all version footers + version.json/md to v1.0.54

    @goworm goworm committed Apr 22, 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
  • docs(ole): add dedicated excel-ole / ppt-ole pages with full set/get/query reference - Create excel-ole.md and ppt-ole.md mirroring the word-ole.md structure (operations index + inline set/get/query/remove sections, attribute tables, query filter examples, cross-format See Also) - Link the new pages from Home.md, excel-reference.md, powerpoint-reference.md - Update word-reference.md OLE row to full path + operation links - Fix command-add-excel.md: Excel OLE does not support the 'name' property (SpreadsheetML x:oleObject schema has no Name attribute); drop it from the property table and update the example to use 'anchor' instead - Fix command-add-ppt.md: default display is 'icon' (not 'content'), matching PowerPointHandler.Add.Media.cs and PowerPoint's own default for embedded OLE - Add See Also links back to the new reference pages from both command-add pages

    @goworm goworm committed Apr 11, 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
NewerOlder

AltStyle によって変換されたページ (->オリジナル) /