Cell Style Caching Issue With POIUtility

I've been using Ben Nadel's POIUtilty for a while now. I really like the custom tag library he has built for building Excel spreadsheets, particularly the way he has abstracted the POI cell formatting options out to CSS. Last week however, I ran into a strange issue while running the latest release on CFMX 7. Cell styles were not being properly applied and it seemed to be related to the CSS style caching functionality. What was even more strange was that the code ran fine on CF 8. Below are samples of the correctly styled spreadsheet genrated by CF 8 and the incorrectly formatted spreadsheet generated by CF 7.


Ben Nadel's Gravatar Nathan, dynamic fix! I used the hashCode() originally because making my own hash based on the CSS properties was *very slow*. The HasCode() seemed to solve that problem with significant speed improvements. I new that it was a little dangerous, but didn't seem to be a problem upon testing.

I like what you've done. I will see about updating that ASAP. Thanks!
# Posted By Ben Nadel | 9/17/08 1:59 PM
Nathan Mische's Gravatar @Ben, no problem, thanks for POIUtility!
# Posted By Nathan Mische | 9/17/08 2:13 PM
BlogCFC was created by Raymond Camden. This blog is running version 5.8.001.