Header and Unit Inference for Spreadsheets Through Spatial Analyses

Abraham, Robin; Erwig, Martin

doi:10.1109/vlhcc.2004.29

Cited by 96 publications

(130 citation statements)

References 16 publications

Supporting

Mentioning

130

Contrasting

Order By: Relevance

“…A chain of labels, 1 [ 2 ], represents cells that may have a second level label. In this example, the cell B3 has the header A3, which contains the label Camry.…”

Section: Labelsmentioning

confidence: 99%

“…It can also take into account layout information. Techniques for header inference have been described in detail elsewhere [1,2]. In the context of this paper we simply reuse those techniques.…”

Section: Header Inferencementioning

confidence: 99%

“…The two identified axes will be row 1 and column A. In this case these share a cell, A1, which has been identified as a header for A2, A3, and A4 (for details, see [1]). As it is a header for all of the cells in the vertical axis, it is included with them and ignored in the horizontal axis.…”

Section: No Dimension Axis 2 One Dimension Axis 3 Two Dimension Axesmentioning

confidence: 99%

See 2 more Smart Citations

Combining spatial and semantic label analysis

Chambers

Erwig

2009

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

View full text Add to dashboard Cite

Labels in spreadsheets can be exploited for finding errors in spreadsheet formulas. Previous approaches have either used the positional information of labels or their interpretation as dimension for checking the consistency of formulas.In this paper we demonstrate how these two approaches can be combined. We have formalized a combined reasoning system and have implemented a corresponding prototype system. We have evaluated the system on the EUSES spreadsheet corpus. The evaluation has demonstrated that adding a syntactic, spatial analysis to a dimension inference can significantly improve the rate of detected errors.

show abstract

“…A chain of labels, 1 [ 2 ], represents cells that may have a second level label. In this example, the cell B3 has the header A3, which contains the label Camry.…”

Section: Labelsmentioning

confidence: 99%

Section: Header Inferencementioning

confidence: 99%

See 1 more Smart Citation

Combining spatial and semantic label analysis

Chambers

Erwig

2009

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

View full text Add to dashboard Cite

show abstract

“…The systems described in [5,6] allow the user to carry out consistency checking of spreadsheet formulas on the basis of user annotations, or on the basis of automatically inferred headers [1], and flag the inconsistent formulas as potential faults. Consistency checking can also be carried out using assertions on the range of values allowed in spreadsheet cells [8].…”

Section: Related Workmentioning

confidence: 99%

“…To carry out testing in commercially available spreadsheet systems like Microsoft Excel, users are forced to proceed in an ad hoc manner because tool support for testing is not available. 1 In particular, the lack of tools leaves users without information about how much of their spreadsheet has been tested. In this situation, users come away with a very high level of confidence about the correctness of their spreadsheets even when, in reality, their spreadsheets have many non-trivial errors in them [18].…”

Section: Introductionmentioning

confidence: 99%