#3, Python will do it's thing, you might need to convert it to a numeric type because it'll assume it's a string given that it's being pulled out of a string. At least at a guess.

Some months back I developed some pyuno code for converting spreadsheets into CSV files from the command line. Pyuno being the Python interface to the OpenOffice runtime. One of the enhancement ...