DO NOT REPLY [Bug 46742] Remaining functionality for Sheet.shiftRows()

[bu...@apache.org]

https://issues.apache.org/bugzilla/show_bug.cgi?id=46742


Yegor Kozlov <ye...@dinom.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |yegor@dinom.ru




--- Comment #1 from Yegor Kozlov <ye...@dinom.ru>  2009-02-19 23:44:53 PST ---
I would add these (in priority order):

 - Repeating rows and columns (workbook.setRepeatingRowsAndColumns )
 - Hyperlinks attached to cells
 - Anchors of drawings (needed?)
   - pictures and shapes anchored to cells
   - drop-down lists with the data set as cell area reference
 - pivot areas ( we should at least check that shiftRows doesn't break .xls
with pivot areas)
 - Excel charts (I'm not sure what this involves)

shiftRows is getting complicated. It includes more functionality than a single
method can fit. It may be worth putting the logic in a class and use in
HSSF-XSSF, or make this class abstract and have HSSF and XSSF implement a
method per each operation. 

All common functionality should be tested in terms of common
org.apache.poi.ss.usermodel.* interfaces. This should be true for common
HSSF-XSSF tests in general, not only for shiftRows. There is an attempt to do
that in org.apache.poi.ss.usermodel.BaseTestSheetShiftRows and I expect that we
will follow this approach.

As to priorities, I agree that the highest one is Defined names. Without it
shiftRows does not guarantee the consistence of sheet formulas. The other items
can be shuffled. 
XSSF does not yet support Conditional formats and Data validations and I doubt
it will be included in 3.5-final. Also, XSSF does not yet process VB/Form
formulas. 

My adjusted list:

 - Defined names (XSSF and HSSF)
 - Conditional formats (HSSF)
 - Data validations (HSSF)
 - Print Areas (XSSF and HSSF)
 - Repeated Rows / Columns (XSSF and HSSF)
 - Page Breaks (XSSF and HSSF)
 - Cell Comments (XSSF and HSSF)
 - Hyperlinks (XSSF and HSSF)
 - Row Groupings (XSSF and HSSF)
 - VB/Form object formula properties (HSSF)
 - Active/selected cells (XSSF and HSSF)

Yegor

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