v1.0.7

Added

• Extension Manager icons: a bright-blue default icon and a black high-contrast variant (42×42 PNG — an upward line chart with a FRED wordmark), declared via the <icon> element in description.xml and staged into the .oxt by build.ps1/build.sh. They appear next to the extension in Tools → Extension Manager.
• tools/make_icons.ps1, which regenerates both icons from code (System.Drawing) so they are reproducible.

Changed

• Bumped the .oxt extension package version to 1.0.7.

No functional changes to the add-in since 1.0.0.

Install: download FRED.oxt below and run unopkg add FRED.oxt (see docs/INSTALL.md).

v1.0.6 — FRED LibreOffice Calc Add-In

Maintenance release. Same functionality as v1.0.0–v1.0.5; fixes CHANGELOG
links broken by the v1.0.0–v1.0.2 release cleanup.

Changes since v1.0.5

• Deleted the v1.0.0–v1.0.2 GitHub Release entries (tags left intact).
  Repointed CHANGELOG.md's v1.0.0–v1.0.2 links at the tagged repo tree
  instead of the now-nonexistent release pages.
• Extension package version bumped to 1.0.6.

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 (covers Linux/macOS too). Full history in CHANGELOG.md.

License

MIT.

v1.0.5 — FRED LibreOffice Calc Add-In

Maintenance release. Same functionality as v1.0.0–v1.0.4; regenerates the
demo spreadsheet against the previous release.

Changes since v1.0.4

• Regenerated test/fred_demo.ods against the published v1.0.4 release
  asset (installed via unopkg) to confirm it still works end-to-end.
• Extension package version bumped to 1.0.5.

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 (covers Linux/macOS too). Full history in CHANGELOG.md.

License

MIT.

v1.0.4 — FRED LibreOffice Calc Add-In

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.

v1.0.3 — FRED LibreOffice Calc Add-In

Maintenance release. Same functionality as v1.0.0–v1.0.2; adds a Linux/macOS
build path and fixes broken release links.

Changes since v1.0.2

• Added build.sh, a POSIX shell port of build.ps1 for building FRED.oxt
  on Linux/macOS (resolves LibreOffice/JDK from --libreoffice/--jdk flags
  or LO_HOME/JAVA_HOME).
• Fixed release links in the README and CHANGELOG that pointed at the old
  repo name java_federal_reserve- (trailing hyphen).
• Extension package version bumped to 1.0.3.

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. Full history in CHANGELOG.md.

License

MIT.