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.
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