Gnumeric crashes opening a particular type of xls file.
- From: David Stanaway <david stanaway net>
- To: gnumeric-list gnome org
- Subject: Gnumeric crashes opening a particular type of xls file.
- Date: Fri, 10 Sep 2004 15:26:59 -0500
Hi,
I have an xls file here which I get from one of my companies providers
which crashes gnumeric, and gets treated as a text file in oocalc. The
file magic doesn't mean anything to me. I am not sure what program was
used to generate the XL.
Here is a peak at the top of the file with od(1). The file contains
private business data so I can't post it somewhere public, but if anyone
wants a look at the file, let me know.
$ od -c r7985d090904mrhmmJd3miqi3DoqtYLvhLy79TrqRr.xls | more
0000000 \t \0 004 \0 002 \0 \n \0 037 \0 002 \0 027 \0 036 \0
0000020 \b \0 \a G e n e r a l 036 \0 002 \0 001 0
0000040 036 \0 005 \0 004 0 . 0 0 036 \0 006 \0 005 # ,
0000060 # # 0 036 \0 \t \0 \b # , # # 0 . 0 0
0000100 036 \0 030 \0 027 # , # # 0 \ " $ " ;
0000120 \ - # , # # 0 \ " $ " 036 \0 035 \0
0000140 034 # , # # 0 \ " $ " ; [ R e d
0000160 ] \ - # , # # 0 \ " $ " 036 \0 036
0000200 \0 035 # , # # 0 . 0 0 \ " $ " ;
0000220 \ - # , # # 0 . 0 0 \ " $ " 036
0000240 \0 # \0 " # , # # 0 . 0 0 \ " $
0000260 " ; [ R e d ] \ - # , # # 0 . 0
0000300 0 \ " $ " 036 \0 003 \0 002 0 % 036 \0 006
0000320 \0 005 0 . 0 0 % 036 \0 \t \0 \b 0 . 0 0
0000340 E + 0 0 036 \0 \t \0 \b d d / m m / y
0000360 y 036 \0 \r \0 \f d d / \ m m m \
0000400 y y 036 \0 \t \0 \b d d / \ m m m 036
0000420 \0 \b \0 \a m m m \ y y 036 \0 \f \0 \v
0000440 h : m m \ A M / P M 036 \0 017 \0 016
0000460 h : m m : s s \ A M / P M 036 \0
0000500 006 \0 005 h h : m m 036 \0 \t \0 \b h h :
0000520 m m : s s 036 \0 020 \0 017 d d / m m /
0000540 y y \ h h : m m 036 \0 \t \0 \b # #
0000560 0 . 0 E + 0 036 \0 006 \0 005 m m : s s
0000600 036 \0 002 \0 001 @ + \0 002 \0 001 \0 ( \0 \b \0
0000620 \0 \0 \0 \0 \0 \0 370 ? & \0 \b \0 \0 \0 \0 \0
0000640 \0 \0 370 ? ' \0 \b \0 \0 \0 \0 \0 \0 \0 370 ?
0000660 ) \0 \b \0 \0 \0 \0 \0 \0 \0 370 ? % \0 002 \0
0000700 030 001 1 \0 \n \0 310 \0 \0 \0 005 A r i a l
0000720 1 \0 \n \0 310 \0 001 \0 005 A r i a l 1 \0
0000740 \n \0 310 \0 005 \0 005 A r i a l 1 \0 \f \0
0000760 360 \0 002 \0 \a C o u r i e r $ \0 004 \0
0001000 \0 032 \0 022 004 \0 : \0 \0 \0 \0 \0 \0 277 \0 2
0001020 D a i l y G S E - D I A L
0001040 M E X R e t a i l C D R -
0001060 D a t e ( s ) : 0 9 - 0 9 -
0001100 0 4 004 \0 \n \0 002 \0 \0 \0 \0 177 \0 002 D T
0001120 004 \0 \n \0 002 \0 001 \0 \0 177 \0 002 T M 004 \0
0001140 \v \0 002 \0 002 \0 \0 177 \0 003 D U R 004 \0 #
0001160 \0 002 \0 003 \0 \0 177 \0 033 B A L A N C E
0001200 U S E D L O C A L C U R R
0001220 E N C Y 004 \0 037 \0 002 \0 004 \0 \0 177 \0 027
0001240 B A L A N C E U S E D U S
0001260 D O L L A R S 004 \0 022 \0 002 \0 005 \0 \0
0001300 177 \0 \n A C C E S S N U M 004 \0 \v
Comparing the data in the file to an xls file that gnumeric can open, it
looks like the bad file missing a file header.
Here is the od output of a file I can open.
0000000 320 317 021 340 241 261 032 341 \0 \0 \0 \0 \0 \0 \0 \0
0000020 \0 \0 \0 \0 \0 \0 \0 \0 > \0 003 \0 376 377 \t \0
0000040 006 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 001 \0 \0 \0
0000060 t \0 \0 \0 \0 \0 \0 \0 \0 020 \0 \0 376 377 377 377
0000100 \0 \0 \0 \0 376 377 377 377 \0 \0 \0 \0 u \0 \0 \0
0000120 377 377 377 377 377 377 377 377 377 377 377 377 377 377 377 377
*
0001000 \t \b 020 \0 \0 006 005 \0 273 \r 314 \a A \0 \0 \0
0001020 006 \0 \0 \0 B \0 002 \0 344 004 = \0 022 \0 \0 \0
0001040 \0 \0 274 % r 025 8 \0 \0 \0 \0 \0 001 \0 X 002
0001060 " \0 002 \0 \0 \0 1 \0 025 \0 310 \0 \0 \0 377 177
0001100 220 001 \0 \0 \0 \0 \0 \0 005 \0 A r i a l 1
0001120 \0 025 \0 310 \0 \0 \0 377 177 220 001 \0 \0 \0 \0 \0
0001140 \0 005 \0 A r i a l 1 \0 025 \0 310 \0 \0 \0
0001160 377 177 220 001 \0 \0 \0 \0 \0 \0 005 \0 A r i a
0001200 l 1 \0 025 \0 310 \0 \0 \0 377 177 220 001 \0 \0 \0
0001220 \0 \0 \0 005 \0 A r i a l 1 \0 025 \0 310 \0
0001240 \0 \0 377 177 220 001 \0 \0 \0 \0 \0 \0 005 \0 A r
0001260 i a l 1 \0 025 \0 310 \0 \0 \0 \f \0 220 001 \0
0001300 \0 001 \0 \0 \0 005 \0 A r i a l 1 \0 025 \0
0001320 310 \0 \0 \0 377 177 274 002 \0 \0 \0 \0 \0 \0 005 \0
0001340 A r i a l 036 004 016 \0 244 \0 \t \0 \0 $ #
0001360 , # # 0 . 0 0 036 004 \r \0 245 \0 \b \0 \0
0001400 # , # # 0 . 0 0 036 004 \n \0 246 \0 005 \0
0001420 \0 # , # # 0 340 \0 024 \0 \0 \0 \0 \0 365 377
0001440 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 300 340 \0
0001460 024 \0 \0 \0 \0 \0 365 377 \0 \0 \0 \0 \0 \0 \0
0001500 \0 \0 \0 \0 300 340 \0 024 \0 \0 \0 \0 \0 365 377
--
David Stanaway <david stanaway net>
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]
