Is it true that HSSF doesn't support the setting Format/Cells/Number/Category/Text? If so, I'd like to request this feature. Although I can sort of fake what I need with a custom format, it's not the same thing and the user might not accept it. The custom format solution only partially solves the fragile spreadsheet problem created by leading zeros in number strings such as serial numbers.
A custom format will preserve the 'display' of leading zeros in a number string within a given cell after the cell has been edited. The problem is that the cell value will show up in the editing area without the leading zeros, after the cell has been edited. So while you're editing the cell, whether in place or in the editing area, you won't see the leading zeros. I think this will be bothersome to my users since we typically handle this now (manually) by setting Format/Cells/Number/Category to 'Text' for such cells so that the leading zeros appear in the editing area. - Jim ______________________________ James Watkin The Anderson School at UCLA [EMAIL PROTECTED] Voice: 1-310-825-5030 Fax: 1-310-825-4835 ______________________________ -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
