sort problem with spreadsheet - poi

[Kanna Akella via JavaKB.com]

used poi to generate spreadseet out of data coming from db/2
data-sort works in some cases and does not work in others.

Tried changing the cell type to CELL_TYPE_NUMERIC, but had no luck.
Any ideas/pointers, appreciated...

 

[Fred]

used poi to generate spreadseet out of data coming from db/2
data-sort works in some cases and does not work in others.

Tried changing the cell type to CELL_TYPE_NUMERIC, but had no luck.
Any ideas/pointers, appreciated...

I suggest checking the quality of your data. Often when numbers have
trailing spaces spreadsheet functions don't work as expected. Worst
case, potentially write a macro to clean and sort the data (and call
the macro from Jacob).

-Fred