Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes Other Open Source Projects and the fly likes Apache POI Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Apache POI" Watch "Apache POI" New topic

Apache POI

Johannes Uhlmann

Joined: May 25, 2011
Posts: 5


i got a question regarding to the class hierarchy of Cell and the possibility to implement Comparable.

There are HSSFCell implements Cell and XSSFCell implements Cell. I wanted the compareTo functionality for both, hence my idea was to design a class like abstract class MyCell implements Cell, Comparable<Cell>. So i could implement compareTo but omit the Cell functions. The problem is that MyCell is not a Cell. Available options: 1.) always cast if a Cell is needed 2.) extend HSSFCell as well as XSSFCell and implement Comparable for both. Are there more options?


edit: ;-)
Paul Clapham

Joined: Oct 14, 2005
Posts: 19973

Perhaps something like

Another option would be to forget about making a Cell comparable; you can compare a MyCell object to an XSSFCell object, because you wrote the code for MyCell, but you can't compare an XSSFCell object to a MyCell object because you didn't write the code for XSSFCell. A Comparator might be a better idea.
I agree. Here's the link:
subject: Apache POI
jQuery in Action, 3rd edition