Thanks, Crystle... and apologies for giving you the wrong name! lol
I have attached the two files - supposedly identical - the one marked for OO
directly, the other opened prviously in excel - *not* saved, or anything,
just opened, prior to opening in OO.
If you open testexporttoOO.xls - the third sheet - FULL_CATEGORIES is blank
If you open testexporttoExcel.xls - the third sheet - FULL_CATEGORIES
contains the correct data
very, very strange :o>
Phil
----- Original Message -----
From: "Immanuel CRC Office" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, May 05, 2006 12:35 PM
Subject: Re: [users] Multiple sheet import of excel files
Phil Maitland wrote:
Thanks Immanuel,
All that is on the third sheet is numbers - with column headders - no
formulae carried over from other sheets, or suchlike.
I've since found that if I open the file in excel - no need to save or
anything - just *open* it... it then shows all the data - even the third
sheet - in Calc :oS
Weird, but I hope someone may be able to help :o>
Thansk,
Phil
Phil:
Does this mean that the original excel file is not made in Excel, but is
from some sort of report generator? If so, perhaps that generator doesn't
make the file 'up to spec' and therefore OOo can't figure it out.
If there is not sensitive data in the file, it might be helpful to file an
issue and to attach the original file (that doesn't open properly in
Calc), as well as the one that works 'after opening it in Excel'. They can
analyze the differences and tweak the import filters.
Crystle
----- Original Message ----- From: "Immanuel CRC Office"
<[EMAIL PROTECTED]>
To: <[email protected]>; <[EMAIL PROTECTED]>
Sent: Friday, May 05, 2006 8:43 AM
Subject: Re: [users] Multiple sheet import of excel files
Phil Maitland wrote:
Hi,
I have a problem in opening a three-sheet excel file into Calc... The
first two sheets open beautifully, but the third contains absolutely
nothing!
Quite frustrating as the data on this third sheet is essential to the
sftware I'll then be importing the completed document to...
Any ideas on how to get around this?
Thanks,
Phil
Phil:
Can you give us more information about what is supposed to be on that
sheet? Some charts, IIRC, have a bit of a hard time importing. If it is
just numbers, is some of it marked hidden, or something else?
Crystle
--
Crystle Numan
Administrative Secretary, Immanuel CRC
61 Mohawk Rd. W. Hamilton ON L9C 1V9
905-385-0662
[EMAIL PROTECTED]
http://immanuelministries.ca
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.3/331 - Release Date: 5/3/2006
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Crystle Numan
Administrative Secretary, Immanuel CRC
61 Mohawk Rd. W. Hamilton ON L9C 1V9
905-385-0662
[EMAIL PROTECTED]
http://immanuelministries.ca
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.4/332 - Release Date: 5/4/2006
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
