Spreadsheet Glitch?

asked 2020-08-30 16:59:27 +0100

Dendad gravatar image

updated 2020-09-02 19:11:03 +0100

I've been using a check register spreadsheet for many years. All of a sudden, LibreOffice won't let me use the arrow key to enter data and move to the next column. This is only in column "C" and it doesn't happen every time. It seems it will work about 8 times, then the next two times it stops working. I have to click on the cell to get the entered data to fill the cell. I hope this makes sense. Thanks.

More info:

I have O/S El Capitan 10.11.6

I'm pressing right arrow after entering my numerical data, using my keyboard. In some cells, it enters the data as it's supposed to and moves to the next cell. But, as I explained earlier, this only happens once in a while. I'll enter my data just fine using the right arrow for about 8 times, and then the next two times it doesn't work. I'm just keying in numerical data. No cutting, pasting or using the formula bar. I realize I may need to download a newer version of LO, but since it was working fine, I didn't want to risk messing up my spreadsheet. It's very important information. Apple says my iMac is too old to get a newer O/S. Thanks.

Leroy, I'm totally using my keyboard. I enter the numbers using the number keys on my keyboard. When the arrow key doesn't enter the info and move to the next cell like it's supposed to, I then have to use my mouse to move to the next cell.

edit retag flag offensive close merge delete


You should specify your version of LO and the operating system.

Vanadium gravatar imageVanadium ( 2020-08-30 17:44:42 +0100 )edit


When this happen, if do you press left arrow and/or right arrow, it moves the cursor within the cell? How are you entering data? Pasting, editing, using the Imput Line (aka formula bar)?

Add Answer is reserved for solutions.

Press edit below your question to add more information.

LeroyG gravatar imageLeroyG ( 2020-08-30 21:40:41 +0100 )edit

Thanks for the new info. Are you only using the keyboard when this happen? Or are you using touchpad or mouse to change from one cell to other?

LeroyG gravatar imageLeroyG ( 2020-09-02 19:00:52 +0100 )edit

May be an issue with your user profile. Take a look at https://wiki.documentfoundation.org/U...

LeroyG gravatar imageLeroyG ( 2020-09-02 19:23:37 +0100 )edit

Not F2 key accidentaly involved in the proccess?

LeroyG gravatar imageLeroyG ( 2020-09-02 20:41:39 +0100 )edit

No F2 involvement. I’ll check out the link you sent.

Dendad gravatar imageDendad ( 2020-09-02 21:55:00 +0100 )edit

I took a look at the profile link. I don’t think that’s my problem since the arrow key works 80% of the time. There’s no way I’m going to risk damaging my current LO and my important spreadsheet by re-installing anything.

Dendad gravatar imageDendad ( 2020-09-03 02:13:42 +0100 )edit

Give a try to 'Safe Mode'. This will ignore your user profile until you restart LibreOffice.

By the way, your spreadsheet wouldn't be damaged by re-installing LibreOffice.

LeroyG gravatar imageLeroyG ( 2020-09-03 20:27:32 +0100 )edit

Okay, thanks for being so patient with me. Much appreciated.

Dendad gravatar imageDendad ( 2020-09-03 20:35:49 +0100 )edit