Mailing-List: contact users-help@openoffice.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openoffice.apache.org
Received-SPF: pass (nike.apache.org: domain of gcaopenu-users@m.gmane.org
 designates 80.91.229.3 as permitted sender)
To: users@openoffice.apache.org
From: Dick Hoffman <oldrah@ix.netcom.com>
Subject: Re: AOO can't open .xlsx spreadsheet at Cornell site
Date: Fri, 04 Oct 2013 18:03:09 -0400
Lines: 57
Message-ID: <l2ndtk$vd5$1@ger.gmane.org>
References: <52420B23.5030301@ix.netcom.com>
 <CAGj3217JndcNUNUtY5DmvcaEkc-RgcCFLeAshyE61BNgn31d1A@mail.gmail.com>
 <l226s4$ftl$1__29381.5690828071$1380378343$gmane$org@ger.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
User-Agent: Mozilla/5.0 (Windows NT 5.1;
 rv:24.0) Gecko/20100101 Firefox/24.0 SeaMonkey/2.21
In-Reply-To: 
 <l226s4$ftl$1__29381.5690828071$1380378343$gmane$org@ger.gmane.org>

On 9/26/2013 4:53 PM, Dick Hoffman wrote:
> On 9/25/2013 7:54 PM, Kay Schenk wrote:
>> On Tue, Sep 24, 2013 at 2:58 PM, Dick Hoffman <oldrah@ix.netcom.com>
>> wrote:
>>
>>> I downloaded a fairly large spreadsheet from this location
>>> http://www.birds.cornell.edu/**clementschecklist/download/<http://www.birds.cornell.edu/clementschecklist/download/>
>>>
>>> but when I try to open it with AOO the progress line shows about a
>>> quarter
>>> of it being loaded and then AOO stalls and I have to use the Task
>>> Manager
>>> to cancel soffice. This is using AOO 4.0 on a Windows XP Pro/SP3 system.
>>> Any suggestions as to what might be wrong will be appreciated.
>>> Dick Hoffman
>>>
>>> ------------------------------**------------------------------**---------
>>>
>>> To unsubscribe, e-mail:
>>> users-unsubscribe@openoffice.**apache.org<users-unsubscribe@openoffice.apache.org>
>>>
>>> For additional commands, e-mail:
>>> users-help@openoffice.apache.**org<users-help@openoffice.apache.org>
>>>
>>>
>> No suggestions and yes AOO 4.0.x has  a problem with it. I downloaded
>> it as
>> well. I hope it doesn't contain personal data. If it does, I will
>> delete it.
>>
>> On the other hand, if it doesn't, can we use it as an attachment to an
>> issue?
>>
>> This would be helpful to troubleshoot this problem.
>> Thanks.
>>
> The spreadsheet at the Cornell site doesn't contain any personal data;
> it can be used for troubleshooting purposes, or any other. I've had
> various suggestions and received several remedies. To summarize: the
> .xlsx file can apparently be read in OO 3.1.1 (someone who was able to
> do so saved it as a .ods and sent it on to me); the .xlsx file
> apparently can be read in AOO 4.0.1 (someone who was able to do so
> offered to save it as a .ods and send it on to me); yes, the .csv file
> can be taken into AOO or Excel to create an equivalent spreadsheet but
> you lose the color coding that is in the .xlsx which helps when
> scrolling through the data and the references from the second sheet of
> the .xlsx file don't seem to be present in the .csv file. I now have a
> version of the Cornell file in .ods format that serves my purposes.
> Thanks to all of you for your comments and suggestions. What a great
> group of people you are!
> Dick Hoffman
> Cleveland Heights, OH
I upgraded to AOO 4.0.1, so out of curiosity I tried to access the .xlsx 
file at the Cornell site. Results were the same; after about 20 minutes 
the progress bar showed about 25% of the file loaded and I had to use 
the Windows Task Manager to terminate soffice.bin to stop it.
Dick


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org