Bug 46800

Summary: No Workbook.getRepeatingRowsAndColumns method?
Product: POI Reporter: Alan Ramsey <alnramz>
Component: HSSFAssignee: POI Developers List <dev>
Severity: enhancement    
Priority: P3    
Version: 3.5-dev   
Target Milestone: ---   
Hardware: PC   
OS: Linux   

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