Power Detective for OpenOffice Calc
Although OpenOffice and LibreOffice are very similar, the macros are not fully compatible. This book describes Power Detective for OpenOffice.
How can I change precedent and dependent arrow colors? (LibreOffice)
In LibreOffice Calc, we can choose the color for the precedent / dependent arrows. In LibreOffice (v5.3), choose Tools/Options/LibreOffice/Application Colors You can select the color for "Detective" colors. "Detective" is the equivalent to Excel's precedent and dependent tracing. Color for Detective Arrows (Precedents and Dependents) Note that LibreOffice changes all Detective arrows, including those that are already drawn, to the new color. It is not possible to get two colors for the arrows in the same screen. However, with Basic programming in LibreOffice, it is possible to trace with different colors in the same sheet (worksheet). This is shown in the following diagram, with the software extension described in this book: Easily understand your spreadsheet model and detect errors with influence charts (For LibreOffice Calc) LibreOffice. Different Precedent Arrow Colors
Hi there,
ReplyDeleteCan't find anywhere to report an unexpected "feature".
If I save a librecalc document as an excel file whilst power detective trace arrows are displayed then the trace becomes a "permanent" graphic feature of that document when re-opened in Calc.
Attempting to erase them has no effect but they can be individually selected and deleted so it's non-destructive - just an interesting feature :). I can be contacted on that.man.colin(at)gmail.com if my description is devoid of sufficient information.
Love the extension and ther's a workaround so the interesting feature is "amusing"
Thank you. The arrows cannot be erased with the original Detective tools. In addition to removal by graphics select/delete, they can be removed with the PowerDetective erase button.
DeleteThat seems to be the feature, If I save it as an xlsx document but inadvertently leave the trace active then I can't reopen it in LOCalc and erase the arrows with the PowerDetective erase button, they can only be removed by individually selecting and deleting them - or selecting the array and copying it to a new sheet and discarding the first sheet. I wouldn't know what to expect in Excel because they're produced from the LO extension and Excel obviously does its own trace but I was surprised that the arrows were embedded graphics when I reopened the xlsx file in LOCalc. It's clearly an obscure feature because the number of people who forgetfully export an active trace to xlsx must be fairly limited - in fact I'm probably the only muppet capable of such folly. However, I did discover that the LO Foundation does accept "issue" reports for supported extensions and filed it with them. They may well seek expert guidance from yourself - or assume it's such an obscure issue that it goes on the "back burner" until a second report manifests itself!
DeleteDoes it let find the trace to precedents in other sheets?
ReplyDeleteIt provides a diamond symbol to indicate the trace goes to another sheet but doesn't automatically link to that cell and extend the trace. Viewing the formula in the cell being traced provides the "target" which can again be traced.
Delete