• Corpus ID: 11835962

Using Layout Information for Spreadsheet Visualization

  title={Using Layout Information for Spreadsheet Visualization},
  author={Sabine Hipfl},
This paper extends a spreadsheet visualization technique by using layout information. The original approach identifies logically or semantically related cells by relying exclusively on the content of cells for identifying semantic classes. A disadvantage of semantic classes is that users have to supply parameters which describe the possible shapes of these blocks. The correct parametrization requires a certain degree of experience and is thus not suitable for untrained users. To avoid this… 

Figures from this paper

A Toolkit for Scalable Spreadsheet Visualization
This paper presents a toolkit for spreadsheet visualization based on logical areas, semantic classes and data modules, which can process large, industry scale spreadsheet programs in reasonable time and is tightly integrated with its host spreadsheet system.
Metrics-Based Spreadsheet Visualization: Support for Focused Maintenance
This paper proposes to use (complexity) measures as indicators for proper visualization, and proposes different visualization and representation methods that may ease spreadsheet comprehension but should not be applied with all kind of spreadsheet programs.
Perquimans: A Tool for Visualizing Patterns of Spreadsheet Function Combinations
Perquimans is a tool that analyzes spreadsheet collections to visualize patterns of function combination as an interactive tree, representing both the most common and most anomalous patterns of formula construction and their contexts.
Automated model-based spreadsheet debugging
Several new algorithmic enhancements of the general MBD approach are combined in this thesis to allow spreadsheet users to debug their spreadsheets and to efficiently find the reason of the observed unexpected output values.
CUSTODES: Automatic Spreadsheet Cell Clustering and Smell Detection Using Strong and Weak Features
CUSTODES is proposed to effectively cluster spreadsheet cells and detect smells in these clusters using strong and weak features and successfully detected harmful smells that can induce computation anomalies in spreadsheets with an F-measure of 0.72, outperforming state-of-the-art techniques.
Excelsior: Bringing the Benefits of Modularisation to Excel
Excelsior is presented, a system for bringing modular design features to Excel that would save time, avoid unneeded programming, make mistakes less likely, make code-control easier, help organisations adopt a uniform house style, and open business opportunities in buying and selling spreadsheet modules.
Protecting Spreadsheets Against Fraud
This paper surveys the available means for fraud protection by contrasting approaches suitable for spreadsheets with those known from fraud protection for conventional software.
Requirements for the domain model of environmental computational spreadsheets
Computer Science Network Institute VU University Amsterdam The Netherlands martine.de.vos@vu.nl Jan Wielemaker Computer Science Network Institute VU University Amsterdam The Netherlands


Modeling Spreadsheet Audit: A Rigorous Approach to Automatic Visualization
A theoretical model of spreadsheets and a technique to describe spreadsheet auditing tools are presented and it is hoped that visualizations that point out parts ofspreadsheets that contain anomalies will be found.
Detecting Errors in Spreadsheets
The paper presents two complementary strategies for identifying errors in spreadsheet programs, grounded on the assumption that spreadsheets are software, albeit of a different nature than conventional procedural software.
Finding high-level structures in spreadsheet programs
An approach to help maintainers understand the structure of large spreadsheets as well as to zoom into certain parts of the spreadsheet to cope with large sheets is introduced.
Slicing spreadsheets: an integrated methodology for spreadsheet testing and debugging
This paper presents an integrated testing and debugging methodology for spreadsheets that is tightly integrated into the spreadsheet environment and provides an interface to the methodology that does not require an understanding of testing and debug theory, and that takes advantage of the immediate visual feedback that is characteristic of the spreadsheet paradigm.
What we know about spreadsheet errors
Although spreadsheet programs are used for small "scratchpad" applications, they are also used to develop many large applications, and error rates are in line with those in programming and other human cognitive domains.
What you see is what you test: a methodology for testing form-based visual programs
A testing methodology for form-based visual programs is presented that is validation driven and incremental, and an interface to the methodology is provided that does not require an understanding of testing theory.
Auditing Large Spreadsheet Programs
This paper presents an approach that enables auditors to understand the structure of large spreadsheets by aggregating cells with related properties and it will be shown, how different auditing strategies can be supported by this approach.
Is this spreadsheet a tax evader? How HM Customs and Excise test spreadsheet applications
  • Raymond J. Butler
  • Business
    Proceedings of the 33rd Annual Hawaii International Conference on System Sciences
  • 2000
The audit experience is briefly summarised, the methodology is described and the results to date of a campaign of spreadsheet testing that started in July 1999 are outlined.
Z - an introduction to formal methods
This tutorial introduction to Z contains information on how to relate Z specifications to actual program code and is enhanced to reflect the most current language standards.
Universitätsstrasse 65–67
  • A-9020 Klagenfurt, Austria,
  • 2003