How to add the current page number in a cell of a calc sheet

Question

I would like to add the current page number in a cell of that page and to refer back this cell for this page number in a cell somewhere in the same sheet / in another sheet. Is there a way to do so?

Answer 1

AFAIK this isn't possible - see this FAQ on OpenOffice.org: Fields are only available in Header/Footer. There are Spreadsheet functions, you they don't offer a function to access the "Page" value, only the number of the current SHEET.