I’m sorry I think I may have confused you… It works. I jut like to look
at each column of data in the excel formatter before loading into excel (i,e,
specify fields suh as ssn and zip code that may have leading zeroes as text). If
you save as an excel file you don’t get a chance to do that. I can export
from f5, just fine.
sorry for the confusion
On Fri, Oct 23, 2009 at 10:21 AM, Jeff Smith wrote:
That’s troubling Gene, do you have some examples we can try to work
through?
What version of Excel are you using, and do you try the Instance or the File
exports?
________________________________________
Ahhhh. Gene, have you seen the export XLS option to preserve or match the cell fonts? That should export numbers as numbers, strings as strings, dates as dates, etc. Don’t know if that will help you in your case or not…
It’s not a stupid question. 2 people in our office could reproduce the
problem. I could not. They had Excel 2003. I had Excel 2007. I have
seen other problems that only happened with Excel 2003.
…at least we think, maybe. We could reproduce a similar issue with NULL’s in
the dataset, but we could not reproduce with your select 1,2,3,4 from dual
example. Our bug fix had to do with writing NULL’s, so there is still a chance
this might not be 100% fixed.