Who is the odd man out? (LibreOffice Calc)

In the previous posts, we see how we can use Excel to identify a cell with an inconsistent formula compared to its neighbors.

The aim is to identify potential errors, or inconsistent designs.

For LibreOffice Calc users, similar methods are available, as listed in the following table.

Method
Excel
LibreOffice Calc
Show Formula
Yes
Yes
Show R1C1 Formula
Yes (Check Options)
Yes (Check Options)
Formula Error Flag
Yes (Check Options)
-
Row / Column Differences
Yes (Find and Select / Go To Special)
- (There is a similar function, but it needs a macro program.)
Precedent Arrows


   Single-cell Precedents
Yes (Formula Auditing / Trace Precedents)
Yes (Detective / Trace Precedents)
   Multiple-cell Precedents
Need a macro (e.g. VisualCheck or Power Formula Auditing)
Need a macro (e.g., VisualCheck for LibreOffice or Power Detective)


LibreOffice Calc users can use the following Calc extensions.

VisualCheck is a LibreOffice Calc extension (add-in) and is available and described in this book: Easily understand your spreadsheet model and detect errors with influence charts (For LibreOffice Calc) 

Power Detective  is a LibreOffice Calc extension (add-in) and is available and described in this book: Power Detective: Easily trace Precedents and Dependents for many Cells (For LibreOffice Calc) 

Comments

Post a Comment

Popular posts from this blog

I want to trace precedents in Google Sheets

I want to trace precedents in Google Sheets. It is not possible to do that in Google Sheets. The closest way is to open the file with Excel or LibreOffice Calc. But there are compatibility problems with special formulas and macros. (Update: Please see the comments for this post)
Read more

LibreOffice Calc Users have Powerful Precedent Tracing Tools

LibreOffice Calc has a Detective menu to trace precedents and dependents. Similar to Excel's formula auditing tools, the tracings are limited to one cell at a time, and each click goes one level further. This new book,  Easily understand your spreadsheet model and detect errors with influence charts (For LibreOffice Calc), improves the detective tracing ability with LibreOffice Basic programming. Calc users can now trace precedents and dependents over many cells, or many levels at once. There are more functions described in the book. This unique spreadsheet book shows you how you can quickly and easily gain an overview of your spreadsheet model, with just a few clicks. The automatically generated overview, with the specialized software (VisualCheck, tested with LibreOffice 5.3) that comes with the book, allows easy understanding and error detection, as illustrated in the book. This book is meant for all types of spreadsheet users. It is meant for both novice and exp...
Read more