MadModder
The Shop => Software Tools => Topic started by: DavidA on April 05, 2016, 11:56:33 AM
-
Maybe some one can help with this one.
I use Open Office. And at the moment am constructing a spreadsheet that will be 367 columns wide.
Now. The problem is I need to be able to see column A at all times.
But I can only display columns A to K at a comfortable resolution.
To enter or see more columns I have to shift the columns to the left. I.e out of site. The problem with that is that I then lose sight of Column A.
The question becomes, how do I 'hide' columns B to K so that the display shows A,L,M....etc.
Or how do I define the columns that are to be displayed ?
Hope someone knows how to do this.
Dave.
-
If it is like Excel which it emulates, highlight column B, go to the view menu, click 'freeze panes'
(info supplied by text from my daughter who is an Excel expert, and 100 miles away !!!!! )
-
Andrew,
Nothing similar in the Open Office 'view' window.
Dave
-
Dave
Another hint from the MS offering
Highlight the required columns to be hidden. Right mouse click inside the highlighted bit, select HIDE from the drop down menu, and they disappear.
HTH
Pete
-
A quick google reveals this:
https://wiki.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Getting_Started/Freezing_rows_and_columns
and:
https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=22703
-
Repete column A at L copy and paste just have some extra columns .
-
Jeff,
Can't do that.
I need to form charts using the horizontal row data. The additional column would get in the way.
Dave.
-
Andrew,
That's the way to do it. :thumbup:
Just what I needed to know.
Many thanks to yourself and the others who offered advise.
Now all I have to do is transfer the data to the spreadsheet.
Dave.
-
Select columns A and B then go to the menu Window and click Freeze.
Hope it help :thumbup:
-
Now all I have to do is transfer the data to the spreadsheet.
Dave,
What format is the data currently in? If you can, with a bit of judicious "Search & Replace" get it into comma or semi-colon separated text, it can be imported into a spreadsheet with little effort.
If you need some guidance on importing data into the spreadsheet, just give a holler.
-Josh
-
Josh, j1312v,
Thanks, I'm sorted out now. Just pages of files to transfer. Steady job.
One of my many (too many) projects is the building of a dedicated temperature logger that will record maybe 25 channels continuously, dumping the data onto bulk storage every week or so.
The current simple system is a ThermaData two channel logger. One channel (the body) records the temperature inside my green house, and the other channel (the probe) sticks out and records the outside air temp'.
Guess I'm a bit obsessed with knowing how warm/cold it is.
Dave.
-
Pick the first cell in column a and b the click window and click freeze.
-
George,
Thanks, I've managed to get it sorted out.
Dave.