DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=16767>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=16767 string "12345" becomes the number 12345 [EMAIL PROTECTED] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |INVALID ------- Additional Comments From [EMAIL PROTECTED] 2003-07-24 16:10 ------- Andy O. is right. This is a little gotcha with excel. The default data format is general which looks at the value and tries to determine what it is. I doesn't default to what the cell type is (part of the reason is there is not direct way through the interface to do that). The solution is to set the data format for that particular cell to text which then makes it come out properly. Setting the format to text also fixes the quoting problem. This comes about because you put a single ' in front of a number to tell excel that it is text and not to treat it as a number. This really isn't a bug as much as a feature of excel. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
