Strange Behaviour of Excel - Please Help Me !

A

Antonio Paglia

Hello,
The following one is the content of a called file "bw.htm". I have noticed a
strange behavior when trying opening it with Excel 2000 in different ways:
Case 1) From the Explorer, on this file use the option to "Open With " and
select Microsoft for Excel Windows". Result: it shows the 3 columns "Kilos"
as 300 instead of 300.000 (300.000 are the correct thing) show to the column
Price x TT as 1.555.000 instead of 155,5000 (155,5000 is correct)
Case 2) Open Excel and soon from Menu File / Open - I select my file htm In
this case it shows the values in correct form, says 300.000 for Kilos and
155,5000 for Prices
Case 3) Use the Explorer to visualize file htm and also in this case shows
correctly the values. The file is generated automatically from an VB6
Application and through OLE Automatization, my program opens an instance of
Excel and finally it opens file htm
Strangely, my client visualizes the data according to case 1). However I
visualize the data correctly. My client has W98 and Office 2000. I have
proven all the possible combinations but profit do not reproduce his
problem programatically. There is not problem With Regional Settings.
Somebody can give some solution to this problem?
TIA. Antonio



html>
<body>

<table border=1 CELLSPACING=0>
<tr>
<th><b><FONT FACE='Verdana' SIZE=2><nobr>Número de Contrato
Venta</nobr></FONT></b></th>
<th><b><FONT FACE='Verdana' SIZE=2><nobr>Fecha de
Contrato</nobr></FONT></b></th>
<th><b><FONT FACE='Verdana' SIZE=2><nobr>Kilos
Mínimos</nobr></FONT></b></th>
<th><b><FONT FACE='Verdana' SIZE=2><nobr>Kilos
Máximos</nobr></FONT></b></th>
<th><b><FONT FACE='Verdana' SIZE=2><nobr>Kilos
Promedio</nobr></FONT></b></th>
<th><b><FONT FACE='Verdana' SIZE=2><nobr>Precio por
TT</nobr></FONT></b></th>
</tr>
<tr>
<td align=Left><FONT FACE='Verdana' SIZE=-1><nobr> 804001</nobr></FONT></td>
<td align=Center><FONT FACE='Verdana'
SIZE=-1><nobr>10-06-2003</nobr></FONT></td>
<td align=Right><FONT FACE='Verdana'
SIZE=-1><nobr>200.000</nobr></FONT></td>
<td align=Right><FONT FACE='Verdana'
SIZE=-1><nobr>200.000</nobr></FONT></td>
<td align=Right><FONT FACE='Verdana'
SIZE=-1><nobr>200.000</nobr></FONT></td>
<td align=Right><FONT FACE='Verdana'
SIZE=-1><nobr>155,5000</nobr></FONT></td>
</tr>
</table>
</body>
</html>
 
Top