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