Re: How can I recover a gnumeric file?

[Jean Brefort <jean brefort normalesup org>]

Le mardi 09 juillet 2013 à 22:34 +1000, Pete Crite a écrit :
> Thank you so much for that. The new file works fine. It's mainly
> raw(ish) data, so styles don't matter very much.
>
> How could this have happened though? I certainly never made those
> changes to my file intentionally.

This is a good question. The file was generated with 1.10.17. If you did
not change the sheet sizes in the preferences or just for this file,
it's a bug. We just should need a reproducible way to fire that before
it can be fixed.

> Cheers,
> Pete.
>
> On 09/07/13 22:10, Jean Brefort wrote:
> > Looks that the sheets are very large: 16384 columns and 1048576 rows,
> > and I suppose you don't have terabytes RAM. Changing that to the default
> > and removing some StyleRegion nodes extending to rows larger than
> > 1000000 made things work much more fluently. I'll send you back the
> > fixed file. I just hope I did not accidentally removed a needed style.
> >
> > Best regards,
> > Jean
> >
> > Le mardi 09 juillet 2013 à 21:26 +1000, Pete Crite a écrit :
> > > Thanks for that. I've forwarded the file you you (Jean).
> > >
> > > I tried opening the uncompressed version in gnumeric, and I didn't think
> > > it worked. However, about 2–5 minutes later, gnumeric launched with the
> > > file. I tried to "save as" another file, but now it appears to have
> > > frozen again. It's running on two full cores, so I'll wait and see if it
> > > can write the file correctly, but there appears to be some issue with
> > > the file and/or gnumeric at least.
> > >
> > > Cheers,
> > > Pete.
> > >
> > > On 09/07/13 21:09, Jean Brefort wrote:
> > > > You don't need to compress the gnumeric file again. Gnumeric can read
> > > > uncompressed files. Hard to say why you can't open it without actually
> > > > seeing the contents. If the file does not contain confidential data,
> > > > please file a bug report and attach the file. Otherwise you might send
> > > > it to one of us, and we'll delete it when done.
> > > >
> > > > Best regards,
> > > > Jean
> > > >
> > > > Le mardi 09 juillet 2013 à 21:01 +1000, Pete Crite a écrit :
> > > > > Great! Thanks for that. The file does gunzip fine. The xml looks normal
> > > > > enough, and validates online [1]. Is there a way to now feed this
> > > > > information back into gnumeric, without having to manually pick through
> > > > > the xml?
> > > > >
> > > > > I tried gzipping this xml again, but this also failed to open in
> > > > > gnumeric. I'm not sure if it's relevant, but the new gzipped file
> > > > > differed from the original gnumeric file.
> > > > >
> > > > > When I started with `gnumeric /path/to/file.gnumeric`, I get no messages
> > > > > in the console.
> > > > >
> > > > > Cheers, and thank you for the help so far.
> > > > >
> > > > > [1] http://www.w3schools.com/xml/xml_validator.asp
> > > > >
> > > > >
> > > > > On 09/07/13 18:00, Jean Brefort wrote:
> > > > > > I believe it's better to rename to file.gnumeric.gz, then `gunzip
> > > > > > file.gnumeric.gz`.
> > > > > > When you start `gnumeric /path/to/file.gnumeric`, do you get any message
> > > > > > in the console?
> > > > > >
> > > > > > Best regards,
> > > > > > Jean
> > > > > >
> > > > > > Le mardi 09 juillet 2013 à 01:55 -0600, Andreas Guelzow a écrit :
> > > > > > > Hi,
> > > > > > >
> > > > > > > .gnumeric files are compressed xml files. So the first thing to try is
> > > > > > > to uncompress the file. On Kubuntu you may want to rename the
> > > > > > > file.gnumeric to file.zip and see whether the archive manager can open
> > > > > > > the file then. If you are successful then the extracted file will give
> > > > > > > you all the information that is still available.
> > > > > > >
> > > > > > > Andreas 
> > > > > > >
> > > > > > >
> > > > > > > On Tue, 2013-07-09 at 17:14 +1000, Pete Crite wrote:
> > > > > > > > Hello,
> > > > > > > >
> > > > > > > > I'm trying to open a gnumeric file that had worked in the past for me.
> > > > > > > > Opening the file via `xdg-open` fails silently. Opening the file with
> > > > > > > > `gnumeric /path/to/file.gnumeric` freezes the command line and fails
> > > > > > > > silently. Launching Gnumeric first, then opening the file from within
> > > > > > > > the program causes the "Reading file…" progress bar to freeze while loading.
> > > > > > > >
> > > > > > > > I'm happy to try and find the cause of this bug, but I have some
> > > > > > > > important files that I need to extract from the gnumeric file urgently.
> > > > > > > > Is there a way to recover the contents of the file? I tried opening with
> > > > > > > > a plain-text editor, but the contents were garbled. Similarly,
> > > > > > > > Libreoffice Calc didn't know about this format.
> > > > > > > >
> > > > > > > > Cheers,
> > > > > > > > Pete.
> > > > > > > >
> > > > > > > > Kubuntu 13.04
> > > > > > > > Gnumeric 1.12.1
> > > > > > > > _______________________________________________
> > > > > > > > gnumeric-list mailing list
> > > > > > > > gnumeric-list gnome org
> > > > > > > > https://mail.gnome.org/mailman/listinfo/gnumeric-list
> > > _______________________________________________
> > > gnumeric-list mailing list
> > > gnumeric-list gnome org
> > > https://mail.gnome.org/mailman/listinfo/gnumeric-list