LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 03-25-2008, 09:17 PM   #1
zymos
Member
 
Registered: Mar 2005
Posts: 38

Rep: Reputation: 15
making a row always on top in an openoffice spreadsheet (oocalc)


I want to have the first row of a spreadsheet to remain ontop (visible) even when scrolling down

I found an example of it, but can't figure out how its done, I don't even know what the feature is called

Example:
http://studioequis.com/weighttracker...ht_tracker.ods

Thanks
Jeff
Wiki howto
 
Old 03-25-2008, 09:51 PM   #2
bigrigdriver
LQ Addict
 
Registered: Jul 2002
Location: East Centra Illinois, USA
Distribution: Debian Squeeze
Posts: 5,739

Rep: Reputation: 298Reputation: 298Reputation: 298
In the oocalc help files, look up rows, freezing.
 
Old 03-25-2008, 10:09 PM   #3
zymos
Member
 
Registered: Mar 2005
Posts: 38

Original Poster
Rep: Reputation: 15
thanks, i didn't know it was called freezing

this is from the help file for anyone else who is interested

Freezing Rows or Columns as Headers
If you have long rows or columns of data that extend beyond the viewable area of the spreadsheet, you can freeze them, which allows you to see the columns or rows as you scroll through the rest of the data.

Steps
1.Select the row below, or the column to the right of the row or column that you want to be in the frozen region. All rows above, or all columns to the left of the selection are frozen.
To freeze both horizontally and vertically, select the cell that is below the row and to the right of the column that you want to freeze.
2.Choose Window - Freeze.
To deactivate, choose Window - Freeze again.

notes
note 1: If the area defined is to be scrollable, apply the Window - Split command.
note 2: If you want to print a certain row on all pages of a document, choose Format - Print ranges - Edit.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
why openoffice (spreadsheet) has no save as simple TXT ? Xeratul Linux - Software 5 05-29-2007 05:34 PM
Making a row being Fixed in JTable MRMadhav Programming 1 03-23-2006 09:06 PM
split pasted data in openoffice spreadsheet? hedpe Linux - Software 2 01-10-2006 07:55 AM
graph repeated row values in openoffice calc jwstric2 Linux - Software 1 07-22-2004 04:23 AM
openoffice spreadsheet and image keevitaja Linux - Software 1 11-21-2002 03:08 AM


All times are GMT -5. The time now is 12:18 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration