Bug 46800 - No Workbook.getRepeatingRowsAndColumns method?
Summary: No Workbook.getRepeatingRowsAndColumns method?
Status: RESOLVED DUPLICATE of bug 53500
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.5-dev
Hardware: PC Linux
: P3 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2009-03-04 12:47 UTC by Alan Ramsey
Modified: 2015-05-18 20:16 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Alan Ramsey 2009-03-04 12:47:56 UTC
I hope this is the correct place for this, if it is not, please point me elsewhere.

Using the POI 3.4 beta 4 build I have created a utility to convert Excel Spreadsheets from Excel 97/HSSF format to the Excel 2007/XSSF format and vice versa.  Its purpose is to automate the conversion of spreadsheets in real timeon on a Linux system. Most of our spreadsheets are pretty basic (no charts, pivot tables, or macros) and this solution works really well.

However I ran into one minor "snag".  The org.apache.poi.ss.usermodel.Workbook interface, as well as the HSSFWorkbook and XSSFWorkbook classes all provide a setRepeatingRowsAndColumns() method, but there isn't the converse getRepeatingRowsAndColumns() method.

Is there a way, through the SS/HSSF/XSSF usermodels to discover the settings for the repeating rows and columns as found in Excel's File->PageSetup->Sheet ?  

If not shouldn't this be added to the API?  Typically I would think that if one can implement the "set", the "get" would be relatively straightforward to implement but I haven't actually looked at the lower level structures to be certain.  Maybe there is something I'm missing.

Please let me know if I need to provide more information, I would be glad to post my class I wrote that does this Excel version coversion if that would help clarify.
-alan ramsey
Comment 1 Dominik Stadler 2015-05-18 20:16:50 UTC
This is fixed via Bug 53500 by providing the methods 

Sheet.getRepeatingRows() and Sheet.getRepeatingColumns(), 

i.e. the methods were added to the Sheet and it's implementations.

*** This bug has been marked as a duplicate of bug 53500 ***