I opened that 32,000+ row Cornell file as an XLSX in 15 to 20 seconds. To peek at it, I turn CELL WRAP on, and saw that some cells had massive amts of text. I'm running W/7 on a 5 or 6 year old HP.
Maurice -----Original Message----- From: Rob Weir [mailto:robw...@apache.org] Sent: Thursday, September 26, 2013 1:01 PM To: users@openoffice.apache.org Subject: Re: AOO can't open .xlsx spreadsheet at Cornell site On Thu, Sep 26, 2013 at 12:31 PM, Kay Schenk <kay.sch...@gmail.com> wrote: > On Wed, Sep 25, 2013 at 6:28 PM, Rob Weir <robw...@apache.org> wrote: > >> On Tue, Sep 24, 2013 at 5:58 PM, Dick Hoffman <old...@ix.netcom.com> >> wrote: >> > I downloaded a fairly large spreadsheet from this location >> > 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 >> >> >> Hi Dick, >> >> I can confirm the problem you report with AOO 4.0.0. But I then >> tried with AOO 4.0.1, a newer version which should be officially >> released soon. It was able to load that XLSX file. It was slow, but >> it did fully open. When I saved it as an ODS file, OpenOffice's >> native format, subsequent opens were much faster. >> >> I can send you the ODS version if you want. Or you can try again >> with AOO 4.0.1 once that releases. >> >> Regards, >> >> -Rob >> > > @Rob -- what OS are you using, given Julian's comment on this as well. > Windows 7, 32-bit. > I tried 4.0.1., Linux-32, and well basically gave up at the (about) > 25% load status. For me it "stopped" there as well. I took a phone call, and when I checked again the document was open. Check your CPU and see if it is still showing the soffice process as active. -Rob > I will try again. > > >> >> > >> > ------------------------------------------------------------------- >> > -- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org >> > For additional commands, e-mail: users-h...@openoffice.apache.org >> > >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org >> For additional commands, e-mail: users-h...@openoffice.apache.org >> >> > > > -- > ---------------------------------------------------------------------- > --------------------------- > MzK > > "Truth is stranger than fiction, but it is because Fiction is obliged > to stick to possibilities. Truth isn't." > -- "Following the Equator", Mark Twain --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2014.0.4142 / Virus Database: 3604/6700 - Release Date: 09/26/13 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
