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]
