| View previous topic :: View next topic |
| Author |
Message |
john.egger
Power User
Joined: 19 Apr 2003
Posts: 71
|
 Posted: Sun Oct 15, 2006 2:14 pm Post subject: Gray vertical strip at left |
 |
|
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
Klikit Linux 0.2-RC3 |
|
| Back to top |
|
 |
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
| Posted: Sun Oct 15, 2006 5:28 pm Post subject: |
|
|
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 |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Sun Oct 15, 2006 6:14 pm Post subject: Re: Gray vertical strip at left |
|
|
| 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 |
|
|
davel
Power User
Joined: 18 Oct 2005
Posts: 62
Location: PA, USA
|
| Posted: Sun Oct 15, 2006 6:53 pm Post subject: |
|
|
| Sounds like a data group display. Try Data/Outline / ungroup. |
|
| Back to top |
|
|
john.egger
Power User
Joined: 19 Apr 2003
Posts: 71
|
| Posted: Tue Oct 17, 2006 2:22 pm Post subject: |
|
|
| 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
Klikit Linux 0.2-RC3 |
|
| Back to top |
|
|
Dale
Super User
Joined: 21 Feb 2005
Posts: 1440
Location: Australia
|
| Posted: Tue Oct 17, 2006 2:50 pm Post subject: |
|
|
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 |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Tue Oct 17, 2006 2:54 pm Post subject: |
|
|
| 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 |
|
|
john.egger
Power User
Joined: 19 Apr 2003
Posts: 71
|
| Posted: Tue Oct 17, 2006 3:32 pm Post subject: |
|
|
| Dale wrote: | 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
Klikit Linux 0.2-RC3 |
|
| Back to top |
|
|
Dale
Super User
Joined: 21 Feb 2005
Posts: 1440
Location: Australia
|
| Posted: Tue Oct 17, 2006 6:45 pm Post subject: |
|
|
| 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. |
 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 |
|
|
|
