Historical

Ce document en français.

Regarding installation, configuration and use, please consult the documentation.

What has been done for version 0.0.5:

• Writing of a new XWizard interface in order to replace the Wizard service which became defective with version 6.4.x and 7.x of LibreOffice (see bug 132110).

  This new interface also fixes bug 132661 and bug 132666 and allows access to versions 6.4.x and 7.x of LibreOffice…

  In addition this new XWizard adds new functionality such as:

  • Automatic resizing of the Wizard to the dimensions of the first displayed page.
  • Automatic move to page X on opening if possible.

• Fixed an issue with tokens without expiration (as used by Dropbox) on testing their validity…

• Many other fix…

What has been done for version 0.0.6:

• Rewrite of the OAuth2 wizard trying to follow the MVA model as best as possible. This wizard is made up of 5 pages inheriting from the UNO XWizardPage interface:

  • Page 1: Adapter and View
  • Page 2: Adapter and View
  • Page 3: Adapter and View
  • Page 4: Adapter and View
  • Page 5: Adapter and View

• Rewrite of the three UNO services provided by the OAuth2OOo extension in three separate files:

  • The OAuth2Service service implementing the interface described in the XOAuth2Service IDL file.
  • The OAuth2Dispacher service implementing the UNO interface XDispatchProvider.
  • The OAuth2Handler service implementing the UNO interface XInteractionHandler2.

• Rewrite of the options dialog accessible by Tools -> Options -> Internet -> Protocol OAuth2. This dialog is composed of two windows:

  • The logging window: Adapter and View.
  • The OAuth2OOo extension configuration options window: Adapter and View.

• Rewrite a single data model: OAuth2Model managing wizard, services and options dialog.

• Google loopback flow error has been fixed. See Issue #10

• Use for Dropbox their new OAuth2 API with expirable tokens.

• Many other fix…

What has been done for version 1.0.0:

• Porting Python API Requests to LibreOffice / OpenOffice UNO API. Two UNO interfaces are accessible:

  • HTTP request parameters: com.sun.star.rest.XRequestParameter.idl
  • The response to the HTTP request: com.sun.star.rest.XRequestResponse.idl

  The XRequestParameter interface supports sync token handling as well as HTTP request paging, as used in the HTTP Rest APIs

• Uploading and downloading files is possible thanks to the methods or properties:

  • XOAuth2Service.download() allowing resumable file download.
  • XOAuth2Service.upload() allowing resumable file upload.
  • XOAuth2Service.getInputStream() to get an input stream.
  • XRequestParameter.DataSink to set an input stream.
  • XRequestResponse.getInputStream() to get an input stream.

• Porting Java API javax.json to LibreOffice / OpenOffice UNO API as defined in idl files: com.sun.star.json.*

  • A factory of JSON structures is accessible via the getJsonBuilder() interface of XRequestParameter.
  • A Json parser is returned by the getJson() interface of XRequestResponse.

This makes HTTP requests using JSON easily usable in the BASIC language of LibreOffice.

What has been done for version 1.0.1:

• Writing of 15 functions in Calc AddIns as described in the following files:

  • The file OAuth2Plugin.idl which declares new interfaces to UNO.
  • The file CalcAddIns.xcu which makes available these new interfaces in the list of Calc functions.
  • The file OAuth2Plugin.py which is the implementation of the UNO service com.sun.star.auth.Oauth2Plugin providing these new interfaces.
  • The file plugin.py which is the library implementing the interfaces of this new UNO service.

• These 4 new files give access to 15 new Calc formulas which are:

  • GETHTTPBOBY(URL,METHOD,ENCODING,PARAMETERS)
  • PARSEHTML(DATA,PATH,BASEURL)
  • PARSEXML(DATA,PATH,BASEURL)
  • PARSEJSON(DATA,PATH)
  • JAVASCRIPT2XML(DATA,PATH)
  • XML2JSON(DATA,PATH)
  • JAVASCRIPT2JSON(DATA,PATH)
  • DUBLINCORE2JSON(DATA,BASEURL)
  • JSONLD2JSON(DATA,BASEURL)
  • MICRODATA2JSON(DATA,BASEURL)
  • MICROFORMAT2JSON(DATA,BASEURL)
  • OPENGRAPH2JSON(DATA,BASEURL)
  • RDFA2JSON(DATA,BASEURL)
  • FLATTENJSON(DATA,TYPENAME,PATH,SEPARATOR)
  • SPLITJSON(DATA,TYPENAME,PATH,SEPARATOR)

