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