AFAIK, the parser does not support that kind of a range assignment. When writing the "named ranges" parser, it appeared that it had wide ranging format support, but one is constantly surprised by the range (sic) of ways in which named ranges can be specified.
On Fri, 2004-05-14 at 15:07, Tony Harris wrote: > Sorry to be a pain, I have asked this question once before, never got a > reply and then the project went on hold. > > Question does POI support range names that cover more than one continuous > range of cells. I can access ranges for a single continuous set i.e. > =Sheet1!$C$7:$C$22 > > But get nothing when looking for a range like > =Sheet1!$E$9:$J$26,Sheet1!$L$17:$R$34 > > Any help would be greatly appreciated. > > Tony > > > *********************************************************************** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. Any unauthorised distribution or copying is strictly > prohibited. > > Whilst Cedar Software Ltd takes steps to prevent the transmission of > viruses via e-mail, we can not guarantee that any email or > attachment is free from computer viruses and you are strongly > advised to undertake your own anti-virus precautions. > > Cedar Software Ltd grants no warranties regarding performance, > use or quality of any e-mail or attachment and undertakes no > liability for loss or damage, howsoever caused. > > CedAr is a leading UK supplier of Financial, eProcurement, Performance Management > and, following the recent acquisition of Goldenhill Computer Systems Ltd, HR and > Payroll software. Cedars solutions deliver increased capabilities and offer a direct > and measurable financial return on investment. The company has a customer base of > more than 500 organisations in both the public and private sector. > Particular sector strengths include Airlines, Business Services, > Education, Emergency Services, Financial Services, Government, Health, Local > Authorities, Not for Profit, Retail and Utilities. For more > information, please visit www.cedar.com > 2003 CedAr Software Ltd. All Rights Reserved. > Cedar Software Ltd. Incorporation number 3214465 > *********************************************************************** > > > --------------------------------------------------------------------- > 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]
