|
From: Sergio A. K. <ser...@ho...> - 2002-02-09 03:01:35
|
I get a "Accounts Receivables Aging Report",
(or whatever report)
then I "select all", copy & paste into excel.
now, noone of the numeric columns show up as
numeric (no matter what format has the cells)...
why ? because all the html cells have a " "
(non breaking space)
<td align=right> 489.00</td>
(the source code of this is in rp.pl)
I suppose this nbsp was added to workaround the
ugly effect of a blank cell in mozilla.
AFAICS, mozilla 0.9.8 doesn't have this bug,
so the nbsp can be taken out.
another solution would be to put some "if"s in the code,
if the quantity is non blank echo the quantity,
otherwise echo a nbsp.
(yes, it would uglify the code)
and while we are at it, can you change the line
<table border=1>
by
<table class=table-report>
?
thanks,
/sergio
ps: maybe the templates directory should be separated by
country code, the same as locale...
|