APPX Software Library

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

Load COUNTRY into LibreOffice Calc and Refresh It

First complete the registered Base connection and COUNTRY ordered query. Use Calc from the same 32-bit LibreOffice installation and profile. The AppxODBC Windows DSN and the registered Base connection have different roles: the DSN selects the gateway; the registered name locates the .odb file and its saved query.

  1. From Base, select File → New → Spreadsheet, or start the matching 32-bit Calc executable. Create a blank spreadsheet and select cell A1.
  2. Select View → Data Sources. Expand APPX-551-COUNTRY → Queries and select COUNTRY ordered. Supply the APPX login if requested. The data browser displays the query's rows above the worksheet.
Calc can use the query registered by Base.
Figure 15. Calc can use the query registered by Base.
  1. Drag COUNTRY ordered from the left-hand data-source tree onto worksheet cell A1. This inserts a database range with field headings; it is not a CSV paste.
  2. Check A1:I8: one heading row, 7 data rows, and 9 columns. Select columns A through I and double-click a column boundary to fit their contents if necessary.
  3. Select a cell within the imported range, then select Data → Refresh Range. Wait for completion and check the same values. This re-runs the source query; editing the worksheet is not a supported way to update APPX.
Refresh the imported database range from its saved query.
Figure 16. Refresh the imported database range from its saved query.
  1. Save as APPX-551-COUNTRY.ods, retaining the ODF Spreadsheet format. Keep APPX-551-COUNTRY.odb at its registered location. The workbook's database range refers to the registered connection name and saved query.
  2. Exit LibreOffice, reopen the ODS in the matching 32-bit installation and profile, select a cell inside the imported range, and use Data → Refresh Range again. Supply the APPX password when prompted, wait for completion, and save.
The saved Calc workbook contains the complete COUNTRY sample.
Figure 17. The saved Calc workbook contains the complete COUNTRY sample.

The ODS was reopened in a fresh process, the missing profile registration was restored, and refresh completed after the APPX password prompt. The refreshed, saved ODS values were compared with an independent native APPX export: all 7 records and all 9 fields agree, including empty audit dates. The saved file contains database range Import1, target Sheet1.A1:I8, and source query COUNTRY ordered. Date cells remain date values even when the displayed date format differs from another client.

Keep the .odb connection, its LibreOffice registration, the Windows DSN and gateway access available for refresh. A workbook copied to another computer carries its saved worksheet data, but it does not install a driver, create a DSN or register its Base connection. Use the registration repair when the named source cannot be found. LibreOffice describes the Refresh Range command separately from refreshing a data-browser display.