poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 46742] New: Remaining functionality for Sheet.shiftRows()
Date Fri, 20 Feb 2009 03:36:14 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=46742

           Summary: Remaining functionality for Sheet.shiftRows()
           Product: POI
           Version: 3.5-dev
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: minor
          Priority: P5
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: josh@gildedtree.com


The set of adjustments that potentially need to be done by shiftRows() is very
large.  Currently, POI's implementation covers the most commonly needed
adjustments, but is nonetheless incomplete.

This bugzilla has been created to outline the functionality still missing from
shiftRows(). As I understand, here is the full list of potential adjustments:

 - Cell Values
 - Cell Formats (+row heights etc)
 - Merged Cells
 - Cell Comments
 - Print Areas
 - Active/selected cells
 - Page Breaks
 - Row Groupings (needed?)
 - Formulas
    - Cell formulas
    - Defined names
    - Conditional formats
    - Data validations
    - VB/Form object formula properties e.g.
EmbeddedObjectRefSubRecord.field_2_refPtg

Does anyone have anything to add/remove to this list?


Next, POI's current behaviour should be determined.  From what I understand,
HSSF has slightly better coverage. XSSF does not adjust comments, page breaks
or conditional formats. Neither HSSF nor XSSF adjust print areas,
active/selected cells, row groupings, defined names, data validations, VB/form
object formula properties.
It would probably be a good idea to update the javadoc to reflect our
understanding.

The remaining functionality needs to be prioritised.  I would suggest the
following (according to perceived usefulness):

 - Defined names
 - Conditional formats
 - Data validations
 - Print Areas
 - Page Breaks
 - Cell Comments
 - Row Groupings
 - VB/Form object formula properties
 - Active/selected cells

Future enhancement requests may bump the priorities.  Some items may get done
out of order due to relative ease.

This record may remain open for a long time, hence the severity and priority
have been set low.  Work on any one of these items probably should be tracked
in separate bugzilla records which can be referenced here.

-- 
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


Mime
View raw message