You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2008/05/11 11:05:22 UTC
DO NOT REPLY [Bug 41027] [INFO NEEDED]
Sorting numeric columns with blank values
https://issues.apache.org/bugzilla/show_bug.cgi?id=41027
Josh Micich <jo...@gildedtree.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
Summary|[INFO NEEDED]Sorting columsn|[INFO NEEDED]Sorting numeric
|with numeric values |columns with blank values
--- Comment #2 from Josh Micich <jo...@gildedtree.com> 2008-05-11 02:05:22 PST ---
You should be able to set any blank cells explicitly:
cell.setCellType(HSSFCell.CELL_TYPE_BLANK);
Excel displays such cells empty even if number formatting is applied.
Excel seems to sort blank values to the bottom regardless of whether the
direction is ascending or descending. BTW - empty text cells (which look like
blank cells) sort to the top when the direction is descending.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org