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