From mboxrd@z Thu Jan  1 00:00:00 1970
Message-ID: <259679605ef73f6332e1041a856d2a25@proxima.alt.za>
To: 9fans@cse.psu.edu
From: Lucio De Re <lucio@proxima.alt.za>
Date: Sun, 24 Apr 2005 11:16:10 +0200
MIME-Version: 1.0
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit
Subject: [9fans] xls2txt
Topicbox-Message-UUID: 3fe7033e-ead0-11e9-9d60-3106f5b1d025

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: