2018/08/31 by Paul Mireault, Mireault, Paul
Computer Science · Mathematics · #Chemical and Environmental Engineering Research #FOS: Computer and information sciences #Software Engineering (cs.SE) #Spreadsheets and End-User Computing #Statistics Education and Methodologies #cs.SE
paper · pdf · doi:10.48550/arxiv.1809.00025
In Proceedings of the 5th International Workshop on Software Engineering Methods in Spreadsheets (arXiv:1808.09174)
arxiv created 2018/08/31 · openalex publication_date 2018/08/31 · arxiv updated 2018/09/05 · openalex created_date 2025/10/10 · openalex updated_date 2026/07/28
The WHERE and ORDER BY clauses of the SQL SELECT statement select a subset of rows in the result of a database query and present the result in the specified order. In a spreadsheet program like Microsoft Excel, one could use the filter and sort buttons, or use its Query or its Pivot Table tools to achieve a similar effect. The disadvantage of using those tools is that they don't react automatically to changes in the calculated values of the spreadsheet. In this paper, we develop spreadsheet formulas that implement SQL's WHERE and ORDER BY clauses.