https://issues.apache.org/bugzilla/show_bug.cgi?id=41027
Josh Micich <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
