Hi :) I had a go at using "Fixed width" but then needed to define each width in the little box at the bottom which was uncomfortably small on my screen at my resolution. Later on i tried it again and it had remembered the widths i had defined last time. Sadly i could not find the fixed width thing in Base. Regards from Tom :)
________________________________ From: David B Teague sr <[email protected]> To: [email protected] Sent: Wed, 27 July, 2011 13:04:59 Subject: Re: [libreoffice-users] How to import a txt file into an existing Calc sheet? Using your data, I used Edit > "paste special" then chose "unformatted text" from the dialog. The dialog then wanted to know what the separator was. I tried "space" and it inserted data into cells but your data has a number spaces so I got many blank cells. I tried to replace multiple spaces with a comma, and that worked, but your data doesn't have a consistent number of separating spaces so that did not appear to be useful. I played with it, and I believe if you separate the data items with a single space, a tab, or something that Calc likes for a separator you may have some luck with "paste special". Hope this helps. --David Teague On 7/23/2011 8:48 AM, George R. Kasica wrote: > Hello: > > I have a currently existing Excel 2007 sheet that I can do a (In > Excel) Refresh All for \\APOLLO\e\WeatherLink\JACW3\download.txt which > is a test file in the format of: > > Temp Hi Low Out Wind Wind Hi > Hi Wind Heat THSW Rain Solar Solar Hi > Solar UV Hi Heat Cool In In In In In > In Air Soil 1 Soil Leaf Wind Wind ISS Arc. > Date Time Out Temp Temp Hum Dew Speed Dir Run > Speed Dir Chill Index THW Index Bar Rain Rate Rad. > Energy Rad. UV Dose UV D-D D-D Temp Hum Dew > Heat EMC Density ET Moist. Temp 1 Wet 1 Samp Tx Recept > Int. >---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- >- > 7/22/11 0:01 75.6 75.6 75.6 69 64.7 1.0 WNW 0.02 > 1.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00 > 0 0.0 0.00 0.0 0.000 0.007 79.5 46 56.9 79.3 8.46 > .0722 0.000 153 69.0 15 9 1 39.1 1 > 7/22/11 0:02 75.6 75.6 75.6 69 64.7 2.0 WNW 0.03 > 3.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00 > 0 0.0 0.00 0.0 0.000 0.007 79.5 47 57.5 79.3 8.66 > .0722 0.000 153 69.0 15 20 1 87.0 1 > 7/22/11 0:03 75.6 75.6 75.6 69 64.7 1.0 WNW 0.02 > 2.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00 > 0 0.0 0.00 0.0 0.000 0.007 79.5 47 57.5 79.3 8.66 > .0722 0.000 153 69.0 15 22 1 95.7 1 > 7/22/11 0:04 75.6 75.6 75.6 69 64.7 1.0 WNW 0.02 > 3.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00 > 0 0.0 0.00 0.0 0.000 0.007 79.5 48 58.1 79.4 8.86 > .0721 0.000 153 69.0 15 21 1 91.3 1 > 7/22/11 0:05 75.6 75.6 75.6 69 64.7 1.0 WNW 0.02 > 3.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00 > 0 0.0 0.00 0.0 0.000 0.007 79.5 48 58.1 79.4 8.86 > .0721 0.000 153 69.0 15 21 1 91.3 1 > > and is properly formatted automatically by a Text-To Colums setup > already in the MS Excel sheet so all I need to do each day is Refresh > All and select the filename and it pulls in the data in the proper > column. > > For the life of me I cannot see how to do this in Calc...and opening > the existing sheet gets the right format, but I'm at a loss of how to > get new data into it without redoing the whole text to columns every > time (not an option due to time constraints here each day when this > has to happen...data is available at 59 past the hour and needs to jut > come in to be used by 15 past the next hour. > > Can anyone help with this? As of right now its the one thing keeping > me from dumping the Office 2007 suite. 7/22/11 0:01 75.6 75.6 75.6 69 64.7 1.0 WNW 0.02 1.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00 0 0.0 0.00 0.0 0.000 0.007 79.5 46 56.9 79.3 8.46 .0722 0.000 153 69.0 15 9 1 39.1 1 7/22/11 0:02 75.6 75.6 75.6 69 64.7 2.0 WNW 0.03 3.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00 0 0.0 0.00 0.0 0.000 0.007 79.5 47 57.5 79.3 8.66 .0722 0.000 153 69.0 15 20 1 87.0 1 7/22/11 0:03 75.6 75.6 75.6 69 64.7 1.0 WNW 0.02 2.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00 0 0.0 0.00 0.0 0.000 0.007 79.5 47 57.5 79.3 8.66 .0722 0.000 153 69.0 15 22 1 95.7 1 7/22/11 0:04 75.6 75.6 75.6 69 64.7 1.0 WNW 0.02 3.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00 0 0.0 0.00 0.0 0.000 0.007 79.5 48 58.1 79.4 8.86 .0721 0.000 153 69.0 15 21 1 91.3 1 7/22/11 0:05 75.6 75.6 75.6 69 64.7 1.0 WNW 0.02 3.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00 0 0.0 0.00 0.0 0.000 0.007 79.5 48 58.1 79.4 8.86 .0721 0.000 153 69.0 15 21 1 91.3 1 -- nil significat nisi oscillat -- Unsubscribe instructions: E-mail to [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
