Fixing Open Office Won’t Accept Imput

I opened an OpenOffice spreadsheet document only to find that when I typed a number into the document, the cursor would only jump to another cell several cells away horizontally. I was not able to enter any data. So I updated to Open Office 4.1.7 which I am glad I did. But it did the same thing. After several attempts, I figured out that in order for it to work properly the num lock on the numbers keyboard had to be in the locked position. Now it works fine.