What version of Java POI is on CF 10 ?

[dfafard]

I am using 3.8 on 9.01 but having issues setting colors and formatting.

Thanks,

Dave

[dfafard]

Does anyone know this answer?

Is it 3.8 on CF 10 ?

Anyone?

can some one on 10 run this?

<cfset poi = createObject("java", "org.apache.poi.Version")/> 

<cfoutput>#poi.getProduct()# #poi.getVersion()# #poi.getReleaseDate()#</cfoutput>

[Adam Cameron.]

Well this is heartening (not):

POI 3.6-beta1 20111214

This is on 10,0,0,282913

So CF10 shipped with a beta.  Nice.

--

Adam

[dfafard]

Thanks Adam.

Ya, was hoping for 3.8. It seems 3.6 can not open on iPad. I swapped out 3.8 but formatting color is broken. So I am using the excellent Ben Nadel POIUtility and seems to be great so far.

Thanks again for checking.

Dave

[Guest]

Does Ben's POIUtility do autofilter?  I tried again with POI 3.9 and the color formatting still breaks the spreadsheet output.  If I remove any formatting involving fontsize, fgcolor and color, it creates the spreadsheet with autofilter.  I even tried going back to 3.7 which is when autofilter was introduced and no luck.

Still can't get over the fact that CF10 still ships with POI 3.6 beta-1.

Thanks,

Jeff