And double check that all your POI jars in the class path are from the same
version.
You could try cleaning and running your project from
ant/maven/gradle/whatever your project is built with to determine if your
IDE is referencing other jars or missing jars that are causing the cast
errors.
On Fri, Mar 30, 2018, 22:58 Dominik Stadler <dominik.stad...@gmx.at> wrote:
> Hi,
>
> Sounds like a messed up classpath in Eclipse or some other problem with the
> IDE, I would start in the project settings where the libraries are
> configured to check if poi-ooxml-* is still listed correctly there as well.
>
> Dominik.
>
> On Fri, Mar 30, 2018 at 9:44 PM, Joltes, Richard <rej...@g.harvard.edu>
> wrote:
>
> > Hello all,
> >
> > New subscriber, and I can't see anything in the archives so I hope this
> > hasn't been discussed before. I have an application that uses the SXSSF
> > style sheets, and which was working just fine until I reopened the
> project
> > today. Now it's showing lots of type-mismatch errors, and I've no idea
> why.
> > Rough outline:
> >
> > 1) instantiate an SXSSF workbook (protected SXSSFWorkbook wb;)
> > 2) create a matching sheet (protected SXSSFSheet sheet1;)
> >
> > But then, when I try to instantiate the sheet the fun starts
> >
> > sheet1 = wb.createSheet("sheet1");
> >
> > Here, Eclipse is telling me to add a cast to SXSSFSheet, which makes no
> > sense since that's how the sheet was created in the first place.
> >
> > From then on it's all the same --
> >
> > SXSSFRow r = sheet1.createRow(0); same type/cast error
> >
> > Creating an SXSSF cell obviously does the same thing.
> >
> > Even odder, all the previously working ColorScaleFormatting and other
> color
> > oriented code is showing up as undefined. Again, all this code was
> working
> > last time I had the project open. I've no explanation for this behavior.
> >
> > I was using 3.16, but just migrated to 3.17 and got the same behavior.
> >
> > Any ideas?
> >
> > Thx,
> >
> > Dick Joltes
> > Harvard University
> >
>
