Skip to content

XLSX sheet screenshot omits floating charts and clips to the first populated cell #246

Description

@YellowDi

Environment

  • OfficeCLI: 1.0.138
  • Input: an XLSX worksheet containing populated cells, a pivot table, and a floating chart

Reproduction

officecli view workbook.xlsx screenshot --page 1 --range "Dashboard!A1:J20" -o dashboard.png

Actual behavior

The generated PNG is only 254 x 64 and contains the title in A1. It omits the populated KPI/pivot range (A3:B13) and the floating chart (D1:J18).

Additional observations:

  • --page 2 still renders the first worksheet.
  • --range /Dashboard returns clip_target_not_found.
  • --range /Dashboard/chart[1] renders the chart correctly by itself.
  • officecli view workbook.xlsx html renders the complete worksheet, including cells, pivot table, and chart.
  • officecli validate passes and officecli view workbook.xlsx issues reports zero issues.

Expected behavior

A worksheet screenshot should crop to the union of the used cell range and floating drawing/chart bounds, or the CLI should provide an explicit worksheet screenshot selector such as --sheet.

Impact

This does not affect workbook creation, editing, formulas, pivots, or chart data. It prevents a single-command PNG QA/preview of a complete worksheet containing floating charts.

Downstream tracking: YellowDi/LingStack#60

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions