Automatically extracting class diagrams from spreadsheets
ECOOP'10 Proceedings of the 24th European conference on Object-oriented programming
Type-safe evolution of spreadsheets
FASE'11/ETAPS'11 Proceedings of the 14th international conference on Fundamental approaches to software engineering: part of the joint European conferences on theory and practice of software
End-users productivity in model-based spreadsheets: an empirical study
IS-EUD'11 Proceedings of the Third international conference on End-user development
From relational ClassSheets to UML+OCL
Proceedings of the 27th Annual ACM Symposium on Applied Computing
Detecting and visualizing inter-worksheet smells in spreadsheets
Proceedings of the 34th International Conference on Software Engineering
Towards a catalog of spreadsheet smells
ICCSA'12 Proceedings of the 12th international conference on Computational Science and Its Applications - Volume Part IV
Model-based programming environments for spreadsheets
SBLP'12 Proceedings of the 16th Brazilian conference on Programming Languages
Data clone detection and visualization in spreadsheets
Proceedings of the 2013 International Conference on Software Engineering
| Hi-index | 0.00 |
In this paper, we demonstrate how implicit structural properties of spreadsheet data can be exploited to offer edit assistance to spreadsheet users. Our approach is based on the discovery of functional dependencies among data items which allow automatic reconstruction of a relational database schema. From this schema, new formulas and visual objects are embedded into the spreadsheet to offer features for auto-completion, guarded deletion, and controlled insertion. Schema discovery and spreadsheet enhancement are carried out automatically in the background and do not disturb normal user experience.