Check out http://jakarta.apache.org/poi/hssf/quick-guide.html#DataFormats
It has many great examples of code for features. Shawn -----Original Message----- From: Joshi, Rajesh [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 10:52 AM To: '[EMAIL PROTECTED]' Subject: Formatting using HSSFDataFormat. I am new-bie using POI - HSSFDataFormat class. HSSF supports standard formatting (like for "price") #,###.00. Using this formatting you get a numeric field with the appropriate formatting. But when I try to change the formatting to #,###.0000000 the extra fields in the fraction don't show up. The junit test however asserts that the field is numeric. How do you define a user defined formatting standard like #,###.0000000? Is there anyway of specifying the property of the field to be retained as numeric? Rajesh Joshi, * (626) 844-4816 <mailto:[EMAIL PROTECTED]> Western Asset Management Company 117, East Colorado Blvd., Pasadena, CA 91105 ********************************************************************** E-mail sent through the Internet is not secure. Western Asset therefore recommends that you do not send any confidential or sensitive information to us via electronic mail, including social security numbers, account numbers, or personal identification numbers. Delivery, and or timely delivery of Internet mail is not guaranteed. Western Asset therefore recommends that you do not send time sensitive or action-oriented message to us via electronic mail. ********************************************************************** --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
