Bidirectional spreadsheet formulas

Thumbnail Image
Date
2014
Authors
Nuno Moreira Macedo
Hugo Pereira Pacheco
Sousa,NR
Alcino Cunha
Journal Title
Journal ISSN
Volume Title
Publisher
Abstract
Bidirectional transformations have potential applications in a vast number of computer science domains. Spread-sheets, 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. © 2014 IEEE.
Description
Keywords
Citation