What has been done for version 1.1.0:

• End of support for Python 2.x and therefore for OpenOffice.

• Integration of Selenium version 4.10 in the extension in order to make LibreOffice able to control a browser via Calc formulas inserted in a spreadsheet.

• Use of webdriver_manager version 3.8.6 to automate the installation of the browser’s WebDriver.

• Creation of 5 Calc formulas allowing the piloting of the browser:

  • BROWSEROPEN(BROWSER,PATH,INIT,OPTIONS)
  • BROWSERCLICK(SESSION,BY,PATH,URL,INIT,WAIT)
  • BROWSERFIELD(SESSION,BY,PATH,VALUE,URL,INIT,WAIT)
  • BROWSERFORM(SESSION,FORM,URL,INIT,WAIT)
  • BROWSERCONTENT(SESSION,URL,ENCODING)

• Creation of a Calc formula allowing HTTP Basic Auth authentication for HTTP requests:

  • HTTPAUTH(NAME,PASSWORD)

• Calc formula GETHTTPBOBY has been renamed to HTTPCONTENT.

What has been done for version 1.1.1:

• Fixed an issue in the implementation of the com.sun.star.rest.XRequestParameter interface not allowing to create empty JSON objects (ie: “Object”: {} ) as requested by the Microsoft Graph API.

What has been done for version 1.1.2:

• Modification of the idl files: XRequestParameter.idl and XRequestResponse.idl and the underlying python implementations: requestparameter.py and requestresponse.py in order to make it possible POST requests with application/x-www-form-urlencoded encoding. See issue #13.

• 3 macros in BASIC: ChatGPTRequest, HTTPGetRequest and HTTPPostRequest are available in: Tools -> Macros -> Run Macros… -> My Macros -> OAuth2OOo. Be careful, these macros will not work if no document is open (I don’t know why?)…

• From now on, with each push, a workflow perform a scan on the code with Fluid Attacks. This has been implemented to follow the Cloud Application Security Assessment (CASA) and meet the requirements for revalidation of the OAuth2OOo extension with Google.

• For the same reasons, the Data Protection Policy has been modified in order to specify the Nature and scope rights over your data.

What has been done for version 1.2.0:

• There are now two methods of creating the OAuth2Service service which are:
  • create() without parameter, returns an instance of the service.
  • createWithOAuth2([in] string sUrl, [in] string sUser) with an Url and the user’s address, returns an instance of the service with the OAuth2 protocol.
    In its second form, the OAuth2 authorization Wizard will launch automatically if the scope of the Url rights has not yet been granted by the user (ie: first connection).
    If this is the case and the Wizard is aborted then a null value will be returned instead of the requested service.
• Two BASIC macros: GoogleAPIRequest and GraphAPIRequest allow you to make HTTP requests on the Google Contact and Microsoft Graph APIs.
  The OAuth2 protocol essential for the use of these APIs is integrated automatically and transparently into HTTP requests. You won’t have to worry about it.

What has been done for version 1.2.1:

• Added a new method isAuthorized() to the XOAuth2Service interface supported by the OAuth2Service service. This method allows you to launch the OAuth2 configuration Wizard if the user is not authorized.

What has been done for version 1.2.2:

• Fixed an error when refreshing OAuth2 tokens.

What has been done for version 1.2.3:

• Fixed an error on isAuthorized() on OAuth2Service.

What has been done for version 1.2.4:

• Updated embedded python packages.

What has been done for version 1.3.0:

• Using the new version 3.6.2 of pyRdfa3.
• All Python packages necessary for the extension are now recorded in a requirements.txt file following PEP 508.
• Now if you are not on Windows then the Python packages necessary for the extension can be easily installed with the command:
  sudo -i pip3 install requirements.txt
• Simplification of the Requirement section.
• Many fixes…

What has been done for version 1.3.1:

• Fixed the Headers property in the implementation of the UNO interface XRequestResponse allowing to obtain the headers of an HTTP response.
• Many fixes…

What has been done for version 1.3.2:

