pivot table DyntablesUpdater

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

Calc Macro Spreadsheets
Download latest

latest release: 2024-03-13 01:48:52

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 Description Compatibility Operating Systems License Release notes   Version 0.4.1 First public version. 6.1 Linux, Windows GPL Download

Other Extensions

PaletteMaker

A tool to help managing LibreOffice personal color palettes.

03-2024

811

★ ★ ☆ ☆ ☆

BASIC Runtime paramenters (English)

LibreOffice BASIC Runtime Paramenters Reference Card.

03-2024

4039

Not rated yet

BASIC Files (English)

LibreOffice BASIC Files Reference Card.

03-2024

4300

Not rated yet

BASIC Dialogs (English)

LibreOffice BASIC Dialog Reference Card.

03-2024

4202

Not rated yet

BASIC Runtime Library (English)

LibreOffice BASIC Runtime Library Reference Card.

03-2024

4223

Not rated yet

BASIC Events (English)

LibreOffice BASIC Events Reference Card.

03-2024

3798

Not rated yet

Feedback

☆ ☆ ☆ ☆ ☆

Post your review

You cannot post reviews until you have logged in. Se connecter.

Reviews

Il n'y a pas encore de commentaire.

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