LibreOffice macro copying entries from Writer form controls to Calc cells

REQUIRED SKILL : LibreOffice macros in Python or VB DELAY : To be fixed by mutual agreement, depending on developper estimation. LANGUAGE : French or English speaking. JOB DESCRIPTION Write a LibreOffice 4.3.5.2 macro that can be associated with a choosable event of any form control (of type listed in attached Writer document) created in a Writer document. On an event, the macro should copy the entry made by the user in the Writer form control to a Calc cell which has the same name as the form control. • If the user has done no entry, then the macro should do nothing. But if there is a default entry, this default entry should be copied. • The names can be any name that is accepted by LibreOffice as a form control name in Writer and a field name in Calc. The Calc file, to which Writer form control entries are copied to, is supposed to have same name and path as the Writer file (ex. [login to view URL] and [login to view URL]). Il the Calc file is not already opened, the macro should open it and return an error message if it doesn't exist. The macro should work with LibreOffice on windows or mac. TEST The Writer and Calc documents are given for test purpose. Each form control in the Writer document has a corresponding field in the Calc document (the field is an individual cell). A final test will have to be done on Skype, by the developper, after finding a common 1 hours time slot between 9 AM and 12 PM UTC+1. DELIVERY A file containing the macro. The file must be ready to use with LibreOffice 4.3.5.2.