A small matter of programming: perspectives on end user computing
A small matter of programming: perspectives on end user computing
International Journal of Human-Computer Studies
Tools for spreadsheet auditing
International Journal of Human-Computer Studies
The spreadsheet interface: A basis for end user programming
INTERACT '90 Proceedings of the IFIP TC13 Third Interational Conference on Human-Computer Interaction
Spreadsheet structure inspection using low level access and visualisation
AUIC '03 Proceedings of the Fourth Australasian user interface conference on User interfaces 2003 - Volume 18
Spreadsheet structure inspection using low level access and visualisation
AUIC '03 Proceedings of the Fourth Australasian user interface conference on User interfaces 2003 - Volume 18
Fluid Visualization of Spreadsheet Structures
VL '98 Proceedings of the IEEE Symposium on Visual Languages
3D Interactive Visualization for Inter-Cell Dependencies of Spreadsheets
INFOVIS '99 Proceedings of the 1999 IEEE Symposium on Information Visualization
Finding High-Level Structures in Spreadsheet Programs
WCRE '02 Proceedings of the Ninth Working Conference on Reverse Engineering (WCRE'02)
Topological Fisheye Views for Visualizing Large Graphs
IEEE Transactions on Visualization and Computer Graphics
Visualizing large graphs with compound-fisheye views and treemaps
GD'04 Proceedings of the 12th international conference on Graph Drawing
A visualization-based approach for improving spreadsheet quality
Proceedings of the Warm Up Workshop for ACM/IEEE ICSE 2010
Lessons learned from evaluating the usability of mobile spreadsheet applications
HCSE'12 Proceedings of the 4th international conference on Human-Centered Software Engineering
Are Mobile Spreadsheet Applications Usable?
Journal of Organizational and End User Computing
Hi-index | 0.00 |
One of the difficulties in understanding and debugging spreadsheets is due to the invisibility of the data flow structure which is associated with cell formulas. In this paper, we present a spreadsheet visualization approach that is mainly based on the Markov Clustering (MCL) algorithm in an attempt to help spreadsheet users understand and debug their spreadsheets. The MCL algorithm helps in visualizing large graphs by generating clusters of cells. In our visualization approach, we also use compound fisheye views and treemaps to help in the navigation of the generated clusters. Compound fish eye views help to view members of a particular cluster while showing their linkages with other clusters. Treemaps help to visualize the depth we are at while navigating a cluster tree. Our initial experiments show that graph-based spreadsheet visualization using the MCL algorithm generates clusters which match with the corresponding logical areas of a given spreadsheet. Our experiments also show that analysis of the clusters helps us to identify some errors in the spreadsheets.