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 Updated  
Version 0.4.1 First public version. 6.1 Linux, Windows GPL 2022-06-13 19:04:16 Download

Related Extensions

VBA Expressions

Logo for VBA Expressions

VBA Expressions is a powerful string expression evaluator for LO Basic, providing the user with more than 100 mathematical, statistical, financial, date-time, logical and text manipulation functions, with support for variables and arrays.

10-2024

5787

★ ★ ★ ★ ★

MACROS EXTENSION FOR LIBREOFFICE

Logo for MACROS EXTENSION FOR LIBREOFFICE

Extension for scripting

04-2024

5853

★ ★ ★ ☆ ☆

LibreOffice Calc TCP to RTD

This is a Python based extension for LibreOffice Calc to make real-time data available in Calc spreadsheets via a TCP socket

04-2024

644

Not rated yet

LEIER_ZestAllplan

Screenshot for LEIER_ZestAllplan

Makra wspomagające konwersję zestawień prętów i siatek zbrojeniowych z Allplana na pliki produkcyjne stosowane w LEIER POLSKA- Zakład w Malborku.

04-2024

29

Not rated yet

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