XLSX: verify charts, pivots, conditional formatting, and complex formulas #158

New issue

Open

opened 2026-04-26 08:24:34 +00:00 by zaelgohary · 0 comments

zaelgohary commented

2026-04-26 08:24:34 +00:00

Member

Acceptance

A single seeded Analytics.xlsx exercises:

Complex formulas: VLOOKUP / INDEX-MATCH, IF chains, array formula (XLOOKUP if available).
A chart referencing a data range; opening the file shows the chart rendered correctly.
A pivot table; refreshing it after editing source data updates correctly.
Conditional formatting on a cell range (e.g. heatmap); verify formatting renders.

Each of the four lives in a distinct e2e spec or a single spec with subgroups. We don't need to test every formula function — pick three representatives.

Macros (.xlsm) are out of scope for this issue; OnlyOffice's macro support is limited and warrants its own follow-up.

Save-back coverage from #147 will only verify what we type into a cell. The OnlyOffice spreadsheet engine has many features that could fail in obscure ways without anyone noticing — particularly around features that depend on background services (chart rendering) or non-trivial formula evaluation. ## Acceptance A single seeded `Analytics.xlsx` exercises: - Complex formulas: VLOOKUP / INDEX-MATCH, IF chains, array formula (XLOOKUP if available). - A chart referencing a data range; opening the file shows the chart rendered correctly. - A pivot table; refreshing it after editing source data updates correctly. - Conditional formatting on a cell range (e.g. heatmap); verify formatting renders. Each of the four lives in a distinct e2e spec or a single spec with subgroups. We don't need to test every formula function — pick three representatives. Macros (.xlsm) are out of scope for this issue; OnlyOffice's macro support is limited and warrants its own follow-up.