thecat TheCAT

TheCAT (the Calc Audit Tool) is a tool to document your Calc spreadsheets structure and components.

Calc Documentation Spreadsheets
Download latest

latest release: 2024-03-18 12:16:34

Description

Did you ever need to document a spreadsheet structure? Were you once given maintenance on a spreadsheet you had no idea how it was designed and by whom? Did you spend endless hours collecting sparse information to fill some audit documentation or just to understand how that spreadsheet was actually working? Did you curse that painstaking and error prone work?
If you did recognize yourself, then TheCAT is for you.

TheCAT is an auditing tool for LibreOffice Calc spreadsheets. With its help, you get a full report in a single document, with many pieces of information about the document being examined.

 

TheCAT :

  • Documents the document general settings: description, custom properties, security options.
  • Documents the spreadsheet properties: security, display options, custom number formats, styles, used fonts, named ranges and database ranges, sheets list with their relations, dynamic tables, external links, macros and events.
  • Gives details about each individual sheet: name, data zone, links with other sheets, settings, zones (print zone, repeated columns and rows), hidden columns and rows, ranges, dynamic tables, external links, conditional formats, annotations, OLE items, diagrams, graphics, controls and events.
  • The report last chapter is a set of hints, from the points met when processing the document (no metadata, no creation date, unused user-defined styles, unused custom number formats, fonts only used in conditional formats, screen freeze with abnormal values, invalid dynamic tables, non-existing styles referenced by conditional formats, unnamed OLE objects),
  • Can create reports under LibreOffice Writer. 

 

Moreover:

  • You may customize the report template and add a logo, a company name, or for localization purposes.
  • You may select the template to use and manage your own templates list. This list is kept between sessions.
  • Optionally, settings may be saved.
  • The tool may be localized using PO files. The PO format (portable object) and use are described in the gettext pages from the GNU Translation Project, here : https://www.gnu.org/software/gettext/manual/gettext.html

 

TheCAT icons come from the Flaticon web site (https://www.flaticon.com): the extension icon and toolbuttons icons are by freepik (https://www.freepik.com/). These icons are free to use.

Release List

Release Description Compatibility Operating Systems License Release notes   Version 0.20.5 A spreadsheet property added 6.3 Linux, Windows, macOS GPL

Added: the spreadsheet NullDate property (the reference date) in Spreadsheet / General chapter.

Download Version 0.20.4 Templates update 6.4 Linux, Windows, macOS GPL

As LibreOffice v.7.5 drops the Source Sans Pro and Source Code Pro fonts, the TheCAT templates -- that use these fonts -- had to be updated accordingly, otherwise the documents would look ugly.

The Source * fonts were replaced with Linux Biolinum G, Linux Libertine G and Liberation Mono.

Download Version 0.20.3 Fix 6.4 Linux, Windows, macOS GPL

Fixes a nasty bug causing crashes under Windows.

Download Version 0.20.2 Fixes 6.4 Linux, Windows GPL

Fixed:

  • multiple keywords detection fails.
  • validity lists summary is broken.
Download Update 0.20.1 FormulaBar height 6.4 Linux, Windows GPL

Added: formulabar height is reported (for LibO v.7.4+)

Download First public version - v.0.20.0 6.4 Linux, Windows GPL Download
Show more

Other Extensions

Styles Reporter

A Calc and Writer document styles report tool.

03-2024

287

★ ★ ★ ★ ★

UserFieldsMgr

Outils de gestion des champs d'utilisateur (aka champs maîtres)

02-2024

108

★ ★ ★ ★ ★

ODF2PDF

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

03-2024

16316

★ ★ ★ ★ ★

POTGun

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

03-2024

72

★ ★ ★ ★ ★

InLine Headings

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

03-2024

296

★ ★ ☆ ☆ ☆

VersionMgr

VersionMgr is a tool to manage your LibreOffice document version numbers.

03-2024

365

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