• Integration of Python 3.8 binaries for Linux x86_64 and Darwin x86_64, in order to be compatible with the version of LibreOffice 24.2.x for Linux, for the lxml, ijson, cffi and charset-normalizer packages.
• Opening of issue #159988 for the impossibility of importing Python libraries containing binary files with LibreOffice 24.2.x under Linux.

What has been done for version 1.3.3:

• Implemented a workaround for issue #159988 which may take time to resolve.

What has been done for version 1.3.4:

• Updated the Python Idna package to version 3.7 in order to respond to the security vulnerability alert.
• Some fixes…

What has been done for version 1.3.5:

• Updated the Python tqdm package to version 4.66.4 in order to respond to the security vulnerability alert.
• Updated the Python Requests package to version 2.32.3 in order to respond to the security vulnerability alert.
• In order to avoid any conflict with the Python oauth2 package, the folder put in the python path by the extension has been renamed to oauth20. This should also resolve issue #15.
• Some fixes…

What has been done for version 1.3.6:

• Updated the Python beautifulsoup package to version 4.12.3.
• Updated the Python certifi package to version 2024.7.4.
• Added binaries for Python/Manylinux versions 3.9, 3.11 and 3.12 for package Python cffi version 1.16.0.
• Updated the Python charset-normalizer package to version 3.3.2.
• Updated the Python exceptiongroup package to version 1.2.2.
• Updated the Python extruct package to version 0.17.0.
• Updated the Python html-text package to version 0.6.2.
• Updated the Python ijson package to version 3.3.0.
• Updated the Python jsonpath_ng package to version 1.6.1.
• Updated the Python lxml package to version 5.2.2.
• Added package Python lxml-html-clean version 0.2.0.
• Updated the Python packaging package to version 24.1.
• Updated the Python prasel package to version 1.9.1.
• Updated the Python pycparser package to version 2.22.
• Updated the Python pyparsing package to version 3.1.2.
• Updated the Python pyRdfa3 package to version 3.6.4.
• Updated the Python python-dotenv package to version 1.0.1.
• Updated the Python selenium package to version 4.23.1.
• Updated the Python setuptools package to version 72.1.0 in order to respond to the security vulnerability alert.
• Updated the Python sniffio package to version 1.3.1.
• Updated the Python trio package to version 0.26.0.
• Added package Python typing-extensions version 4.12.2.
• Updated the Python urllib3 package to version 2.2.2.
• Updated the Python validators package to version 0.33.2.
• Updated the Python w3lib package to version 2.2.1.
• Updated the Python webdriver-manager package to version 4.0.2.
• Added package Python websocket-client version 1.8.0.

Updating all these Python packages should make it possible to use Python 3.8, 3.9, 3.10, 3.11 and 3.12 under ManyLinux x86_64 architecture.
For win32 and win_amd64 architectures, only Python version 3.8 is supported. This means that since Python is embedded into LibreOffice for these architectures, only LibreOffice versions 7.x and 24.x are supported.
If your architecture is not yet supported by OAuth2OOo (Mac OSX, arm…), I advise you to open an issue so that I can add the missing binaries.

What has been done for version 1.3.7:

• Updated the Python attrs package to version 24.2.0.
• Updated the Python cffi package to version 1.17.0.
• Updated the Python idna package to version 3.8.
• Updated the Python lxml package to version 5.3.0.
• Updated the Python pyparsing package to version 3.1.4.
• Updated the Python setuptools package to version 73.0.1.
• Updated the Python soupsieve package to version 2.6.
• Updated the Python tqdm package to version 4.66.5.
• Updated the Python trio package to version 0.26.2.
• Logging accessible in extension options now displays correctly on Windows.
• Changes to extension options that require a restart of LibreOffice will result in a message being displayed.
• To work with LibreOffice 24.8.x and Windows (32 and 64 bit), added binaries, for Python version 3.9 and win32 or win_adm64 architectures, to all Python packages included in the extension.

What has been done for version 1.3.8:

• Modification of the extension options accessible via: Tools -> Options… -> Internet -> OAuth2 Protocol in order to comply with the new graphic charter.

What has been done for version 1.3.9:

• Added a new fromJson() method to the XRequestParameter interface to make it easier to execute an HTTP request from parameters coming from LibreOffice configuration files (ie: xcu/xcs XML files).
• Preparation for the migration of the scopes of rights specific to connections to Google servers.
• Some fixes…

