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

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

5609

★ ★ ★ ★ ★

Stock Trading Investing Log Journal for DayTrading, Swing Trading, Investors

Logo for Stock Trading Investing Log Journal for DayTrading, Swing Trading, Investors

Stock Market Trader: YOU need a spreadsheet! LearnN.ods tracks your trades; Supports multiple brokers, any trading style (day, swing, investing), counts your day-trades, logs your errors, improves your game!&l

04-2024

723

Not rated yet

Calendario Perpetuo

Logo for Calendario Perpetuo

Es una plantilla de calendario que se adapta automáticamente al idioma local instalado en el sistema. Permite elegir el año y el <span style="text-deco

04-2024

1355

Not rated yet

Blutdrucktabelle_DinA6

Blutdrucktabelle DinA6Blood-Pressure - smart

04-2024

176

Not rated yet

Blutdrucktabelle_DinA5

Blutdrucktabelle zum doppelseitigen drucken.Blood-Pressure to print on both sides of paper

04-2024

316

Not rated yet

Der Harbecker

Logo for Der Harbecker

Ein Tabellenblatt zur Kontrolle des Strom- und Gasverbrauchs

04-2024

442

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