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

Gray vertical strip at left

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
john.egger
Power User
Power User


Joined: 19 Apr 2003
Posts: 72

PostPosted: Sun Oct 15, 2006 2:14 pm    Post subject: Gray vertical strip at left Reply with quote

One of my StarOffice 8/Linux spreadsheets, after suffering some electrical noise here, has sprouted a vertical gray strip on the left, with small boxes at the top numbered 1 through 5. Adjacent to certain rows are some kind of tabs, and clicking on them hides (rather than deletes, as I originally thought) the row. The sheet-scroll arrows are at the bottom of this vertical panel.

What is it, and how do I get rid of it? I would have searched for this topic and did look in "Help," but I don't know what it's called and have never seen it before.
_________________
--John
Registered Linux User #291592
Kubuntu Raring Ringtail (13.04)
Back to top
View user's profile Send private message
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3318

PostPosted: Sun Oct 15, 2006 5:28 pm    Post subject: Reply with quote

Could you perhaps post a screenshot to somewhere like http://imageshack.us/ and paste it here using the Img button?

EDIT: I meant to add (David reminded me) that you could import the file into a new document using Insert >Sheet from file.
_________________
search forum by month


Last edited by noranthon on Sun Oct 15, 2006 6:32 pm; edited 1 time in total
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Sun Oct 15, 2006 6:14 pm    Post subject: Re: Gray vertical strip at left Reply with quote

john.egger wrote:
One of my StarOffice 8/Linux spreadsheets, after suffering some electrical noise here


Lightning? Power surge? ...If so, then the file could be messed up. If no further options are found, I'd simply redo, and save time in the long run. It would be interesting to see what you are seeing if you could upload the file as suggested by noranthon.

David.
Back to top
View user's profile Send private message
davel
Power User
Power User


Joined: 18 Oct 2005
Posts: 62
Location: PA, USA

PostPosted: Sun Oct 15, 2006 6:53 pm    Post subject: Reply with quote

Sounds like a data group display. Try Data/Outline / ungroup.
Back to top
View user's profile Send private message
john.egger
Power User
Power User


Joined: 19 Apr 2003
Posts: 72

PostPosted: Tue Oct 17, 2006 2:22 pm    Post subject: Reply with quote

noranthon wrote:
Could you perhaps post a screenshot to somewhere like http://imageshack.us/ and paste it here using the Img button?

EDIT: I meant to add (David reminded me) that you could import the file into a new document using Insert >Sheet from file.


Well, let's see if this works. I've never tried posting an image before.

http://img265.imageshack.us/my.php?image=so8calcze9.png

This is part of a ham radio log, and for some reason my radio signal (on certain frequencies, at my full transmitter power) was interfering with my computer: switching screens, opening menus, adding nonsense entries, etc. Cranking the power down stopped that, but I never have figured out how to get rid of this gray strip!

PS: the Data/Outline/Ungroup is already grayed out.
_________________
--John
Registered Linux User #291592
Kubuntu Raring Ringtail (13.04)
Back to top
View user's profile Send private message
Dale
Super User
Super User


Joined: 21 Feb 2005
Posts: 1440
Location: Australia

PostPosted: Tue Oct 17, 2006 2:50 pm    Post subject: Reply with quote

john.egger wrote:
Well, let's see if this works. I've never tried posting an image before.

http://img265.imageshack.us/my.php?image=so8calcze9.png
It certainly looks like a data group. But
Quote:
PS: the Data/Outline/Ungroup is already grayed out.
If you haven't already, try Data > Outline > Group and then Data > Outline > Ungroup.

Other than that it sounds like RFI has trashed your file. Try selecting the entire sheet, copy & paste as unformatted text into a new sheet.
_________________
Dale
To err is human, but to destroy your slippers in the process takes a real son of a bitch: Me!

OOo documentation from the source
http://documentation.openoffice.org
Guides, FAQ, How Tos
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Tue Oct 17, 2006 2:54 pm    Post subject: Reply with quote

john.egger wrote:


Well, let's see if this works. I've never tried posting an image before.



Any chance you could post the file itself? If so, you might try dropfiles.net, but those !#@$ ads will still likely be invasive[**]. Or, perhaps take the file elsewhere and see if it is the file and not your setup.

[**] EDIT ...to say nothing of those REALLY annoying behind the scenes pop-ups for poker that I thought I'd seen the last of!!!!

P.S. Can you cover the computer with some sort of screening to block out radio frequencies? Usually the problem is the other way around as the computer interferes with radio frequencies.

David.
Back to top
View user's profile Send private message
john.egger
Power User
Power User


Joined: 19 Apr 2003
Posts: 72

PostPosted: Tue Oct 17, 2006 3:32 pm    Post subject: Reply with quote

Dale wrote:
john.egger wrote:
Well, let's see if this works. I've never tried posting an image before.

http://img265.imageshack.us/my.php?image=so8calcze9.png
It certainly looks like a data group. But
Quote:
PS: the Data/Outline/Ungroup is already grayed out.
If you haven't already, try Data > Outline > Group and then Data > Outline > Ungroup.

Other than that it sounds like RFI has trashed your file. Try selecting the entire sheet, copy & paste as unformatted text into a new sheet.


Well! I was about to try the Group/Ungroup suggestion, Dale, when I noticed a "Remove" option at the bottom of that dropdown menu. I tried that, and the gray strip disappeared.

Thanks all for the help!

On the RFI, I used to have this problem when using the 21MHz band but this was 3.5 MHz where I'd never had interference with the computer before. (It's right beside the amateur radio transmitter.) I'll try better coax and maybe get a better antenna tuner. That power should be going to my antenna, not into the air here in the basement!
_________________
--John
Registered Linux User #291592
Kubuntu Raring Ringtail (13.04)
Back to top
View user's profile Send private message
Dale
Super User
Super User


Joined: 21 Feb 2005
Posts: 1440
Location: Australia

PostPosted: Tue Oct 17, 2006 6:45 pm    Post subject: Reply with quote

john.egger wrote:
Well! I was about to try the Group/Ungroup suggestion, Dale, when I noticed a "Remove" option at the bottom of that dropdown menu.
Embarassed I didn't
Quote:
I tried that, and the gray strip disappeared
I'm glad it's fixed. Thanks for the feedback - I learned something new.
_________________
Dale
To err is human, but to destroy your slippers in the process takes a real son of a bitch: Me!

OOo documentation from the source
http://documentation.openoffice.org
Guides, FAQ, How Tos
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