MadModder

The Shop => Software Tools => Topic started by: DavidA on April 05, 2016, 11:56:33 AM

Title: Open Office.
Post 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.
Title: Re: Open Office.
Post by: awemawson on April 05, 2016, 12:34:23 PM
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 !!!!! )
Title: Re: Open Office.
Post by: DavidA on April 05, 2016, 12:57:03 PM
Andrew,

Nothing similar in the Open Office 'view' window.

Dave
Title: Re: Open Office.
Post by: Spurry on April 05, 2016, 01:30:27 PM
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
Title: Re: Open Office.
Post by: awemawson on April 05, 2016, 01:42:25 PM
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

Title: Re: Open Office.
Post by: chipenter on April 05, 2016, 01:46:26 PM
Repete column A at L copy and paste just have some extra columns .
Title: Re: Open Office.
Post by: DavidA on April 05, 2016, 02:41:46 PM
Jeff,

Can't do that.

I need to form charts using the horizontal row data. The additional column would get in the way.

Dave.
Title: Re: Open Office.
Post by: DavidA on April 05, 2016, 02:51:07 PM
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.
Title: Re: Open Office.
Post by: j1312v on April 05, 2016, 03:00:10 PM
Select columns A and B then go to the menu Window and click Freeze.

Hope it help  :thumbup:
Title: Re: Open Office.
Post by: joshagrady on April 07, 2016, 05:51:48 AM
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
Title: Re: Open Office.
Post by: DavidA on April 07, 2016, 07:01:00 AM
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.
Title: Re: Open Office.
Post by: Doc on November 01, 2016, 08:40:38 PM
Pick the first cell in column a and b the click window and click freeze.
Title: Re: Open Office.
Post by: DavidA on November 02, 2016, 06:43:59 AM
George,

Thanks, I've managed to get it sorted out.

Dave.