https://issues.apache.org/bugzilla/show_bug.cgi?id=46742
Yegor Kozlov <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from Yegor Kozlov <[email protected]> 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: [email protected] For additional commands, e-mail: [email protected]
