toffee wrote:
Hi all,
I created a little button which when clicked will run a query on
mysql db and output the results as an excel spreadsheet.
Really as an Excel spreadsheet or a csv?
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 ?
Anyway know what I can do to keep my colleagues from holland happy ?
Well, it has offcourse got to do with the fact that the dot is the
thousands-seperator, and the comma is the decimal seperator, at least here
in Holland :P.
As far as a Dutch version of Excel is concerned, an number formatted like
16500.22 is gibberish. I would have thought it would choose either to
display is as text, or as 165,000,220 (well, they'd see it as 165.000.220),
but where the extra thousand comes from I wouldn't know.
It offcourse has something to do with locale-settings. I have cracked this
one before, but fortunately for me, unfortunately for you, I'm no longer
forced to deal with MS Office, and I haven't got a clue wether is was Excel
or Windows that had to be pounded into shape.
Afaik when you import a csv instead of opening it just like an Excel
document, one can choose the decimal seperator BTW. Not very user friendely
though.
Either:
- ask on microsoft.public.excel or better yet
microsoft.public.nl.office.excel (as there obviously will be more dutch
aware of this issue)
- create a settings before the output how to format numbers (either in
dutch or reversed :-)
Nothing to do with PHP obviously.
--
Rik Wasmus