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