Posts

GSoC Summary

Working with Lireoffice during GSoC has been a great learning experience. It has helped me get better at C++ and taught me how real world applications are built. I also spent most of my time at the debugger rather than writing code which has helped me improve my debugging skills. It also taught me what a great tool git is for managing commits and has been helpful in more than one occasion.  My mentors, and the Libreoffice community has been very helpful and have guided me whenever I got stuck. It feels good to be a part of such a great community. Below is a list of tasks that was done as part of the GSoC project and also a list of tasks that I wanted to, but could not finish during the period. Work Done Added Data Transformations https://gerrit.libreoffice.org/#/c/58152/   https://gerrit.libreoffice.org/#/c/58151/   https://gerrit.libreoffice.org/#/c/56886/   https://gerrit.libreoffice.org/#/c/56862/   https://gerrit.libreoffice.org/#/c/56780/   Added Base as a

Added Data Tranformations

One of the primary aims of this project was to add more data transformations. Here is a list of commits which helps us achieve these goals: Added text transformations for external data Uppercase , which sets all text in the selected columns to upper case.  Lowercase , which sets all text in the selected columns to lower case.  Capitalize Each Word , which makes all words in the selected column start with a capital letter and sets all subsequent letters in a word to lower case.  Trim , which removes any leading or trailing whitespace characters from text.  Added aggregate functions for external data   Sum , which returns the sum of values in the column.  Average , which returns the average of values in the column.  Min , which returns the minimum of the values in the column.  Max , which returns the maximum of the values in the column.  Added ReplaceNullTransformation   Added date and time transformations Date String, gives the date from datetime value . Year, g

Added Base as Dataprovider

https://gerrit.libreoffice.org/#/c/57447/  Allows us to import data from Libreoffice Base to Calc. While working on this I made use of anumber of UNO interfaces for the dealing with ResultSet

Integrating XML data provider

The basic idea here was to enable us to import data from XML files to Calc. https://gerrit.libreoffice.org/#/c/56356/ helps to achieve this and it also introduced me to Orcus .

Import ODF with data transformations

It deals with importing and applying the data transformations from the stored ODF file which was saved during export (  Export Data Transformations to ODF ). To achieve this commits were push as new transformations were added. These commits are listed below: https://gerrit.libreoffice.org/#/c/58258/ https://gerrit.libreoffice.org/#/c/58258/

Export Data Transformations to ODF

This involves storing information of the data transformations to ODF file during saving so that it can be reapplied while opening the document ( Import data from ODF ). Exporting data to ODF has been done in various steps as new transformations were added. Below is a list of commits that deal with this: https://gerrit.libreoffice.org/#/c/56665/ https://gerrit.libreoffice.org/#/c/57217/ https://gerrit.libreoffice.org/#/c/58254/ To export the sort transformations, some changes had to bedone to the existing code in  this commit where I had to move the  writesort() method from WriteDatabaseRange to free function.

Fixup changes in patches using fixup

While your changes are in the local repository you can  make commit one on top of another and then merge them using git rebase git rebase --interactive HEAD~2  But once pushed we want to ammend the previous commit using fixups using git commit --fixup commitID git rebase -i --autosquash master