[9fans] xls2txt

[9fans] xls2txt

[Lucio De Re]

Thanks to Steve Simon for what has to be one of the most useful tools
in the Plan 9 toolbox.

It does fail on the random spreadsheet I chose, but I think the
problem lies elsewhere (floating point library, probably).

Here is the acid report on msexceltables.  I haven't tried to identify
the value that caused the crash, but I'm sure the formatting library
ought to be more robust.  Not that I have ever worked with floating
point libraries myself, I wouldn't know where to start looking for
this type of problem.

The error context:

354                                               Analogue       
355                                               Analogue       
356       'Fax 4251438'        'Ex Trace Team'           'Admin Dept'          msexceltables 83834: suicide: sys: fp: stack underflow fppc=0x14d3 status=0xc0a1 pc=0x000012c1
cpu% 

The source code context:

	if (fmt == 9)
		snprint(buf, sizeof(buf),"%.0f%%", num);
	else

cpu% acid 83834
/proc/83834/text:386 plan 9 executable

/sys/lib/acid/port
/sys/lib/acid/386
acid: lstk()
numfmt(num=0x9999999a,fmt=0x9,min=0xe,max=0xffffffff)+0x7c /sys/src/cmd/aux/msexceltables.c:171
	buf=0x32313234
dump()+0x28a /sys/src/cmd/aux/msexceltables.c:241
	r=0x1b490
	c=0x1b550
	min=0xe
	max=0xffffffff
	i=0x3
eof()+0xd7 /sys/src/cmd/aux/msexceltables.c:584
	names=0x5
	i=0x0
xls2csv(bp=0xed58)+0x164 /sys/src/cmd/aux/msexceltables.c:674
	dispatch=0xa
	biff=0xed58
	b=0x7fffae98
	i=0x0
main(argv=0x7fffef98,argc=0x1)+0xf8 /sys/src/cmd/aux/msexceltables.c:725
	_argc=0x0
	_args=0x0
	bout=0x0
	i=0x0
	bp=0xed58
	bin=0x0
_main+0x31 /sys/src/libc/386/main9.s:16
acid: 

Re: [9fans] xls2txt

[Steve Simon]

Could you send me the spreadsheet that causes the problem?

-Steve

Re: [9fans] xls2txt

[rog]

[-- Attachment #1: Type: text/plain, Size: 399 bytes --]

> Could you send me the spreadsheet that causes the problem?

hi steve,

this thread alerted me to the existence of xls2txt.
the first one i tried it on, it failed. i doubt it's anything to
do with your code, but here's a sample in case you
can do something with it...

  cheers,
    rog.

PS.
the output is:
aux/msexceltables: expected CONTINUE, got op=0xff00

# author Ian Davies

[-- Attachment #2.1: Type: text/plain, Size: 328 bytes --]

from postmaster@ethel:
The following attachment had content that we can't
prove to be harmless.  To avoid possible automatic
execution, we changed the content headers.
The original header was:

	Content-Type: application/vnd.ms-excel
	Content-Disposition: attachment; filename=body.xls
	Content-Transfer-Encoding: base64

[-- Attachment #2.2: body.xls.suspect --]
[-- Type: application/octet-stream, Size: 1981952 bytes --]

Re: [9fans] xls2txt

[rog]

oops bitten by Reply-To again. it's been some time.
sorry folks. and i'm really sorry about the size of the
file too. i hadn't realised it was that big.
well, at least you can bask in the knowledge
that you now have a complete itinerary for the
Moor & Coast folk festival in Whitby this weekend. (at least,
i presume that's what it is, not having been able to read it).
joy.

  cheers,
    rog.