Status update on saving debug spreadsheets

0 views
Skip to first unread message

Vova

unread,
Nov 25, 2009, 7:55:52 AM11/25/09
to formulacompiler-devel
A short report on "debug spreadsheets" feature progress.

This feature will allow to save a spreadsheet based on a template
spreadsheet (the one which is "compiled") with all input cell values
substituted with the data provided by an application to the AFC
engine. The values computed by a spreadsheet application (Excel or
OpenOffice.org Calc) in this spreadsheet should be just the same as
the values computed by the AFC engine. So this feature can help to
understand computation process and find bugs in the compiler.

Works now:
- Collecting required data from computation, including info about
sections.
- Making a new spreadsheet model based the template spreadsheet and
the collected data.
- Resizing a sheet so it can hold enlarged nested sections. A section
grows if it contains more elements than the template or if its
subsection grows. If it has less rows, then its size remains the same.
- Update relative coordinates in formulas within a section. I think
that relative coordinates outwards a section should be illegal in AFC.

Work in progress:
- Creating section model of a spreadsheet which includes a structure
tree of sections and their sizes. This info is available in
WorkbookBinding/SectionBinding.
- Update absolute cell coordinates in formulas after a sheet has been
resized.

--
Vova
Reply all
Reply to author
Forward
0 new messages