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

Hidden rows in calc not showing (tried everything)

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


Joined: 12 Jun 2005
Posts: 12
Location: Dublin

PostPosted: Sun Jun 12, 2005 10:05 am    Post subject: Hidden rows in calc not showing (tried everything) Reply with quote

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
View user's profile Send private message Visit poster's website
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Sun Jun 12, 2005 11:05 am    Post subject: Re: Hidden rows in calc not showing (tried everything) Reply with quote

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
View user's profile Send private message
alexgogan
General User
General User


Joined: 12 Jun 2005
Posts: 12
Location: Dublin

PostPosted: Sun Jun 12, 2005 12:33 pm    Post subject: Reply with quote

sorry thought I was clearer.

Tried that, it was the first thing I did.

Thanks
Back to top
View user's profile Send private message Visit poster's website
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Sun Jun 12, 2005 7:15 pm    Post subject: Reply with quote

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
View user's profile Send private message
8daysaweek.co.uk
Super User
Super User


Joined: 29 Nov 2003
Posts: 2130
Location: UK

PostPosted: Sun Jun 12, 2005 11:04 pm    Post subject: Reply with quote

Hi alexgogan,

A shot in the dark:

The rows haven't been reduced to 0 height have they Question Shocked

BFN Smile,
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site
Back to top
View user's profile Send private message Visit poster's website AIM Address
alexgogan
General User
General User


Joined: 12 Jun 2005
Posts: 12
Location: Dublin

PostPosted: Mon Jun 13, 2005 1:30 am    Post subject: Reply with quote

David wrote:

Is the document protected with a password? That kills the option.


Nope Sad
Back to top
View user's profile Send private message Visit poster's website
alexgogan
General User
General User


Joined: 12 Jun 2005
Posts: 12
Location: Dublin

PostPosted: Mon Jun 13, 2005 1:31 am    Post subject: Reply with quote

8daysaweek.co.uk wrote:
Hi alexgogan,
A shot in the dark:
The rows haven't been reduced to 0 height have they Question Shocked
BFN Smile,

No to that one as well.
Back to top
View user's profile Send private message Visit poster's website
alexgogan
General User
General User


Joined: 12 Jun 2005
Posts: 12
Location: Dublin

PostPosted: Mon Jun 13, 2005 1:36 am    Post subject: Wheres my gun! Reply with quote

Ok Shocked 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
View user's profile Send private message Visit poster's website
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