On 7/27/2011 1:01 PM, JOE Conner wrote:
On 7/27/2011 5:04 AM, David B Teague sr wrote:
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
On 7/27/2011 1:01 PM, JOE Conner wrote:
On 7/27/2011 5:04 AM, David B Teague sr wrote:
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
On 7/27/2011 5:04 AM, David B Teague sr wrote:
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 bl
ixed width thing in Base.
Regards from
Tom :)
From: David B Teague sr
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 > &
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
Le 25/07/2011 13:10, George R. Kasica a écrit :
OK..that gets the file in, but the first 4 rows that are always locked
with Headers get replaced as well even if I say from Line 4, and I've
tried both before and after sheet options. Also there are some calc
lines at the bottom that in Excel are au
>Hi :)
>I think i would approach this by using a database program rather than
>importing
>into a spreadsheet program. A database program such as Base should be able to
>read the text-files directly. Queries, Forms and Reports can be set-up to do
>the required calculations.
Interesting idea,
:)
From: George R. Kasica
To: users@global.libreoffice.org
Sent: Mon, 25 July, 2011 12:10:52
Subject: Re: [libreoffice-users] How to import a txt file into an existing Calc
sheet?
>At 07:48 23/07/2011 -0500, George R. Kasica wrote:
>>I have a currently existing Excel 2007 she
>At 07:48 23/07/2011 -0500, George R. Kasica wrote:
>>I have a currently existing Excel 2007 sheet that I can do a (In
>>Excel) Refresh All for \\APOLLO\e\WeatherLink\JACW3\download.txt ...
>
>So that's a file available to your system?
Yes, its a flat file created from some weather equipment.
>>.
At 07:48 23/07/2011 -0500, George R. Kasica wrote:
I have a currently existing Excel 2007 sheet that I can do a (In
Excel) Refresh All for \\APOLLO\e\WeatherLink\JACW3\download.txt ...
So that's a file available to your system?
... which is a te[x]t file in the format of: [...] and is properly
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 HiLow Out WindWind Hi
Hi Wind Heat THSWRain
11 matches
Mail list logo