Return-Path: X-Original-To: apmail-openoffice-users-archive@www.apache.org Delivered-To: apmail-openoffice-users-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 4620610E8A for ; Mon, 17 Jun 2013 14:47:02 +0000 (UTC) Received: (qmail 48334 invoked by uid 500); 17 Jun 2013 14:47:01 -0000 Delivered-To: apmail-openoffice-users-archive@openoffice.apache.org Received: (qmail 48285 invoked by uid 500); 17 Jun 2013 14:47:01 -0000 Mailing-List: contact users-help@openoffice.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openoffice.apache.org Delivered-To: mailing list users@openoffice.apache.org Received: (qmail 48272 invoked by uid 99); 17 Jun 2013 14:47:00 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Jun 2013 14:47:00 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of frank.ervin@gmail.com designates 209.85.216.51 as permitted sender) Received: from [209.85.216.51] (HELO mail-qa0-f51.google.com) (209.85.216.51) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Jun 2013 14:46:54 +0000 Received: by mail-qa0-f51.google.com with SMTP id f11so1459916qae.17 for ; Mon, 17 Jun 2013 07:46:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=subject:mime-version:content-type:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to:x-mailer; bh=qSoGQd89diphoab6vIGvo1xFRDicwPUUHNQ0ntChdyM=; b=PY2zzDhXBceFWb5T4LAurq3CKmGHfeqqWOG6ZAI/Ep/Ep1d5ALo86pTxmX+RS57BgC /11xrNpXG4bH7As6QJGFMA4aq73XCR3toJz+g03HN7JUNXBc1oJ/g5GCUZX/FHYNQeZ/ 0XLptDYvY4xKs/dSlJ8eQZ19jLbSnmgT+kk+KKXKbQx71kUC9pSKjiiTMudVHP7COBBY MsMWGt64k4IHYP1WMxkKr8BEkGNkOhXiQnT2x+dR8ZkcwGSNhg0NgeW/VgOwQBSCVgZB YFMiP48rN2fCNQq6PdllN6vBLOO1LBdjS/RlbVljCfrb3E6wB/U1ZvFTGiClm0lWnDGu HIFg== X-Received: by 10.229.152.200 with SMTP id h8mr6120195qcw.65.1371480393896; Mon, 17 Jun 2013 07:46:33 -0700 (PDT) Received: from [192.168.2.14] (bas1-montreal07-1176500008.dsl.bell.ca. [70.31.247.40]) by mx.google.com with ESMTPSA id ds7sm21666219qab.13.2013.06.17.07.46.31 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Mon, 17 Jun 2013 07:46:32 -0700 (PDT) Subject: Re: Open Office 3.4.1 Mime-Version: 1.0 (Apple Message framework v1085) Content-Type: text/plain; charset=us-ascii From: "Frank Ervin, MD" In-Reply-To: Date: Mon, 17 Jun 2013 10:46:29 -0400 Cc: Palmour Roberta Content-Transfer-Encoding: quoted-printable Message-Id: References: To: users@openoffice.apache.org X-Mailer: Apple Mail (2.1085) X-Virus-Checked: Checked by ClamAV on apache.org 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. >=20 > Cheers >=20 > Sakis >=20 >=20 > On Mon, Jun 17, 2013 at 5:07 PM, Frank Ervin, MD = wrote: >=20 >>=20 >> 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 >>=20 >>=20 >> Frank Ervin, MD >> frank.ervin@gmail.com >>=20 >>=20 >> "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 >>=20 >>=20 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org For additional commands, e-mail: users-help@openoffice.apache.org