Language Asturianu (ast) Català (ca) Čeština (cs) Dansk (da) Deutsch (de) English [US] (en-US) Español (es) Esperanto (eo) Eesti keel (et) Euskara (eu) Français (fr) Gàidhlig (gd) Galego (gl) Italiano (it) Lietuvių (lt) Magyar (hu) Nederlands (nl) Norsk (no) Polski (pl) Português [do Brasil] (pt-BR) Português [Europeu] (pt) Română (ro) Slovenčina (sk) Slovenščina (sl) Suomi (fi) Svenska (sv) Yкраїнська (uk) Tiếng Việt (vi) Türkçe (tr) ኦሮሚኛ (om) Հայերեն (hy) Ελληνικά (el) български език (bg) Русский (ru) Cрпски [ћирилицом] (sr) עברית (he) हिन्दी (hi) ភាសាខ្មែរ (km) தமிழ் (ta) ภาษาไทย (th) 简体中文 (zh-CN) 正體中文 (zh-TW) 日本語 (ja) 한국어 (ko)

The Free and Open Productivity Suite

• Product
• Download
• Support
• Blog
• Extensions & Templates
• Get Involved
• Focus Areas
• Native Languages

home » api » docs » common » ref » com » sun » star » sheet

Overview

Module

Use

Devguide

Index

Methods' Summary

Attributes' Summary

Methods' Details

Attributes' Details

---

:: com :: sun :: star :: sheet ::

interface XSheetAuditing

Description provides methods to access auditing (detective) features in a spreadsheet. Developers Guide Spreadsheets - Detective

---

Methods' Summary
hideDependents	removes arrows for one level of dependents of a formula cell.
hidePrecedents	removes arrows for one level of precedents of a formula cell.
showDependents	draws arrows between a formula cell and its dependents.
showPrecedents	draws arrows between a formula cell and its precedents.
showErrors	draws arrows between a formula cell containing an error and the cells causing the error.
showInvalid	marks all cells containing invalid values.
clearArrows	removes all auditing arrows from the spreadsheet.

Methods' Details

hideDependents boolean hideDependents( [in] ::com::sun::star::table::CellAddress  aPosition ); Description removes arrows for one level of dependents of a formula cell. If the method is executed again for the same cell, the previous level of dependent cells is removed. Parameter aPosition the address of the formula cell.

hidePrecedents boolean hidePrecedents( [in] ::com::sun::star::table::CellAddress  aPosition ); Description removes arrows for one level of precedents of a formula cell. If the method is executed again for the same cell, the previous level of dependent cells is removed. Parameter aPosition the address of the formula cell.

showDependents boolean showDependents( [in] ::com::sun::star::table::CellAddress  aPosition ); Description draws arrows between a formula cell and its dependents. If the method is executed again for the same cell, the next level of dependent cells is marked. Parameter aPosition the address of the formula cell.

showPrecedents boolean showPrecedents( [in] ::com::sun::star::table::CellAddress  aPosition ); Description draws arrows between a formula cell and its precedents. If the method is executed again for the same cell, the next level of dependent cells is marked. Parameter aPosition the address of the formula cell.

showErrors boolean showErrors( [in] ::com::sun::star::table::CellAddress  aPosition ); Description draws arrows between a formula cell containing an error and the cells causing the error.

showInvalid boolean showInvalid(); Description marks all cells containing invalid values.

clearArrows void clearArrows(); Description removes all auditing arrows from the spreadsheet.

Top of Page

---

Copyright © 2013, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.