calc won't save where the cursor is displayed

asked 2019-08-22 13:47:26 +0200

WallyTek gravatar image

I have version 6.3.0.4 64-bit and the strangest thing has happened. The calc processor won't open a file at the place I last left the cursor. For instance, I make changes to various fields and position the curson to B73 which shows on the screen. In the past, calc would open the file displaying the page that containsthe cursor at B73. Now it opens the page where it closed it many, many times ago. I hope I have made this clear. I've probably inadvertantly made a change somewhere but for the life of me I can't see where. Any help would be greatly appreciated.

edit retag flag offensive close merge delete

Comments

This sounds like some corruption in your file, since the CursorPostionX and CursorPostionY are stored for each table within XML file settings.xml, which is part of the .ods zip archive. Thus from my perspective this got nothing to do with LibreOffice version 6.3.0.4 (it works on my system. which also uses 6.3.0.4)

Opaque gravatar imageOpaque ( 2019-08-22 15:48:37 +0200 )edit

Thanks for you reply. It happens to ALL my files. And my files are in .xlxs format if that helps.

WallyTek gravatar imageWallyTek ( 2019-08-22 15:58:08 +0200 )edit

I assumed you are using alien formats and this is against all recommendations. If you are interested in the reasoning, you may read this article (though it is about Writer, Word, .odt and .docx, most of the content also applies to Calc, Excel and their respective formats).

Summarizing: The working/master format for LibreOffice applications is ODF. The rest is for document exchange with others, not being able ro read ODF. Just turn it other way round: Who would ever work with Excel using .ods files?

But anyway you may file a bug for the .xlsx filters at Bugzilla.

Opaque gravatar imageOpaque ( 2019-08-22 16:08:25 +0200 )edit

I've blown away ALL of 6.3.0.4 and reinstalled 6.2.5.2 and the problem has gone away. Guess I'll let them know at Bugzilla. Thanks for your help, though.

WallyTek gravatar imageWallyTek ( 2019-08-22 19:04:42 +0200 )edit