Why has my small spreadsheet maxed out to maximum with empty cells

asked 2020-11-26 07:29:19 +0100

stub gravatar image

updated 2020-11-26 09:01:35 +0100

This seems to be in Libre Office itself. It started when I was trying to do a sort but kept getting the points wrong on the sort and after about 4 trys, the spreadsheet maxed out to cell AMJ3273, with mostly 99% empty cells. I closed all my work. Rebooted. But still when I load a spreadsheet, even one I didn't previously had open, is the same it goes to AMJ3273 with no way to get to A1. Which is why I think it's some setting in Libre Office.

I can see my spreadsheet if I search for the letter "a", but immediately it moves the cursor to the far right of the spreadsheet. Which is how it loads from scratch. How to get rid of these thousands upon thousands of empty cells, so I can see and work on my spreadsheets once again.

I think this might not even be LibreOffice related. I get the same kind of thing happening in Windows 10 File Explorer

rgds stu

edit retag flag offensive close merge delete

Comments

I can see my spreadsheet if I search for the letter "a", but immediately it moves the cursor to the far right of the spreadsheet. Which is how it loads from scratch. How to get rid of these thousands upon thousands of empty cells, so I can see and work on my spreadsheets once again.

stub gravatar imagestub ( 2020-11-26 07:52:52 +0100 )edit

Ctrl + Home will normally take you to cell A1.

Similarly, Ctrl + End will take you to the furthest (right and down) cell that contains data.

robleyd gravatar imagerobleyd ( 2020-11-26 08:09:31 +0100 )edit

This is not a solution to your question, so doesn't belong in an answer; please click on the More link at the bottom and move it as a comment.

robleyd gravatar imagerobleyd ( 2020-11-26 08:10:50 +0100 )edit

Please test with a clean profile Menu/Help/Restart in Safe Mode

m.a.riosv gravatar imagem.a.riosv ( 2020-11-26 10:42:53 +0100 )edit