[Solved] Open spreadsheet at last edit location

[Hagar Delest]

How do i open a sheet where i left off (its doing my head in now)

Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply (robleyd, Moderator).

[RoryOF]

Try entering your name etc in OpenOffice /Tools/ Options /OpenOffice /User Data. Then restart OpenOffice. this will certainly allow a Writer file to open at the last location; I cannot say for certain with Calc, but it is worth trying.

[sutty68]

Massive thanks to both RoryOF and robleyd for your help

[Hagar Delest]

Note that it works only with native ODF (.ods).

[Villeroy]

I just tried with my copy of AOO 4.1.7 which has no user data. It always remembers the position of the cell cursor (active cell).