Set a row to follow my cursor anywhere in Calc

Posted by NoCanDo on Super User See other posts from Super User or by NoCanDo
Published on 2009-08-31T11:21:48Z Indexed on 2010/05/20 11:20 UTC
Read the original article Hit count: 253

Filed under:

openoffice.org

|

calc

|

frozen

|

rows

How do I make a whole row follow wherever I am in the Calc document when I scroll down/up?

I'm looking for something that keeps a row from moving, or to make it stay put.

This is so that when I want to see other rows, this one locked row will stay in place and allow me to refer back to it on screen without having to scroll all the way back up to the top of the document.

Normal:

Scrolled down:

Further scrolled down:

You can see the row with the yellow background, (CD-Nr.|Title|Genre|Lang|CD) is following me as I scroll down.

How is this done?

© Super User or respective owner

Related posts about openoffice.org

apt-get is broken

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I Cannot install any package in the server, As I am newbie in Server. In Morning I found that some, I am not able to install any package from command line in the server,Now every package is now manually downloaded packages and then installed in the server. Can any one Please tell me what is the issue… >>> More
Install OpenOffice for headless use

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
The question very simple and short. I am following this article to install OpenOffice headless: sudo apt-get install openoffice.org-headless openoffice.org-writer openoffice.org-draw And I get the following error : Reading package lists... Done Building dependency tree Reading state information… >>> More
Install OOo for headless use

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
The question very simple and short. I am following this article to install OpenOfficle headless: sudo apt-get install openoffice.org-headless openoffice.org-writer openoffice.org-draw And I get the following error : Reading package lists... Done Building dependency tree Reading state information… >>> More
How to recover dpkg from corrupted downloads?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I just upgraded to the 10.10 RC earlier and had a few problems with graphic drivers (x didnt start) But i have remedied that now. When i run 'sudo apt-get install -f' i get this: will@UbuntuBox:/mnt/slax$ sudo apt-get install -f [sudo] password for will: Reading package lists... Done Building dependency… >>> More
Programmatically convert *.odt file to MS Word *.doc file using an OpenOffice.org basic macro

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to build a reStructuredText to MS Word document tool-chain, so I will be able to save only the rst sources in version control. So far I -- Have rst2odt.py to convert reStructuredText to OpenOffice.org Writer format. Next I want to use the most recent OpenOffice.org (currently 3.1) that… >>> More

Related posts about calc

Ubuntu: Convert OpenOffice Calc to Excel workbook using CLI

as seen on Super User - Search for 'Super User'
I need to create an automated report in a spreadsheet format. Unfortunately, There seems to be an easy way to create these reports using OpenOffice Calc, but upper managements wants them in MS Excel format. As these reports are to be created and emailed automatically, is there a nice, command-line… >>> More
Automatically insert Cell References from one Sheet into other Sheet in OOO Calc

as seen on Super User - Search for 'Super User'
I have a spreadsheet in Open Office 3.0 Calc. The spreadsheets consist of the first sheet and an arbitrary number of additional sheets, each collecting data for a specific month. The Month sheets have an identical structure. The first sheet is supposed to provide an overview to the most important… >>> More
Set CSV import default to UTF-8 in Calc

as seen on Super User - Search for 'Super User'
Every time I open a CSV (comma separated values) document in OpenOffice.org Calc I get a dialog with CSV preferences. The current default character set is "Eastern Europe (ISO-8859-2)". I would like "UTF-8" to be selected by default instead. >>> More
Open Office crashes, recovers, crashes again

as seen on Super User - Search for 'Super User'
After completely reinstalling my laptop due to apparent registry corruption, I've encountered a problem with Open Office: I open a simple Calc spreadsheet, it comes up normally, but then after anywhere from 5 seconds to several minutes (without even touching the Calc window) OO crashes, then comes… >>> More
Python regex to parse text file, get the items in list and count the list

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a text file which contains some data. I m particularly interested in finding the count of the number of items in v_dims v_dims pattern in my text file looks like this : v_dims={ "Sales", "Product Family", "Sales Organization", "Region", "Sales Area", "Sales office", "Sales Division", "Sales… >>> More