Skip to content

History / excel chart column

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(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.

    @goworm goworm committed Apr 13, 2026
  • 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.

    @goworm goworm committed Apr 13, 2026
  • 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).

    @goworm goworm committed Apr 13, 2026