[Solved] Open spreadsheet at last edit location

Discuss the spreadsheet application
Post Reply
sutty68
Posts: 10
Joined: Wed Apr 03, 2019 3:00 pm

[Solved] Open spreadsheet at last edit location

Post by sutty68 »

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

Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply (robleyd, Moderator).
Last edited by Hagar Delest on Tue Jun 02, 2020 4:29 pm, edited 2 times in total.
Reason: tagged solved
OpenOffice 4-1-6
User avatar
RoryOF
Moderator
Posts: 35064
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: HELP !!!

Post by 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.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.5 LTS
sutty68
Posts: 10
Joined: Wed Apr 03, 2019 3:00 pm

Re: Open spreadsheet at last edit location

Post by sutty68 »

Massive thanks to both RoryOF and robleyd for your help :D
OpenOffice 4-1-6
User avatar
Hagar Delest
Moderator
Posts: 33385
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: [Solved] Open spreadsheet at last edit location

Post by Hagar Delest »

Note that it works only with native ODF (.ods).
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE Faye) and 24.8 portable on Windows 11.
User avatar
Villeroy
Volunteer
Posts: 31345
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] Open spreadsheet at last edit location

Post by 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).
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply