Skip to content

v1.0.4 — FRED LibreOffice Calc Add-In

Choose a tag to compare

@davidjayjackson davidjayjackson released this 07 Jul 22:25

Maintenance release. Same functionality as v1.0.0–v1.0.3; documents the
Linux/macOS build & install path.

Changes since v1.0.3

  • docs/INSTALL.md now documents building and installing on Linux/macOS
    alongside Windows: acquiring a JDK 8 and LibreOffice + SDK without root,
    the Temurin javavendors.xml allow-list fix needed for unopkg to load
    the Java bridge, build.sh usage (and its manual by-hand equivalent),
    unopkg install, and the headless test workflow.
  • Regenerated test/fred_demo.ods against a live rebuild.
  • Extension package version bumped to 1.0.4.

No functional changes to the add-in.

Functions

Function Purpose
FRED_SERIES(id; [start]; [end]; [api_key]; [headers]) Observations as a spillable (date, value) array. Accepts date cells; optional header row.
FRED_DESCRIPTION(id; [api_key]) Series title.
FRED_META(id; field; [api_key]) A single metadata field.
FRED_FIELDS(id; [api_key]; [headers]) Lists a series' metadata fields — the valid FRED_META field names.
FRED_LATEST(id; [api_key]) Most recent non-missing observation.

Every function takes an optional trailing api_key; when omitted it falls back to the FRED_API_KEY environment variable.

Install

Download FRED.oxt below and install it:

unopkg add --force FRED.oxt

Then set FRED_API_KEY (or pass a key per formula). See docs/INSTALL.md for details (now covering Linux/macOS too). Full history in CHANGELOG.md.

License

MIT.