Automatically filling data in LibreOffice Calc

Implementation-oriented individual or group project
Keywords: libreoffice, spreadsheet, program synthesis

Spreadsheet application, such as Microsoft Excel and LibreOffice Calc, are popular tools for organization, analysis and storage of data in tabular form. They store data in cells, and allow users to define formulas that automatically calculate and display values based on the contents of other cells. Manually defining formulas can be tedious, and introduces a steep learning curve. To simplify formula creation, Microsoft Excel provides FlashFill that automatically synthesizes formulas based on provided examples. The core technology behind FlashFill is program synthesis, whose goal is to automatically construct programs or expressions based on given specification. LibraOffice, a popular open source spreadsheet application, lacks this functionality. The goal of this project is to implement a version of FlashFill for LibreOffice Calc. Besides, the developed system should also provide a novel feature — it will automatically correct wrong user formulas based on given examples.

Goals

Required skills

Relevant links & publications