OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Problem red frame appears; not cell format

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
jimmer
Newbie
Newbie


Joined: 29 Apr 2008
Posts: 1

PostPosted: Tue Apr 29, 2008 5:22 am    Post subject: Problem red frame appears; not cell format Reply with quote

Re-posting this to try to get a few more views,

I am using calc with a simple bookeeping template. Out of the blue a red frame has appered on my worksheet which surrounds 1 or more cells, moved=s with the curor keys, limiting movement with cursosrs but not mouse and preventing me entering dat in neighboouring cells.

What is this?!!! It's pissing me right off. it may have come from inaccurate keyboard use i guess but i just want rid of it so i can continue working on my bookeeping and get it finished

thanks, jimmer
Back to top
View user's profile Send private message
PromptJock
Super User
Super User


Joined: 26 Jul 2006
Posts: 741

PostPosted: Tue Apr 29, 2008 11:15 am    Post subject: Reply with quote

Sounds like you're dealing with PROTECTED CELLS that won't allow you to alter them (i.e., "critical" formulae).

You can try turning the cell protection function OFF. Before you do this, MAKE A COPY OF THE SHEET and only work on the COPY, not the original. However, be aware that turning off cell protection could "honk up" the sheet - that's why you need to try these things on COPIES.

Good luck, etc. Smile
_________________
I'm making perfect sense - you're just not keeping up!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group