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
16f2a6f
docs: update query sheet prefix to show both ! and / styles
acc487c
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
26393da
docs: document unified input source support (HTTP URL, data URI) for media, 3D model, and table data
a973262
docs: normalize --prop path= to --prop src= across all wiki pages
Canonical prop name for external file source is now 'src'.
'path' remains accepted as a silent alias but is no longer shown in docs.
e0a8f76
docs(wiki): expand sparkline and header/footer pages with full property reference
- excel-sparkline.md: rewritten with full property reference (17 add
properties, 10 set properties), categorized tables, get return format,
discovered 5 undocumented marker color properties
- excel-sparkline-add.md: expanded with all property categories,
field examples, marker color properties
- word-header-footer.md: expanded with type variants, format properties,
deep get, remove behavior, related document settings
- word-header-footer-add.md: expanded with complete property table,
field values, type behavior (titlePage/evenAndOddHeaders auto-enable)
- word-header-footer-set.md: expanded with run-level and paragraph-level
property tables, behavior notes
b551a18
docs(wiki): expand PPT shape page with complete preset gallery and property reference
- ppt-shape.md: rewritten from 57 to 358 lines with full categorized
preset gallery (70+ shapes in 6 categories: basic, stars, arrows,
callouts, flowchart, symbols), complete property reference summary
(position, fill, outline, text, layout, effects, 3D, metadata,
animation), sub-elements, and examples
- ppt-shape-add.md: expanded shape presets section from partial list
to full categorized list with link to gallery
65bfe57
docs(wiki): expand all chart type pages with complete property reference
Every chart type page now includes the full set of configurable
properties organized by section, matching the line/histogram detail
level. Added to each page where applicable:
- Title styling (font, size, color, bold, glow, shadow)
- Legend (position, overlay, font)
- Axis features (scale, log, reversed, dual, display units, visibility)
- Gridlines (major/minor with color:width:dash)
- Reference lines (target/threshold overlays)
- Fills and borders (plot/chart area fill and border)
- Series shadow and outline
- Data labels (full property table with per-label overrides)
- Transparency and opacity
- Conditional coloring
- Layout control (position, size, manual plot/title/legend layout)
- Display blanks handling
- Full presentation-grade example command
- Expanded HTML preview support table
- Inspect section with query/get/view commands
14 files changed, +3234 lines across column, bar, pie, doughnut,
area, scatter, radar, bubble, stock, combo, waterfall, treemap,
sunburst, boxWhisker.
3da6192
docs(wiki): add chart type reference links to Word chart pages
- word-chart.md: add 17 chart type dedicated page links (same shared
engine as Excel/PPT)
- word-chart-add.md: add smooth, showMarker, dropLines, hiLowLines,
upDownBars, serLines, dataTable, referenceLine properties
- word-chart-set.md: add dropLines, hiLowLines, upDownBars, serLines
2d83458
docs(wiki): split column/bar and pie/doughnut into independent pages
Each chart type now has its own dedicated page:
- excel-chart-column: vertical bars (was column/bar combined)
- excel-chart-bar: horizontal bars (new, references column for shared props)
- excel-chart-pie: pie + pie3d (was pie/doughnut combined)
- excel-chart-doughnut: ring chart with holeSize (new)
Updated excel-chart.md and ppt-chart.md indexes to list all 17 types
individually across 17 pages.
3d3e43a
docs(wiki): add dedicated pages for cx extended chart types
4 new pages for the remaining cx:chart types:
- excel-chart-funnel: pipeline/conversion stages
- excel-chart-treemap: nested rectangles with parentLabelLayout
- excel-chart-sunburst: concentric ring segments
- excel-chart-boxwhisker: statistical box plot with quartileMethod
Updated excel-chart.md and ppt-chart.md indexes to list all 15 type
pages (11 cChart + 4 cx + histogram = 15 pages for 17 type strings).
ed5fcac
docs(wiki): link PPT chart page to shared chart-type reference pages
Excel and PPT use the same OOXML chart engine, so PPT chart page now
references the 11 Excel chart-type dedicated pages instead of
duplicating content.
da76405
docs(wiki): add dedicated pages for every chart type
10 new type-specific chart pages covering type-unique properties,
variants, data formats, rendering support, and examples:
- excel-chart-column (column/bar): gap width, overlap, bar shape, 3D
- excel-chart-line: smooth, dash, markers, line elements, log/reversed
- excel-chart-pie (pie/doughnut): hole size, explosion, per-slice color
- excel-chart-area: gradient fill, transparency, stacked/3D
- excel-chart-scatter: 5 scatter styles, XY numeric axes
- excel-chart-bubble: bubble scale, size-represents, negative bubbles
- excel-chart-radar: 3 radar styles, polar grid
- excel-chart-stock: OHLC candlestick, series order requirement
- excel-chart-combo: combo split, per-series type assignment
- excel-chart-waterfall: increase/decrease/total colors, bridge effect
Updated excel-chart.md index to link all 11 type pages (incl histogram).
7a68f64
docs(wiki): add line chart features to chart get/add/set pages
- excel-chart-get: expanded from minimal table to full attribute
reference organized by category (axis, gridlines, data labels,
line features, styling) plus series-level attributes (lineWidth,
lineDash, smooth, marker, shadow, etc.)
- excel-chart-add/set: add dropLines, hiLowLines, upDownBars,
serLines line element properties
- ppt-chart-get: same expansion as Excel (chart-level + series-level)
- ppt-chart-add: add smooth, showMarker, dropLines, hiLowLines,
upDownBars, dataTable
- ppt-chart-set: add dropLines, hiLowLines, upDownBars
bdbdf29
docs(ole): make set/get/query/remove bullets clickable anchor links
The Operations list in word-ole / excel-ole / ppt-ole had set/get/query as
plain text, so readers landing on the page couldn't jump to the inline
sections without scrolling. Convert them to in-page anchor links:
- [set](#set), [get](#get-attributes), [query](#query)
- ppt-ole additionally gets [remove](#remove)
- The "(see below)" hints become redundant and are dropped
06d38c6
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
6d187e6
docs(chart): dedicated excel-chart-histogram page
Histograms are cx extended charts with a fundamentally different
vocabulary from regular cChart types. The existing excel-chart-add
and excel-chart-set pages documented mostly cChart knobs and only
touched histogram/cx briefly via one run-on sentence that listed
~15 knobs without explanations.
Add a dedicated reference page covering the full histogram vocabulary:
- Binning: binCount / binSize / intervalClosed / underflowBin /
overflowBin (with mutually-exclusive rules and real Excel semantics)
- Layout: x/y/width/height + gapWidth (noting histogram default 0)
- Series: series1 / fill / colors / series.shadow
- Axis titles: xAxisTitle / yAxisTitle + axisTitle.color/size/bold/font
(with the "cx can't split X/Y styling" caveat)
- Axis tick labels: axisfont compound + tickLabels toggle
- Axis scaling: axismin / axismax / majorunit / minorunit
- Axis visibility: axis.visible / cataxis.visible / valaxis.visible
plus axisline / cataxis.line / valaxis.line spine outlines
- Gridlines: gridlines / gridlineColor / xGridlines / xGridlineColor
- Data labels: dataLabels + datalabels.numfmt
- Plot / chart area: plotareafill / chartareafill + borders
- Title styling: title.color/size/bold/font/shadow
- Legend: legend / legend.overlay / legendfont
- A magazine-hero worked example stacking every knob
- Known quirks: binCount precedence, gapWidth default, cx axis-title
shared styling, the OOXML binCount/binSize raw-element workaround,
and the HTML preview font-family fallback
Cross-link the new page from the chart hub (excel-chart), from the
histogram row in excel-chart-add's chart type table, and from the
cx-extended-chart paragraph in excel-chart-set (replacing the run-on
sentence with a concrete link).
Based on the runnable examples/excel/charts-histogram.* triad
(6 sheets × 29 charts) which exercises every knob documented here.
43a3a4d
docs(home): add OLE Object and Slicer links to element navigation
90743b4
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
08648cd
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
3d54530
chore: bump version.json to v1.0.41
62f0550
Update wiki for v1.0.41: grandTotalCaption, batch resident optimization, tabular subtotals fix
- excel-pivottable-add/set/get: add grandTotalCaption property (default: "Grand Total")
- command-batch: update resident mode note — entire batch now sent as one command per open/save cycle
- version.md / Home.md: bump to v1.0.41
2dd9e2d
docs(pivot): add blankRows property to add/set/get pages
dae2bfd
docs(pivot): add repeatLabels property to add/set/get pages
145171e
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
ff84de9
Add 7 missing get/set pages for complete three-layer coverage
New pages:
- excel-table-get.md: table name, ref, style, stripes, header/total row, columns
- excel-picture-get.md: name, alt, x/y/width/height
- excel-comment-set.md: text, author
- excel-comment-get.md: ref, author, anchoredTo, text
- ppt-connector-set.md: line color/width/dash/opacity, headEnd/tailEnd arrows,
position, rotation, name + get attributes (connection info)
- ppt-video-get.md: name, autoplay, volume, trim, position, opacity
- ppt-presentation-get.md: slideWidth/Height/Size, defaultFont, metadata, dates
Updated reference pages:
- excel-reference.md: add get links for table, comment, picture
- powerpoint-reference.md: add get links for presentation, connector set, video
cf5adcf
docs(xlsx/pivot): extract pivot table set into dedicated page
New page:
- excel-pivottable-set.md: comprehensive pivot set reference with field areas
(rows/cols/values/filters/source), aggregation (11 functions), showDataAs
(5 tokens), layout (grandTotals/subtotals/sort), naming/styling, axis
conflict resolution, behavior notes
Updated pages:
- excel-pivottable.md: replace inline set section with link to new page
- command-set-excel.md: add sparkline and pivot table rows
7f5f65a
docs(xlsx/pivot): document sort/showDataAs/grandTotals/subtotals props
2cd2e21
docs(xlsx/pivot): document sort/showDataAs/grandTotals/subtotals props
Add missing pivot table properties to excel-pivottable-add.md: aggregate,
showDataAs, sort (with v2 persistence note), grandTotals, subtotals, plus
an example showing their usage. Add grandTotals, subtotals, and display flag
readback keys to excel-pivottable-get.md attributes table.
675eb81
docs(xlsx/pivot): complete Set property list (rows/cols/values/filters/sort/...)
aa41898