Detective

From Apache OpenOffice Wiki
Jump to: navigation, search



The spreadsheet interface com.sun.star.sheet.XSheetAuditing supports the detective functionality of the spreadsheet.

Methods of com.sun.star.sheet.XSheetAuditing
hideDependents()

hidePrecedents()

Hides the last arrows to dependent or precedent cells of a formula cell. Repeated calls of the methods shrink the chains of arrows.
showDependents()

showPrecedents()

Adds arrows to the next dependent or precedent cells of a formula cell. Repeated calls of the methods extend the chains of arrows.
showErrors() Inserts arrows to all cells that cause an error in the specified cell.
showInvalid() Marks all cells that contain invalid values.
clearArrows() Removes all auditing arrows from the spreadsheet.
Content on this page is licensed under the Public Documentation License (PDL).
Personal tools
In other languages