[Solved] Adding to Spreadsheet Problems

Discuss the spreadsheet application

[Solved] Adding to Spreadsheet Problems

Postby forist » Tue Jan 14, 2020 7:25 pm

Every time I attempt to add numbers into the black box on my spreadsheet, the box moves to another area of the sheet and NO numbers appear. How can I fix this?
Last edited by robleyd on Wed Jan 15, 2020 3:14 am, edited 1 time in total.
Reason: Tagged [Solved]
Windows 10
Open Office 4.1.7
forist
 
Posts: 2
Joined: Tue Jan 14, 2020 7:21 pm

Re: Adding to Spreadsheet Problems

Postby RusselB » Tue Jan 14, 2020 11:32 pm

Welcome to the Forums.
What black box are you referring to? When entering data into a spreadsheet cell, the active cell is highlighted with a black border. Is this what you mean by black box?
If it is, then that should only move after you press the Enter key to finish entering the data. When the Enter key is used, the cell indicator can do one of three things: Not move, move one row down, or move one column to the right. Which of these is set/controlled through Data -> Options
If you are referring to something else, then we need to see a sample of you file. Please see How to attach a document
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5787
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Adding to Spreadsheet Problems

Postby forist » Wed Jan 15, 2020 2:06 am

I solved the problem. I had forgotten to press the "number lock" key on my new Windows 10 Keyboard. Silly me.

Thanks for the attempt to help my un-tech savy mind.
Windows 10
Open Office 4.1.7
forist
 
Posts: 2
Joined: Tue Jan 14, 2020 7:21 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 7 guests