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 ------- Additional Comments From [EMAIL PROTECTED] 2003-02-04 22:10 ------- The problem with prepending an extra ' is that it will show up in Excel. For example, setCellValue("''abc'") causes this to appear in Excel: ''abc' When I double-click the cell and then exit it without changing it, the display changes to... 'abc' ...and thereafter behaves the way I want. But of course I shouldn't have to double-click every cell to make it appear correctly. As for the original problem, if I use '12345 then it starts out displayed as '12345 (which is not the intended effect) and only becomes 12345 after the double-click. It seems to me we need to know how *Excel* decides to prepend the ', which it should only do when I double-click the cell for editing. --Andy --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
