Bidirectional Spreadsheet Formulas

• Type: Article in International Conference Proceedings Book
• Date: 2014

Authors

Macedo, N (Author) Other; Pacheco, H (Author) Other; Sousa, NR (Author) Other; Cunha, A (Author) Other

Conference proceedings International

Title: 2014 IEEE SYMPOSIUM ON VISUAL LANGUAGES AND HUMAN-CENTRIC COMPUTING (VL/HCC 2014)

Pages: 161-168

IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)

Melbourne, AUSTRALIA, JUL 28-AUG 01, 2014

Indexing

ISI Web of Knowledge - 5 Citations

Scopus - 5 Citations

Other information

Authenticus ID: P-009-TT4

DOI: 10.1109/VLHCC.2014.6883041

Abstract (EN): Bidirectional transformations have potential applications in a vast number of computer science domains. Spreadsheets, on the other hand, are widely used for developing business applications, but their formulas are unidirectional, in the sense that their result can not be edited and propagated back to their input cells. In this paper, we interpret such formulas as a well-known class of bidirectional transformations that go by the name of lenses. Being aimed at users that are not proficient with programming languages, we devote particular attention to the seamless embedding of the proposed bidirectional mechanism with the typical workflow of spreadsheet environments, allowing users to have a fine control and understanding of the behavior of the derived backward transformations.

Language: English

Type (Professor's evaluation): Scientific

No. of pages: 8