arXivDaily arXiv每日学术速递 周一至周五更新
北美退伍军人节(Veterans Day),12 日无更新
arXiv 0802.3924cs.HC
收藏

一个可扩展的电子表格可视化工具包

A Toolkit for Scalable Spreadsheet Visualization

Markus Clermont

摘要:

本文提出了一个基于逻辑区域、语义类和数据模块的电子表格可视化工具包。逻辑区域、语义类和数据模块是电子表格程序的抽象表示,旨在减少审计和理解工作,特别是对于大型和常规的电子表格。该工具包作为一个插件集成在Linux的Gnumeric电子表格系统中。它可以在合理的时间内处理大型工业规模的电子表格程序,并与其主机电子表格系统紧密集成。用户可以生成他们的电子表格的分层和基于图形的表示。这使他们能够在电子表格的不同区域中发现概念上的相似之处,否则这些相似之处将不适合在屏幕上显示。由于假设有效使用这种工具的学习工作应该保持较低,我们的目标是直观地处理大多数工具的功能。

英文摘要:

This paper presents a toolkit for spreadsheet visualization based on logical areas, semantic classes and data modules. Logical areas, semantic classes and data modules are abstract representations of spreadsheet programs that are meant to reduce the auditing and comprehension effort, especially for large and regular spreadsheets. The toolkit is integrated as a plug-in in the Gnumeric spreadsheet system for Linux. It can process large, industry scale spreadsheet programs in reasonable time and is tightly integrated with its host spreadsheet system. Users can generate hierarchical and graph-based representations of their spreadsheets. This allows them to spot conceptual similarities in different regions of the spreadsheet, that would otherwise not fit on a screen. As it is assumed that the learning effort for effective use of such a tool should be kept low, we aim for intuitive handling of most of the tool's functions.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