Re: Open Office 3.4.1
On Mon, 17 Jun 2013 10:07:51 -0400
"Frank Ervin, MD" wrote:
>
> We need to be able to move data from spreadsheet to an existing Excel (Office
> 2004) file . Copy and paste seems not to work; save as comma or tab
> delimited file seems not an option.
> Is there a mechanism I am overlooking? Please advise
>
>
> Frank Ervin, MD
> frank.er...@gmail.com
>
>
> "The average person avoids the truth as diligently as he avoids arson,
> regicide, and piracy on the high seas, and for the same reason, because he
> believes that it is dangerous, that no good can come of it, and that it
> doesn't pay." HL Mencken
>
/File /Save As in OpenOffice will permit yu to drop the file type selector to
MS Office 97/2000/XP format ("automatic file name extension" should be
checked), which will allow the file be read by Excel. This will allow you
insert an entire file into Excel.
--
Rory O'Farrell
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Open Office 3.4.1
Sakis, thanx and happy June 17 Frank On 2013-06-17, at 10:27 AM, Athanasios E. Samaras wrote: > If you save as tab-separated CSV file, it should do the trick since Excel > expects CSV to be separated by tab by default. > Alternatively you can save the comma separated values file with extention > ".txt" and then ask excel to open the *.txt files. This will bring up a > wizard where you can modify all the import settings. > > Cheers > > Sakis > > > On Mon, Jun 17, 2013 at 5:07 PM, Frank Ervin, MD wrote: > >> >> We need to be able to move data from spreadsheet to an existing Excel >> (Office 2004) file . Copy and paste seems not to work; save as comma or >> tab delimited file seems not an option. >> Is there a mechanism I am overlooking? Please advise >> >> >> Frank Ervin, MD >> frank.er...@gmail.com >> >> >> "The average person avoids the truth as diligently as he avoids arson, >> regicide, and piracy on the high seas, and for the same reason, because he >> believes that it is dangerous, that no good can come of it, and that it >> doesn't pay." HL Mencken >> >> - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Open Office 3.4.1
If you save as tab-separated CSV file, it should do the trick since Excel expects CSV to be separated by tab by default. Alternatively you can save the comma separated values file with extention ".txt" and then ask excel to open the *.txt files. This will bring up a wizard where you can modify all the import settings. Cheers Sakis On Mon, Jun 17, 2013 at 5:07 PM, Frank Ervin, MD wrote: > > We need to be able to move data from spreadsheet to an existing Excel > (Office 2004) file . Copy and paste seems not to work; save as comma or > tab delimited file seems not an option. > Is there a mechanism I am overlooking? Please advise > > > Frank Ervin, MD > frank.er...@gmail.com > > > "The average person avoids the truth as diligently as he avoids arson, > regicide, and piracy on the high seas, and for the same reason, because he > believes that it is dangerous, that no good can come of it, and that it > doesn't pay." HL Mencken > >
