APPX Software Library

Chapter 5: Read APPX Data with Excel, Access and LibreOffice

Help LibreOffice Find a Saved Base Connection

If Calc reports Error accessing data source 'APPX-553-COUNTRY' with com.sun.star.container.NoSuchElementException, check the LibreOffice registration before changing the APPX gateway or password. The 5.5.1 test reproduced that message after reopening the workbook in a different profile that did not contain the registration.

  1. Confirm that APPX-553-COUNTRY.odb still exists and that the current LibreOffice process is 32-bit.
  2. Open Tools → Options → LibreOffice Base → Databases in that same profile.
  3. Select New. Set Database file to the existing .odb file, and Registered name to exactly APPX-553-COUNTRY, matching the workbook's saved source name.
  4. Select OK, then OK in Options. If a registration already exists but its file moved, use Edit and correct its path instead of adding a conflicting second name.
  5. Return to the workbook, select a cell in the database range, and use Data → Refresh Range. Supply the APPX login when requested.

A Windows System DSN is computer configuration; a LibreOffice registered database belongs to a LibreOffice user profile. Copying the ODS or .odb alone does not create that registration. Keep each connection layer's name and location in the deployment notes so a moved workbook can be repaired without rebuilding the shared APPX SQL definitions.