Am 2011-02-02 23:27, schrieb Franz Waldmüller:
Hi,

I have to tidy up a very huge spreadsheet. In this spreadsheet I have a
lot of cross-sheet references e.g.:
=(sheet_2.A3)
I want to delete sheet which I don't need anymore. But first I have to
check if another sheet needs a cell of the sheet which I want to delete.

Use "Edit -> Search&Replace"
activate advaced options:
Search in Forumlas
Search the sheet name which you want to delete.

Just solved the issue on my own.
Franz


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Reply via email to