G
Guest
I currently run an online application which allows users to export their data
in excel format. This is achieved by creating what is essentially a html file
and changing the MIME type to excel. This has work great for the last year or
so, however we've come accross an issue with it as of late.
For some reason on a worksheet of 2K plus rows, the sum() function doesn't
seem to operate as expected. On closer inspection, Excel 2003 allows me to
'convert text to number'. On doing so the correct sum values are reached.
An example may be as follows:
288213 24/07/2006 13:20:51 0 Account OCLT002 + 2-OC 123 Customer Large
Plumber/Heating A Saunlerson Sales p Phone South and West Richard Theath n No
Further Action x Not Re-arranged
288214 24/07/2006 13:21:21 0 Account RDNA027 Blah Blah Customer Self
Build A Saunlerson Sales p Phone South and West Richard Pheath n No Further
Action x Not Re-arranged
The first row does not require the conversion on the fourth column, whereas
the second does.
Any ideas would be much appreciated!
in excel format. This is achieved by creating what is essentially a html file
and changing the MIME type to excel. This has work great for the last year or
so, however we've come accross an issue with it as of late.
For some reason on a worksheet of 2K plus rows, the sum() function doesn't
seem to operate as expected. On closer inspection, Excel 2003 allows me to
'convert text to number'. On doing so the correct sum values are reached.
An example may be as follows:
288213 24/07/2006 13:20:51 0 Account OCLT002 + 2-OC 123 Customer Large
Plumber/Heating A Saunlerson Sales p Phone South and West Richard Theath n No
Further Action x Not Re-arranged
288214 24/07/2006 13:21:21 0 Account RDNA027 Blah Blah Customer Self
Build A Saunlerson Sales p Phone South and West Richard Pheath n No Further
Action x Not Re-arranged
The first row does not require the conversion on the fourth column, whereas
the second does.
Any ideas would be much appreciated!
="urn:schemas-microsoft-com