Hi Oliver,
Excel uses the formula's to save their area (reference).
There are 2 ptg that i found : Area3DPtg , Ref3DPtg.
Libin Roman
----- Original Message -----
From: "Andrew C. Oliver" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 18, 2002 5:25 PM
Subject: Re: Fw: Named Ranges
> Perhaps Libin can provide patches that will cause the existing patches
> to meet the standards, provided patches for the HSSF documentation and
> we can work together to figure out how to adapt it to a changing Ptg
> structure.
>
> I don't see why we can't get these in there immediately after 1.5 at the
> very least.
>
> Libin you have to understand, we can't bless formulas as
> production-level code. Because its not. Anyone who enables HSSF's
> formula support does so at their own peril. I'm still a bit unclear as
> to why named ranges depend on PTGs... I'll need to take a closer look
> at this patch in the coming days. Unfortunately, I may not have
> sufficient cycles until around early next week. While as an unpaid
> volunteer I cannot commit to any solid timelines, I am personally
> committed to integrating this work into HSSF as soon as we're able.
>
> After the 1.5 release we'll put out a new dev release with all
> experimental code enabled rather quickly. (for all of our sanities)
>
> One note: When I go in an Excel spreadsheet and name a range of
> cells.....in general it does not create any formulas.
>
> Thoughts?
>
> -Andy
>
> Libin Roman wrote:
>
> > Hello Glen,
> >
> >
> >
> > This patches I wrote are extremly important to the company I work.
> > We've been working on the named-range patch for the last two weeks and
> > we'd like to understand when do you expect this to enter a release ?
> >
> > Can't it be added as an experimental part (as the formulas?) ??
> >
> >
> >
> > Please advise, we must understand when will this enter a release.
> >
> >
> >
> > Best Regards,
> >
> > Libin
Roman
> >
> > ----- Original Message -----
> >
> > * From:* Glen Stampoultzis <mailto:[EMAIL PROTECTED]>
> >
> > * To:* [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
> >
> > * Sent:* Thursday, April 18, 2002 3:21 PM
> >
> > * Subject:* Re: Named Ranges
> >
> >
> >
> >
> > Hi Libin, I've got some bad news for you. I've been talking with
> > Andy about the Ptg records. Apparently that whole formula package
> > is considered experimental and is being disabled completely in the
> > 1.5 release. This means I can't apply your patch yet and is
> > probably the cause of some of the problems I've had.
> >
> >
> >
> > We are just waiting for the current dev build to be tested further
> > by our users then 1.5 full release should be right to go and the
> > formula stuff will be readded (although it will still be
> > experimental and subject to change).
> >
> >
> >
> > Sorry for the inconvenience.
> >
> >
> >
> > Regards,
> >
> >
> >
> > Glen Stampoultzis (TriNexus Pty Ltd)
> > +63 3 9753-6850 0402 835 458
> > ICQ: 62722370 EMail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> >
> > ----- Original Message -----
> >
> > * From:* Libin Roman <mailto:[EMAIL PROTECTED]>
> >
> > * To:* [EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]> ; Glen Stampoultzis
> > <mailto:[EMAIL PROTECTED]>
> >
> > * Sent:* Thursday, April 18, 2002 7:07 PM
> >
> > * Subject:* Re: Named Ranges
> >
> >
> > Hi,
> >
> >
> >
> > Here I did some small Named Range Example
> >
> >
> >
> > POIFSFileSystem fs = null;
> > HSSFWorkbook wb = null;
> > try {
> > fs = new POIFSFileSystem(new
> > FileInputStream("c:\\1.xls"));
> > wb = new HSSFWorkbook(fs);
> > } catch (FileNotFoundException ex){
> > } catch (IOException ex){
> > }
> >
> > file://Getting NAmed Range
> > HSSFName namedRange1 = wb.getNameAt(0);
> > //Getting it sheet name
> > String sheetName = namedRange1.getSheetName();
> > //Getting its reference
> > String referece = namedRange1.getReference();
> >
> > //Creating new Named Range
> > HSSFName newNamedRange = wb.createName();
> >
> > //Getting Sheet Name for the reference
> > sheetName = wb.getSheetName(0);
> >
> > //Setting its name
> > newNamedRange.setNameName("RangeTest");
> > //Setting its reference
> > newNamedRange.setReference(sheetName + ".$D$4:$E$8");
> >
> >
> > try {
> > FileOutputStream fileOut = new
> > FileOutputStream("c:\\1.xls");
> > wb.write(fileOut);
> > fileOut.close();
> > } catch (FileNotFoundException ex){
> > } catch (IOException ex){
> > }
> >
> >
> >
> > I hope its says it all :))
> >
> >
> >
> > Libin
> > Roman
> >
> > ----- Original Message -----
> >
> > * From:* Glen Stampoultzis <mailto:[EMAIL PROTECTED]>
> >
> > * To:* [EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>
> >
> > * Sent:* Wednesday, April 17, 2002 5:02 PM
> >
> > * Subject:* Re: Named Ranges
> >
> >
> > Okay, I have applied that patch to my local copy.
> > Unfortunately the patches did not contain unit tests,
> > documentation or examples so I'm adding those and it will
> > not be available until that's finished. Thanks for your
> > work... looks good so far.
> >
> >
> >
> > Regards,
> >
> >
> >
> > Glen
> >
> >
> >
> > ----- Original Message -----
> >
> > * From:* Libin Roman <mailto:[EMAIL PROTECTED]>
> >
> > * To:* [EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>
> >
> > * Sent:* Tuesday, April 16, 2002 5:33 PM
> >
> > * Subject:* Named Ranges
> >
> >
> > Hi ,
> >
> >
> >
> > I have sent the Named Ranges patch to the bugzilla.
> >
> > Hope to see it soon in the cvs :)))
> >
> >
> >
> > From HSSFWorkbook you can create a new named range.
> > From HSSFWork you can get the HSSFName (high level of
> > named range) by name or by index , which from you get
> > get the reference or to set it.
> >
> >
> >
> >
> >
> >
> >
> >
> > Hope you like it :)),
> >
> >
> > Libin Roman
> >
> >
> >
>
>
>
