LibreOffice Logo LibreOffice Logo Extensions, Documentation and Templates repository

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

Other Extensions

BASIC Les Événements (Français)

Screenshot for BASIC Les Événements (Français)

04-2024

163

Not rated yet

BASIC Bibliothèque d'éxecution (Français)

Screenshot for BASIC Bibliothèque d'éxecution (Français)

 
 

Not rated yet

BASIC Les Dialogues (Français)

Screenshot for BASIC Les Dialogues (Français)

 
 

Not rated yet

BASIC Les Fichiers (Français)

Screenshot for BASIC Les Fichiers (Français)

BASIC Les Fichiers

04-2024

60

Not rated yet

BASIC Paramètres d'Éxécution (Français)

Screenshot for BASIC Paramètres d'Éxécution (Français)

04-2024

126

Not rated yet

BASIC Types Structurés (Français)

Screenshot for BASIC Types Structurés (Français)

04-2024

162

★ ★ ★ ☆ ☆

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