LibreOffice Logo LibreOffice Logo Extensions, Documentation and Templates repository

Bugerra big Bugerra

Find invalid formulas in a spreadsheet

★ ★ ★ ★ ★
Calc Spreadsheets
Download latest

latest release: 2024-03-19 15:54:28

Description

Calc is equipped with an excellent set of tools for analyzing errors in formulas - Detective. Select the cell with the error and in a few clicks find out the source of the errors, which cells the formula in the selected cell depends on, which cells this error affected...

But imagine the situation when you open a large spreadsheet. Very big. Huge. Many sheets, many cells with data, many formulas. Worse, you are not the author of this monster. Even worse, you have to make changes to this spreadsheet - change something, add something, delete something.

Already now you are not sure that there are no errors here. But finding them just by scrolling on it through the data is very difficult. You are not sure if your fixes will not generate new bugs. And they can appear anywhere ("the spaghetti effect - you drag pasta from one side of the plate, and something move on the other side")

The Bugerra extension is designed to find all errors in a spreadsheet and display them all in one place. (Do you remember Bagheera? He is very fast-paced. This one also tries to be fast)

It's very easy to use. Run the macro from the Tools-Detective-Bugerra menu and get a dialogue. If you are lucky, it will contain only one line - "No errors found".

Otherwise, click on the lines in the list and move to the next cell from the list. Fix the error in the formula and click the Refresh button to reread the errors again.

If you choose the sorting "By Importance", the cells that are referenced by more formulas will move to the beginning of the list. It may well happen that by correcting the topmost error, you simultaneously correct all errors.

If there are a lot of mistakes and you don't want to spend your time correcting them (and this is rightly!), click on the "To Sheet" button. The macro will create a new sheet named _BugErrAList in this spreadsheet listing all errors found. Return the spreadsheet to the author - let him waste the time of his life on this nonsense.

Homepage: https://extensions.libreoffice.org/?Tags%5B%5D=114&Tags%5B%5D=48

Release Description Compatibility Operating Systems License Release notes Updated  
Bugerra-L-0.8.1 Beta 7.0 Windows GPL Not tested for Mac and Linux 2021-06-02 14:21:46 Download

Related Extensions

Calendrier perpétuel

Screenshot for Calendrier perpétuel

Auteur :Angomadi 
this is an upgrade to calendar years from 2016 to 2026
C'est une mise a jour pour les années 2026 a 2026
documentation en français ajoutée ,le contenu est en espagnol

07-2024

1910

Not rated yet

MACROS EXTENSION FOR LIBREOFFICE

Logo for MACROS EXTENSION FOR LIBREOFFICE

Extension for scripting

04-2024

5899

★ ★ ★ ☆ ☆

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

Materialliste für Tischler - Schreiner

Logo for Materialliste für Tischler - Schreiner

Materialliste für Tischler - Schreiner als Grundlage zur Vorkalkulation

04-2024

614

Not rated yet

Lox365: Modern functions for LibreOffice

Screenshot for Lox365: Modern functions for LibreOffice

Lox365 is a LibreOffice extension that adds modern spreadsheet functions like IMAGE to LibreOffice. https://github.com/goosepirate/lox365

10-2024

3814

★ ★ ★ ★ ☆

Energy Accounting (German version)

This energy accounting includes automatic reporting of the entries. It is available only in German.

04-2024

502

Not rated yet

Feedback

★ ★ ★ ★ ★

Post your review

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

Reviews

  • Colin Howard Oct 26, 2021, 2:25 PM (3 years ago)

    ★ ★ ★ ★ ★

    It seems the comment system can't cope with emojis. Those four question marks are how it translates a thumb-sup.
    Still, Happy to give John ten stars

  • Colin Howard Oct 26, 2021, 2:17 PM (3 years ago)

    ★ ★ ★ ★ ★

    I remember JohnSUN writing the first macro in response to my query in ASK Libre and that worked just fine. I've just discovered his extension and it's still amazing.
    Well done sir????

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