Posted by Heiko Richler on 12/19/06 20:39

Hi toffee,

> output the results as an excel spreadsheet.
> I do this by setting the header as application excel. All works well except
> for a very strange problem. Let's say a column should say 16500.22. When I
> run it here from the uk, the cell will show 16500.22
> When someone in Netherlands runs it, the cells shows 16,500,220,000
>
> It looks like Excel is mixing the commas and dot somewhere along the line ?

Excel uses the "Regional and Language Settings" set up by Windows to
interpretate the given Value.

What do you use to create that excel spreadsheet?

You could try exporting a spreadsheet as you would like it to be -
including formulas and layout - as an html-file. If you now send this
file and set the Content-Type to excel this should work.

As far as I know this does not work with excel 95 and older, but it
should work with newer excel or openoffice.org.

You may get td-elements like this:
<td class=xl76 align=right x:num="16500.22">16500.22</td>
the attribute x:num stores the original value with an point as the
decimal sign. The content of the td-element stores the representation
set in excel.

Heiko

[Back to original message]