pivot table DyntablesUpdater

Tags: Calc Macro Spreadsheets

last edited: 2022-06-14

DynTablesUpdater is a tool for batch updating of dynamic tables (aka data pilots) that can be found in a Calc spreadsheet.

DynTablesUpdater041 EN 00
DynTablesUpdater041 EN 01a
DynTablesUpdater041 EN 02a
DynTablesUpdater041 FR 00
DynTablesUpdater041 FR 01a
DynTablesUpdater041 FR 02a

Description

DynTablesUpdater comes as a three-button toolbar for Calc. They provide the following functionalities:

  1. Display an About dialogue.
  2. Update all dynamic tables found in the active spreadsheet.
  3. Or reset all dynamic tables filters.

DynTablesUpdater is also available in the Tools > Add-ons menu.

 

Other functionnalities :

  • A log file is generated, that is saved beside the processed file (same name, .log extension).
  • A progress bar in the status bar shows the process advance.
  • The tool automatically uses the UI interface language: French or English (fallback language). Internationalization uses .po files. Thus, the extension UI can be easily translated into any unsupported language.
  • One of the modules (_autoDTupdate) provides the same functionality (update all dynamic tables found in the active spreadsheet) without having to use the extension, by linking a document event to its DynTablesUpdate() sub. Note that, as of current version, there's no UI feedback.

 

DynTablesUpdater was sponsored by la ville de Grenoble (Isère - France).

 

The extension icon is from icon-park, available here: https://www.iconfinder.com/icon-park.

The toolbar icons are by Uniconlabs, available at: https://www.flaticon.com/authors/uniconlabs.

These icons are freely available.

 

Release List

Release: Version 0.4.1 – First public version.

Compatibility: 6.1
Operating Systems: Linux, Windows
License: GPL

Other Extensions

PaletteMaker

A tool to help managing LibreOffice personal color palettes.

03-2022

Styles Reporter

A Calc and Writer document styles report tool.

11-2020

UserFieldsMgr

A tool for managing Writer Userfields (aka MasterFields)

04-2021

ODF2PDF

ODF2PDF is a batch export tool for ODF documents to the PDF format.

07-2020

POTGun

A POT file generator for LibreOffice documents and macros string constants.

08-2021

InLine Headings

An inline (or run-in) headings generator for LibreOffice writer documents to comply with some academic reports constraints.

03-2022

Feedback

Post your review

You cannot post reviews until you have logged in. Login Here.

Reviews

No one has commented on this page yet.

RSS feed for reviews on this page | RSS feed for all reviews