3D Interactive visualization for inter-cell dependencies of spreadsheets

Hidekazu Shiozawa, Ken ichi Okada, Yutaka Matsushita

Research output: Chapter in Book/Report/Conference proceedingConference contribution

17 Citations (Scopus)

Abstract

This paper proposes a new technique to visualize dependencies among cells in a spreadsheet. In this way, the system firstly visualizes a spreadsheet on a plane in three-dimensional space, and draws arcs between interrelated cells. By allowing a user to select an arbitrary cell and lift it up with direct manipulation, the system utilizes the third dimension to ameliorate visual occlusion of crossing arcs. As the user lifts a focused cell up, the interrelated cells are lifted up together; thus hidden dataflow networks can be visually intelligible interactively. Because spreadsheets are aimed at calculation itself rather than appearances of outputs, their mechanism is relatively invisible and not obvious for ordinary users. Our visualization helps such users to understand structures and mechanism of spreadsheets.

Original languageEnglish
Title of host publicationProceedings of the IEEE Symposium on Information Visualization
PublisherIEEE
Pages79-82
Number of pages4
Publication statusPublished - 1999
EventProceedings of the 1999 IEEE Symposium on Information Visualization (InfoVIS'99) - San Francisco, CA, USA
Duration: 1999 Oct 241999 Oct 29

Other

OtherProceedings of the 1999 IEEE Symposium on Information Visualization (InfoVIS'99)
CitySan Francisco, CA, USA
Period99/10/2499/10/29

Fingerprint

Spreadsheets
Visualization

ASJC Scopus subject areas

  • Computer Science(all)
  • Engineering(all)

Cite this

Shiozawa, H., Okada, K. I., & Matsushita, Y. (1999). 3D Interactive visualization for inter-cell dependencies of spreadsheets. In Proceedings of the IEEE Symposium on Information Visualization (pp. 79-82). IEEE.

3D Interactive visualization for inter-cell dependencies of spreadsheets. / Shiozawa, Hidekazu; Okada, Ken ichi; Matsushita, Yutaka.

Proceedings of the IEEE Symposium on Information Visualization. IEEE, 1999. p. 79-82.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Shiozawa, H, Okada, KI & Matsushita, Y 1999, 3D Interactive visualization for inter-cell dependencies of spreadsheets. in Proceedings of the IEEE Symposium on Information Visualization. IEEE, pp. 79-82, Proceedings of the 1999 IEEE Symposium on Information Visualization (InfoVIS'99), San Francisco, CA, USA, 99/10/24.
Shiozawa H, Okada KI, Matsushita Y. 3D Interactive visualization for inter-cell dependencies of spreadsheets. In Proceedings of the IEEE Symposium on Information Visualization. IEEE. 1999. p. 79-82
Shiozawa, Hidekazu ; Okada, Ken ichi ; Matsushita, Yutaka. / 3D Interactive visualization for inter-cell dependencies of spreadsheets. Proceedings of the IEEE Symposium on Information Visualization. IEEE, 1999. pp. 79-82
@inproceedings{69eacefd4fbb40109e15e5f57473923f,
title = "3D Interactive visualization for inter-cell dependencies of spreadsheets",
abstract = "This paper proposes a new technique to visualize dependencies among cells in a spreadsheet. In this way, the system firstly visualizes a spreadsheet on a plane in three-dimensional space, and draws arcs between interrelated cells. By allowing a user to select an arbitrary cell and lift it up with direct manipulation, the system utilizes the third dimension to ameliorate visual occlusion of crossing arcs. As the user lifts a focused cell up, the interrelated cells are lifted up together; thus hidden dataflow networks can be visually intelligible interactively. Because spreadsheets are aimed at calculation itself rather than appearances of outputs, their mechanism is relatively invisible and not obvious for ordinary users. Our visualization helps such users to understand structures and mechanism of spreadsheets.",
author = "Hidekazu Shiozawa and Okada, {Ken ichi} and Yutaka Matsushita",
year = "1999",
language = "English",
pages = "79--82",
booktitle = "Proceedings of the IEEE Symposium on Information Visualization",
publisher = "IEEE",

}

TY - GEN

T1 - 3D Interactive visualization for inter-cell dependencies of spreadsheets

AU - Shiozawa, Hidekazu

AU - Okada, Ken ichi

AU - Matsushita, Yutaka

PY - 1999

Y1 - 1999

N2 - This paper proposes a new technique to visualize dependencies among cells in a spreadsheet. In this way, the system firstly visualizes a spreadsheet on a plane in three-dimensional space, and draws arcs between interrelated cells. By allowing a user to select an arbitrary cell and lift it up with direct manipulation, the system utilizes the third dimension to ameliorate visual occlusion of crossing arcs. As the user lifts a focused cell up, the interrelated cells are lifted up together; thus hidden dataflow networks can be visually intelligible interactively. Because spreadsheets are aimed at calculation itself rather than appearances of outputs, their mechanism is relatively invisible and not obvious for ordinary users. Our visualization helps such users to understand structures and mechanism of spreadsheets.

AB - This paper proposes a new technique to visualize dependencies among cells in a spreadsheet. In this way, the system firstly visualizes a spreadsheet on a plane in three-dimensional space, and draws arcs between interrelated cells. By allowing a user to select an arbitrary cell and lift it up with direct manipulation, the system utilizes the third dimension to ameliorate visual occlusion of crossing arcs. As the user lifts a focused cell up, the interrelated cells are lifted up together; thus hidden dataflow networks can be visually intelligible interactively. Because spreadsheets are aimed at calculation itself rather than appearances of outputs, their mechanism is relatively invisible and not obvious for ordinary users. Our visualization helps such users to understand structures and mechanism of spreadsheets.

UR - http://www.scopus.com/inward/record.url?scp=0033280010&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0033280010&partnerID=8YFLogxK

M3 - Conference contribution

SP - 79

EP - 82

BT - Proceedings of the IEEE Symposium on Information Visualization

PB - IEEE

ER -