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 <davidbteague@comporium.net>
To: users@global.libreoffice.org
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 users+help@global.libreoffice.org
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 users+help@global.libreoffice.org
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
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.