"SourceForge.net" <[EMAIL PROTECTED]> wrote:
Read and respond to this message at:
https://sourceforge.net/forum/message.php?msg_id=3809406
By: jskpothana
Dear All,
I have some strange problems while using Export to Excel functionality
of display tag.
1. Whenever I export the numeric value(with more than 10digits) with 3 decimal
places to the excel, it is showing zeros in the last 4-5 digits.Eg
322233333333333.736 will show in the excel as 322233333333333.000. Can we format
the excel column type as text from the jsp file where we are having display tag?
Looks like an Excel limitation. Got the same result manually.
2. In some case if the cell size is smaller than the numerical value size(digits)
it showing only "#". Can we define the width of excel column?
This means the content is wider than the column width; you have to manually expand the column in Excel.
The 1.1 default excel exporter does not attempt to set the column width to the maximum value in the column or a configured maxWidth. This should probably be added. However, since it's based on poi-hssf, doing so will be limited to only suggesting the column width, not setting it exactly. So, you'll still run into columns whose width are less than the desired length.
Can anybody help me.
Thanks & Regards
Suresh
______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit:
https://sourceforge.net/forum/unmonitor.php?forum_id=249318
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
displaytag-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/displaytag-user
Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ displaytag-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/displaytag-user
