Named range

2007-05-24 Thread Philipp.Landmann
Hey everybody! It´s even more fun now with my named range problem. When I give the sheets these names: mWb.setSheetName(0, first sheet); mWb.setSheetName(1, second sheet); mWb.setSheetName(2, third sheet); It´s no problem. But when I give them these names or any other: mWb.setSheetName(0

named range

2007-05-21 Thread Philipp.Landmann
this message: Name darf integriertem Namen nicht gleichen It seems like the named range for the print title is injured. How can I solve this problem? Best regards, Philipp sdm - 25 Jahre Kompetenz im Software-Engineering -- Philipp Landmann mailto:[EMAIL PROTECTED] sdm AG http

Named Range / Formula

2006-04-19 Thread Thompson, Marshall
In the excel UI, I can manually create a named range with the formula: =OFFSET(Sheet1!$B$30,,,1,COUNTA(Sheet1!$B$30:$L$30)) This lets my range refer to any cells in row 30 between B and L that have data. I am generating a spreadsheet with Java / POI. I would like to do the same thing

AW: How to modify cells using the named range

2003-04-02 Thread Clauss, Arne
quite nice. Where's the fault? Any help is welcome! Regards, Arne -Ursprüngliche Nachricht- Von: Danny Mui [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 25. März 2003 19:04 An: POI Users List Betreff: Re: How to modify cells using the named range That method simply gives you