What happens if you format the cell as a date? For example if I type in
1098 into an unformatted cell, then that's what displays. If I then
format the cell in Excel as a date, and I choose this format, I will see
1/2/1903. 31098 becomes 2/20/1985
Don't want the users to have to mess with that? Then use SQL2XLS or
something else that creates a formatted excel spreadsheet on your i's
stream file system and have the user access that instead. See also:
http://www.mcpressonline.com/tips-techniques/microsoft/techtip-excel-flies-higher-with-jexcelapi.html
http://www.scottklement.com/presentations/#RPGHSSF
Rob Berendt
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
