You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Dick Hoffman <ol...@ix.netcom.com> on 2013/10/05 00:03:09 UTC

Re: AOO can't open .xlsx spreadsheet at Cornell site

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 <ol...@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<us...@openoffice.apache.org>
>>>
>>> For additional commands, e-mail:
>>> users-help@openoffice.apache.**org<us...@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


Re: AOO can't open .xlsx spreadsheet at Cornell site

Posted by Andrea Pescetti <pe...@apache.org>.
Dick Hoffman wrote:
>> https://issues.apache.org/ooo/show_bug.cgi?id=123429
>> since this is definitely a performance bug.
> Thanks for opening a bug on this. I don't understand the comment from
> Andreas Säger; does that mean no action will be taken on the bug?

It's simply an analysis of the pathological characteristics of this 
document. This is needed as a first step in investigating why OpenOffice 
is slow in opening it.

Regards,
   Andrea.

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


Re: AOO can't open .xlsx spreadsheet at Cornell site

Posted by Dick Hoffman <ol...@ix.netcom.com>.
On 10/5/2013 5:03 PM, Andrea Pescetti wrote:
> Dick Hoffman wrote:
>> 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.
>
> It opens normally for me with 4.0.1; however, it takes unacceptably long
> (13 minutes in my case). I opened
> https://issues.apache.org/ooo/show_bug.cgi?id=123429
> since this is definitely a performance bug.
>
> Regards,
>    Andrea.
Thanks for opening a bug on this. I don't understand the comment from 
Andreas Säger; does that mean no action will be taken on the bug?
Dick


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


Re: AOO can't open .xlsx spreadsheet at Cornell site

Posted by Andrea Pescetti <pe...@apache.org>.
Dick Hoffman wrote:
> 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.

It opens normally for me with 4.0.1; however, it takes unacceptably long 
(13 minutes in my case). I opened
https://issues.apache.org/ooo/show_bug.cgi?id=123429
since this is definitely a performance bug.

Regards,
   Andrea.

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