Skip to content

Instantly share code, notes, and snippets.

@hmeeks-dot
hmeeks-dot / GSoC2022.FinalReport.md
Last active February 3, 2024 04:03
GSoC 2022 - Final Report - Hannah Meeks

Google Summer of Code 2022 - Final Report

Organisation: Libre Office

Project Title: VBA Macros - Tests and missing APIs

Overview

My task was to write macros tests in VBA and to identify areas in the code to fix in order to improve interoperability between Libre Office Writer and Microsoft Word. I wrote tests on find and replace, paragraph format, document range, tables etc.(see below) as well as writing some code framework to run my tests.

Results

At the start of the project I wrote a test for Value2 and focused on resolving mutex issues from the bonding period/ my first hack. I wrote tests for find and replace and when testing discovered that new find objects kept being created - there were issues around this, I tried anchoring the find object to the selection object which had the same problem, fixed this by making find global. I then made a test framework and changed the filing method to make it easier to add docm files. Looking at the document object I fixed errors to do with setting the ra