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

Tab to protected cells

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


Joined: 30 Oct 2007
Posts: 4
Location: Van Nuys, CA

PostPosted: Mon Jan 21, 2008 7:36 pm    Post subject: Tab to protected cells Reply with quote

It seems that protected cells are not supposed to be accessed through the tab tab key, yet some protected cells, not all, are accessed by the tab. They can not be edited, though I would prefer that only unprotected cells are accessed by the tab key. Any useful thoughts and experience out there.

Thanks,

JJ
_________________
It is a good day to ride!
Back to top
View user's profile Send private message
keme
Moderator
Moderator


Joined: 30 Aug 2004
Posts: 2910
Location: Egersund, Norway

PostPosted: Tue Jan 22, 2008 12:26 am    Post subject: Reply with quote

Never seen that, and cannot duplicate the behaviour.
-What OS and what version of OOo are you using?
-Is your file created in OOo Calc, or is it an imported spreadsheet (e.g. Excel)?
-Can you upload your file to a file sharing site for "public inspection"?
Back to top
View user's profile Send private message
BikeriderJJ
Newbie
Newbie


Joined: 30 Oct 2007
Posts: 4
Location: Van Nuys, CA

PostPosted: Tue Jan 22, 2008 9:30 am    Post subject: Upload a file Reply with quote

Thank you for your interest. I'm new to using this site, where can I upload the file?

JJ
_________________
It is a good day to ride!
Back to top
View user's profile Send private message
keme
Moderator
Moderator


Joined: 30 Aug 2004
Posts: 2910
Location: Egersund, Norway

PostPosted: Tue Jan 22, 2008 9:54 am    Post subject: Reply with quote

This forum doesn't provide any file sharing facility. I haven't much experience with file sharing sites, but I see many people use www.mediafire.com. Enter "free file hosting" in any search engine to get an overview of your options.

It is wise to read the terms of service, usage policy or similar conditions before uploading your file.
Back to top
View user's profile Send private message
BikeriderJJ
Newbie
Newbie


Joined: 30 Oct 2007
Posts: 4
Location: Van Nuys, CA

PostPosted: Tue Jan 22, 2008 10:06 am    Post subject: tab problem Reply with quote

could I e-mail the file directly to you?
_________________
It is a good day to ride!
Back to top
View user's profile Send private message
keme
Moderator
Moderator


Joined: 30 Aug 2004
Posts: 2910
Location: Egersund, Norway

PostPosted: Tue Jan 22, 2008 10:15 am    Post subject: Reply with quote

Uploading to a public site and posting a link will open the problem to all helpers, which is generally a quicker way to reach a solution. Read the PM I sent you if you still want to go private.

Edit: OK! I got your file, and I agree it behaves strangely. Forward tabbing enters some protected cells, but not all. Backward tabbing (shift+tab) skips all protected cells.
  • It seems to occur only on merged cells, but most of your cells are merged one way or other, so that doesn't necessarily mean anything.
  • I tried inspecting the contents of the file at code (xml) level, and cannot find any settings or inconsistencies in the cell definitions or styles that might cause this. I'm no expert at that, though...
  • It looks like this is a bug in Calc.
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