| View previous topic :: View next topic |
| Author |
Message |
alexgogan
General User
Joined: 12 Jun 2005
Posts: 12
Location: Dublin
|
 Posted: Sun Jun 12, 2005 10:05 am Post subject: Hidden rows in calc not showing (tried everything) |
 |
|
I opend a document that was created in 1.4 (I think) and now I when I open it in 1.9.1 and try to show the hidden rows it will not. There is data in it and very important stuff too! I tried to hid the two rows top and tail, then show them and this did not work. There is no filters on this document so roving filters is not an option.
Only thing I can think of is exporting as csv then reiporting, but that is a last resort (while I still have that option I still have hope >:¬}) cause there was over a weeks work in that document full financials etc blah blah not a happy person right now.
Thanks in advance |
|
| Back to top |
|
 |
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Sun Jun 12, 2005 11:05 am Post subject: Re: Hidden rows in calc not showing (tried everything) |
|
|
| alexgogan wrote: | | I opend a document that was created in 1.4 (I think) and now I when I open it in 1.9.1 and try to show the hidden rows it will not. |
You didn't say specifically what you did, so try this?
Click the little rectangle to the left of A and above 1 to select the entire sheet. Move the mouse into the column headers, retaining the selection, and Right Mouse ...choose "Show".
David. |
|
| Back to top |
|
|
alexgogan
General User
Joined: 12 Jun 2005
Posts: 12
Location: Dublin
|
| Posted: Sun Jun 12, 2005 12:33 pm Post subject: |
|
|
sorry thought I was clearer.
Tried that, it was the first thing I did.
Thanks |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Sun Jun 12, 2005 7:15 pm Post subject: |
|
|
| alexgogan wrote: | sorry thought I was clearer.
Tried that, it was the first thing I did.
Thanks |
Is the document protected with a password? That kills the option.
David. |
|
| Back to top |
|
|
8daysaweek.co.uk
Super User
Joined: 29 Nov 2003
Posts: 2130
Location: UK
|
| Posted: Sun Jun 12, 2005 11:04 pm Post subject: |
|
|
Hi alexgogan,
A shot in the dark:
The rows haven't been reduced to 0 height have they  
BFN  ,
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site |
|
| Back to top |
|
|
alexgogan
General User
Joined: 12 Jun 2005
Posts: 12
Location: Dublin
|
| Posted: Mon Jun 13, 2005 1:30 am Post subject: |
|
|
| David wrote: |
Is the document protected with a password? That kills the option.
|
Nope  |
|
| Back to top |
|
|
alexgogan
General User
Joined: 12 Jun 2005
Posts: 12
Location: Dublin
|
| Posted: Mon Jun 13, 2005 1:31 am Post subject: |
|
|
| 8daysaweek.co.uk wrote: | Hi alexgogan,
A shot in the dark:
The rows haven't been reduced to 0 height have they
BFN , |
No to that one as well. |
|
| Back to top |
|
|
alexgogan
General User
Joined: 12 Jun 2005
Posts: 12
Location: Dublin
|
| Posted: Mon Jun 13, 2005 1:36 am Post subject: Wheres my gun! |
|
|
Ok I am stupid, just remembered I froze Row's 1-6 (its got the various headers) and the hid rows 7-33 (the workings) to get by nice tidy results page. Now my:idea: eureka moment happened and unfrooze the row and then tried show and bingo!
I feel stupid right now.
Thanks folks for the advices and time taken.
Regards
Alex |
|
| Back to top |
|
|
|
