Difference between revisions of "Documentation/DevGuide/Spreadsheets/Detective"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (1 revision(s))
m (Robot: Changing Category:Spreadsheet Documents)
Line 32: Line 32:
  
 
{{PDL1}}
 
{{PDL1}}
[[Category: Spreadsheet Documents]]
+
 
 +
[[Category:Documentation/Developers Guide/Spreadsheet Documents]]

Revision as of 09:47, 4 June 2008



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