Skip to content

Eurostat Data for Calc 1.0.2

Choose a tag to compare

View all tags
@davidjayjackson davidjayjackson released this 08 Jul 22:41
v1.0.2
ad674b0

Docs-only release — no functional changes to the add-in itself. EurostatAddin-1.0.2.oxt is
byte-for-byte the same code as 1.0.1, just re-versioned to match this tag.

The README's Usage section now includes the sinceTimePeriod example and tec00118 (yearly
HICP inflation) dataset entry that were already documented in the
v1.0.1 release notes
but missing from the README itself.

Install

Download EurostatAddin-1.0.2.oxt below, then either double-click it to open the Extension
Manager, or:

/path/to/libreoffice/program/unopkg add EurostatAddin-1.0.2.oxt

Usage

=EUROSTATDATA(datasetCode; filters)
  • datasetCode — a Eurostat dataset code, e.g. nama_10_gdp.
  • filters — optional dimension filters as key=value pairs separated by ;, e.g.
    "geo=DE;time=2023;unit=CP_MEUR". Pass "" for no filtering. See the
    filters cheatsheet
    below for syntax, gotchas, reserved parameters, and common dimension keys.

Enter it as an array formula so the whole table spills out: select a range large enough for the
result, type the formula, and confirm with Ctrl+Shift+Enter (recent LibreOffice versions with
dynamic array support will spill automatically from a single cell).

Returns a table: a header row (one column per dimension, plus value), followed by one row per
observation. Errors show as a readable #ERROR: ... cell instead of Err:5xx.

=EUROSTATDATA("nama_10_gdp"; "geo=DE;time=2023;unit=CP_MEUR")
=EUROSTATDATA("une_rt_a"; "geo=FR;time=2023")
=EUROSTATDATA("tec00118"; "geo=DE;sinceTimePeriod=2015")

The last example uses sinceTimePeriod, one of Eurostat's own reserved query parameters (not a
dimension) — useful for pulling a whole year range back in one call. lastTimePeriod works the
same way. Any filter key you pass goes straight into the API query string.

Filters cheatsheet

Download eurostat-filter-cheatsheet.pdf
below — a 3-page quick reference for the filters argument: syntax, the one-value-per-key
gotcha, Eurostat's reserved query parameters (sinceTimePeriod, lastTimePeriod, lang,
precision, geoLevel), and commonly-seen dimension keys (geo, time, unit, sex, age,
and more).

Try it

Download Eurostat-Demo.ods
below — it has several EUROSTATDATA(...) formulas already entered and computed against live
data, so opening it (after installing the add-in above) shows the function working right away.

Assets 5
Loading