The Community for Technology Leaders
2013 20th Working Conference on Reverse Engineering (WCRE) (2002)
Richmond, Virginia
Oct. 29, 2002 to Nov. 1, 2002
ISBN: 0-7695-1799-4
pp: 0221
ABSTRACT
Spreadsheets are a common tool in end-user programming. But even while important decisions are based on spreadsheet computations, spreadsheets are poorly documented software and the differences between simple one-shot computations and large, long-living sheets are not well understood. Like other software, production spreadsheets are subject to repeated maintenance cycles. Consequently, as with conventional software, short maintenance cycles and poor documentation tend to decrease their quality.<div></div> We introduce an approach to help maintainers under-stand the structure of large spreadsheets as well as to zoom into certain parts of the spreadsheet. To cope with large sheets, our approach features two levels of abstraction: logical areas and semantic classes. These abstractions are based on different degrees of relatedness of cells according to the formulas they contain.
INDEX TERMS
CITATION
M. Clermont, R. Mittermeir, "Finding High-Level Structures in Spreadsheet Programs", 2013 20th Working Conference on Reverse Engineering (WCRE), vol. 00, no. , pp. 0221, 2002, doi:10.1109/WCRE.2002.1173080
90 ms
(Ver 3.3 (11022016))