Re: [libreoffice-users] calc problem

On 2013-03-27 23:23, Tim Lloyd wrote:
> It was not a matter of preferences. It was because calc could not open 
> a .XLS file. On further investigation it was found that it is not an 
> XLS file hence the problem
>
> Cheers
> On 03/28/2013 01:48 PM, nvrk wrote:
> > Is there a reason why the .xls file version is preferred to the .csv
> > version from the afr.com site?
> > nvsoar
> >
> > On Wed, Mar 27, 2013 at 5:47 PM, Michael Wu <mwu@tercel.com.tw> wrote:
> >
> > > > > On Tue, Mar 26, 2013 at 7:44 AM, Tim Lloyd <tim.lloyd@gmx.com
> > > > > <mailto:tim.lloyd@gmx.com>> wrote:
> > > > >
> > > > >      Hi, before I log this as a bug I would like to know whether 
> > > > > anyone
> > > > >      has seen it before/potential fix identified.
> > > > >
> > > > >      I normally use Fedora linux and I download (.XLS) share tables
> > > > >      from a financial newspaper here in Oz. Yesterday I inadvertently
> > > > >      clicked on the wrong table by accident and tried to open it. 
> > > > > Calc
> > > > >      locked up! No problem with the files I normally look at, Calc
> > > > >      opened them fine.
> > > > >
> > > > >      So I tried again today and waited for an error - "LibreOffice
> > > > >      4.0.1.2 General input/output error". So I hopped over to the
> > > > >      windows PC and tried LO portable. Same error. The error was
> > > > >      repeated whether I tried to open directly from the website or 
> > > > > if I
> > > > >      saved to disk and then attempted to open the file. MS Excel 
> > > > > has no
> > > > >      problems.
> > > > >
> > > > >      The file in question is accessible using this link:
> > > > >
> > > > >      http://www.afr.com/share_tables/
> > > > >
> > > > >      Just click on the xls link next to "Warrant Market"
> > > > >
> > > > >      Any comments?
> > > > >
> > > > >      Cheers
> > > Hi Tim,
> > >
> > > Since you use Fedora Linux, maybe you can try gnumeric as a temporary
> > > alternative.
> > >
> > > Hope it helps and regards,
> > >
> > > Michael
> > >
> > > --
> > > For unsubscribe instructions e-mail to: 
> > > users+help@global.libreoffice.org
> > > Problems?
> > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > > Posting guidelines + more: 
> > > http://wiki.documentfoundation.org/Netiquette
> > > List archive: http://listarchives.libreoffice.org/global/users/
> > > All messages sent to this list will be publicly archived and cannot be
> > > deleted

Tim:

I finally had enough free time(very rare(short leash)), with access to 
Excel '03, to work with the file.  I started by opening it in Excel and 
truncating rows of data.  I would then try to open this truncated file 
with Calc (latest portable version).  I started with large chunks (about 
1k row).  Once Calc would open the file (4k rows removed), I started 
splitting the difference between 3k and 4k rows removed. I kept getting 
the Data I/O failure until I had removed 3617rows from the end.  I then 
repeated the process by removing rows of data from the beginning of the 
file. Again the file would open in Calc with 3618 rows removed from the 
beginning of the file.  In another block of free time, I removed rows 
from the middle of the filewith similar results.

Items of note:

The original file used 7200 rows in Excel.

I neverremoved any rows from the Column labels on up.

The pass/fail for opening the file in Calc was unstable when near the 
3617row removal.

When cancelling the Data I/O error message, it would take nearly the 
same amount of time for the message to clearas it did to appear.

The original file structure had 191k lines. Row/cell tags were quite 
often on their own line from the data.

Once opened in Excel and saved the file structure was automatically 
changed to Excel Spreadsheet XML format.  This seemed to have no effect 
on Calc's ability to open the files.

When Calc was able to open the file, two empty rows above the column 
labels were missing that were there when opened in Excel.

I did not have enough time to try truncating data using a text editor on 
the original file.

TomW

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted