is this the latest build from trunk or where can i get it?
2012/10/17 Hans Maulwurf <[email protected]> > i use poi-3.8-20120326.jar > > > 2012/10/17 Yegor Kozlov <[email protected]> > >> which version of POI are you using? Your code runs without errors with >> the latest build from trunk. >> >> >> >> On Wed, Oct 17, 2012 at 3:28 PM, Hans Maulwurf >> <[email protected]> wrote: >> > Sure, maybe it's too simple to solve it by myself :P >> > >> > here is the test-code: >> > >> > HSSFWorkbook wb = new HSSFWorkbook(); >> > >> > HSSFSheet sheet1 = wb.createSheet("first"); >> > HSSFSheet sheet2 = wb.createSheet("second"); >> > HSSFSheet sheet3 = wb.createSheet("third"); >> > HSSFSheet sheet4 = wb.createSheet("fourth"); >> > >> > HSSFRow row11 = sheet1.createRow(0); >> > HSSFRow row12 = sheet1.createRow(1); >> > HSSFRow row13 = sheet1.createRow(2); >> > >> > HSSFRow row21 = sheet2.createRow(0); >> > HSSFRow row22 = sheet2.createRow(1); >> > HSSFRow row23 = sheet2.createRow(2); >> > >> > HSSFRow row31 = sheet3.createRow(0); >> > HSSFRow row32 = sheet3.createRow(1); >> > HSSFRow row33 = sheet3.createRow(2); >> > >> > HSSFRow row41 = sheet4.createRow(0); >> > HSSFRow row42 = sheet4.createRow(1); >> > HSSFRow row43 = sheet4.createRow(2); >> > >> > row11.createCell(0).setCellValue("first1"); >> > row11.createCell(1).setCellValue("first2"); >> > row11.createCell(2).setCellValue("first3"); >> > row12.createCell(0).setCellValue("body"); >> > row12.createCell(1).setCellValue("body"); >> > row12.createCell(2).setCellValue("body"); >> > row13.createCell(0).setCellValue("body"); >> > row13.createCell(1).setCellValue("body"); >> > row13.createCell(2).setCellValue("body"); >> > >> > row21.createCell(0).setCellValue("head1"); >> > row21.createCell(1).setCellValue("head2"); >> > row21.createCell(2).setCellValue("head3"); >> > row22.createCell(0).setCellValue("body_sec"); >> > row22.createCell(1).setCellValue("body_sec"); >> > row22.createCell(2).setCellValue("body_sec"); >> > row23.createCell(0).setCellValue("body_sec"); >> > row23.createCell(1).setCellValue("body_sec"); >> > row23.createCell(2).setCellValue("body_sec"); >> > >> > row31.createCell(0).setCellValue("head1"); >> > row31.createCell(1).setCellValue("head2"); >> > row31.createCell(2).setCellValue("head3"); >> > row32.createCell(0).setCellValue("body_thrd"); >> > row32.createCell(1).setCellValue("body_thrd"); >> > row32.createCell(2).setCellValue("body_thrd"); >> > row33.createCell(0).setCellValue("body_thrd"); >> > row33.createCell(1).setCellValue("body_thrd"); >> > row33.createCell(2).setCellValue("body_thrd"); >> > >> > row31.createCell(0).setCellValue("head1"); >> > row31.createCell(1).setCellValue("head2"); >> > row31.createCell(2).setCellValue("head3"); >> > row32.createCell(0).setCellValue("body_frth"); >> > row32.createCell(1).setCellValue("body_frth"); >> > row32.createCell(2).setCellValue("body_frth"); >> > row33.createCell(0).setCellValue("body_frth"); >> > row33.createCell(1).setCellValue("body_frth"); >> > row33.createCell(2).setCellValue("body_frth"); >> > >> > >> > wb.setRepeatingRowsAndColumns(0, -1, -1, 0, 0); >> > >> > wb.setRepeatingRowsAndColumns(1, -1, -1, 0, 0); >> > >> > wb.setRepeatingRowsAndColumns(2, -1, -1, 0, 0); >> > >> > wb.setRepeatingRowsAndColumns(3, -1, -1, 0, 0); //this is the >> bad >> > line >> > //if I remove >> this >> > line, everything works fine >> > //if it's >> there, I >> > get a name conflict >> > >> > FileOutputStream fileOut = new >> > >> FileOutputStream("/home/muench/Arbeitsfläche/transfers/Test_RepeatingRowsAndColumns.xls"); >> > wb.write(fileOut); >> > fileOut.close(); >> > >> > >> > Maybe you can workaround. Thanks for your help :) >> > >> > >> > >> > 2012/10/17 Yegor Kozlov <[email protected]> >> > >> >> can you narrow it down to a simple failing test case ? >> >> >> >> On Tue, Oct 16, 2012 at 5:42 PM, Hans Maulwurf >> >> <[email protected]> wrote: >> >> > creating everything from scratch >> >> > >> >> > >> >> > 2012/10/16 Yegor Kozlov <[email protected]> >> >> > >> >> >> are creating a new workbook from scratch or modifying a template ? >> >> >> >> >> >> >> >> >> >> >> >> On Tue, Oct 16, 2012 at 5:22 PM, Hans Maulwurf >> >> >> <[email protected]> wrote: >> >> >> > Hello, >> >> >> > >> >> >> > I want to set setRepeatingRowsAndColumns for each sheet the same. >> I >> >> >> always >> >> >> > use setRepeatingRowsAndColumns(i, -1, -1, 0, 0) (counting i in a >> loop) >> >> >> but >> >> >> > when opening the xls, a name conflict (DruckTitel) is shown?? >> where >> >> can I >> >> >> > set the name of the DruckTitel (i guess it's print area?) It's >> >> confusing >> >> >> > because this method doesn't ask for a name :( >> >> >> > >> >> >> > thanks for your help & greetings, >> >> >> > >> >> >> > Hans >> >> >> >> >> >> >> --------------------------------------------------------------------- >> >> >> To unsubscribe, e-mail: [email protected] >> >> >> For additional commands, e-mail: [email protected] >> >> >> >> >> >> >> >> >> >> --------------------------------------------------------------------- >> >> To unsubscribe, e-mail: [email protected] >> >> For additional commands, e-mail: [email protected] >> >> >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> >> >
