Skip to content

History / excel sheet set

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
  • docs: document range sort, sidecar handling, and protection rejection

    @goworm goworm committed Apr 16, 2026
  • docs(excel-sheet-set): correct sort COL to column letter only Sort spec rejects header names; only column letters (A..XFD) are accepted. Update description, add note pointing users to get the header row to map names to letters, and switch examples to letter-based columns.

    @goworm goworm committed Apr 15, 2026
  • docs(excel): add Sheet section to xlsx set help Add excel-sheet-set.md covering sheet-level properties (name, freeze, zoom, tabColor, protect, password, orientation, paperSize, printArea, fitToPage, header, footer), sort/sortHeader, autofilter range, and range-level merge. The xlsx set help page was previously missing its Sheet section while xlsx get and xlsx add both had one, making sort/freeze/zoom/tabcolor/protect discoverable only by reading source.

    @goworm goworm committed Apr 15, 2026