doublehp
General User
Joined: 08 Jan 2008
Posts: 9
|
 Posted: Wed Jan 09, 2008 10:33 pm Post subject: how to persistant colums names/headers/labels ? [Solved] |
 |
|
I have a Calc sheet. I have 22 cols, and hundreds of rows. The first line is a "reserved" line; the second contains col labels/headers.
Is there a way to make those two lines visually persistant when I scroll down ? I know it's possible to have persistant col names in a traditionnal table over pages in the writer.
Laternatively, can I visually rename/bins-name the column names ? I mean, that D7 will always be D7, but, in the interface, get D col renamed ... FooBar ...
Same question in the other way: get one or two colums persistant on the left when I scroll right 
It's ok to get persistant only the "first" rows and cols. I would like not to use the "hide" feature, because my sheet I hse integrated filtering functions, and, as soon as I will use it, it makes immediately hidden rows visible. Hide is not possible either on colums, for complex reasons to explain ...
Last edited by doublehp on Wed Jan 09, 2008 11:40 pm; edited 1 time in total |
|
Sliderule
Super User
Joined: 29 May 2004
Posts: 2474
Location: 3rd Rock From The Sun
|
| Posted: Wed Jan 09, 2008 11:23 pm Post subject: |
|
|
doublehp:
You asked: | doublehp wrote: | Is there a way to make those two lines visually persistant when I scroll down ? I know it's possible to have persistant col names in a traditionnal table over pages in the writer.
Same question in the other way: get one or two colums persistant on the left when I scroll right |
The answer is, yes to both questions. Please see the post below.
http://www.oooforum.org/forum/viewtopic.phtml?t=44684
I hope this helps, please be sure to let me / us know.
Sliderule
Thanks to add [Solved] in your first post title (edit button) if your issue has been fixed / resolved. |
|
