2017
DOI: 10.1002/smr.1895
|View full text |Cite
|
Sign up to set email alerts
|

Parsing Excel formulas: A grammar and its application on 4 large datasets

Abstract: Spreadsheets are popular end user programming tools, especially in the industrial world. This makes them interesting research targets. However, there does not exist a reliable grammar that is concise enough to facilitate formula parsing and analysis and to support research on spreadsheet codebases. This paper presents a grammar for spreadsheet formulas that can successfully parse 99.99% of more than 8 million unique formulas extracted from 4 spreadsheet datasets. Our grammar is compatible with the spreadsheet … Show more

Help me understand this report

Search citation statements

Order By: Relevance

Paper Sections

Select...
1
1

Citation Types

0
2
0

Year Published

2019
2019
2022
2022

Publication Types

Select...
4

Relationship

2
2

Authors

Journals

citations
Cited by 4 publications
(2 citation statements)
references
References 23 publications
0
2
0
Order By: Relevance
“…To do so, we use XLParser, a parser developed by Aivaloglou et. al [27] [28] that produces a parse tree for spreadsheet formulas. In XLBlocks, this parse tree is converted into an XML definition of the block model, which is then translated to the formula's block-based representation (see Figure 2).…”
Section: B Generate Block-based Formulasmentioning
confidence: 99%
“…To do so, we use XLParser, a parser developed by Aivaloglou et. al [27] [28] that produces a parse tree for spreadsheet formulas. In XLBlocks, this parse tree is converted into an XML definition of the block model, which is then translated to the formula's block-based representation (see Figure 2).…”
Section: B Generate Block-based Formulasmentioning
confidence: 99%
“…The tasks are summarized in Table II. To ensure that the tasks would be similar to the tasks the participants perform in their spreadsheets, we selected formulas that are frequently used in spreadsheets from the Enron corpus [14] and our collection of industry spreadsheets [16].…”
Section: Think-aloud Studymentioning
confidence: 99%