What has been done for version 1.4.0:

• All data needed for OAuth2 authorization code flow management is now stored in LibreOffice configuration file Options.xcu.
• It is now possible to have an OAuth2 redirect uri (ie: redirect_uri) in https mode as required by some third party APIs, using Github’s SSL certificate and JavaScript, see the file OAuth2Redirect.md.
• The TCP/IP port allowing the reception of the GAFA authorization code is now chosen randomly among the free ports (ie: no more conflict problems).
• It is possible to build the extension archive (ie: the oxt file) with the Apache Ant utility and the build.xml script file.
• The extension will refuse to install under OpenOffice regardless of version or LibreOffice other than 7.x or higher.
• OAuth2 data flow management using authorization code copy has been removed. Only receiving the authorization code via HTTP is now supported.
• Two methods have been added to the XOAuth2Service.idl interface:
  • isRegisteredUrl to know if a URL is registered in the OAuth2 configuration.
  • getTokenWithParameters to obtain an OAuth2 token in the format given by the parameters.
• Added binaries needed for Python libraries to work on Linux and LibreOffice 24.8 (ie: Python 3.9).
• Many fixes…

What has been done for version 1.4.1:

• Updated the Python attrs package to version 25.1.0.
• Updated the Python beautifulsoup4 package to version 4.13.3.
• Updated the Python certifi package to version 2025.1.31.
• Updated the Python cffi package to version 1.17.1.
• Updated the Python charset-normalizer package to version 3.4.1.
• Updated the Python extruct package to version 0.18.0.
• Updated the Python html-text package to version 0.7.0.
• Updated the Python idna package to version 3.10.
• Updated the Python isodate package to version 0.7.2.
• Updated the Python jsonpath_ng package to version 1.7.0.
• Updated the Python lxml package to version 5.3.1.
• Updated the Python packaging package to version 24.2.
• Updated the Python parsel package to version 1.10.0.
• Updated the Python pyparsing package to version 3.2.1.
• Updated the Python rdflib package to version 7.1.3.
• Updated the Python selenium package to version 4.28.1.
• Updated the Python setuptools package to version 75.8.0.
• Updated the Python six package to version 1.17.0.
• Updated the Python tqdm package to version 4.67.1.
• Updated the Python trio package to version 0.29.0.
• Updated the Python urllib3 package to version 2.3.0.
• Updated the Python validators package to version 0.34.0.
• Updated the Python w3lib package to version 2.3.1.
• Support for Python version 3.13.

What has been done for version 1.5.0:

• Updated the Python packaging package to version 25.0.
• Downgrade the Python setuptools package to version 75.3.2. to ensure support for Python 3.8.
• Updated the Python h11 package to version 0.16.0 to address the Dependabot #16 security alert.
• Passive registration deployment that allows for much faster installation of extensions and differentiation of registered UNO services from those provided by a Java or Python implementation. This passive registration is provided by the LOEclipse extension via PR#152 and PR#157.
• Modified LOEclipse to support the new rdb file format produced by the unoidl-write compilation utility. idl files have been updated to support both available compilation tools: idlc and unoidl-write.
• It is now possible to build the oxt file of the OAuth2OOo extension only with the help of Apache Ant and a copy of the GitHub repository. The How to build the extension section has been added to the documentation.
• Implemented PEP 570 in logging to support unique multiple arguments.

What has been done for version 1.5.1:

Added a BASIC macro GithubDownloadRequest to download the latest version of OAuth2OOo from the revisions on the Github site.
To enable downloading from Github, this macro uses two HTTP requests, one to initialize a session with cookies and the other to perform the download.
This might help me find a solution to allow automatic updating of extensions in LibreOffice from Github revisions.

What has been done for version 1.5.2:

• Fixed the BASIC macro GithubDownloadRequest.
• Fixed changelog link in the README.md file.
• You can again use a URL to launch the OAuth2 wizard in the extension options.
• Automatic extension updates have been fixed, see tdf#159775, thanks to Mike Kaganski. This will be available soon in LibreOffice 25.8.x.
• Support for LibreOffice 25.2.x and 25.8.x on Windows 64-bit. See issue#25.

What remains to be done for version 1.5.2:

• Add new language for internationalization…

• Anything welcome…