Re[2]: Limitations on cell ranges?

[Roger Misteli <ro...@abacus.ch>]

Whoah, thats a bummer, but I can understand it. Thanks for the answer


Centuries ago, Nostradamus forsaw that at 
Wed, 26 May 2004 13:26:15 +0100 Tony Harris <To...@Cedar.com> would write this:

> I asked this same question only a few weeks ago, and was told that due to
> the various ways that excel can handle in terms of named ranges only the
> simplest single range of cells was supported.
> 
> Quote "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. "
> 
> 
> 
> -----Original Message-----
> From: Roger Misteli [mailto:roger.misteli@abacus.ch]
> Sent: 26 May 2004 13:19
> To: poi-user@jakarta.apache.org
> Subject: Limitations on cell ranges?
> 
> 
> Hiyas,
> 
> I try to create a multiple rows, multiple cells named range, however,
> Excel doesn't seem to create it really.
> 
> I don't use any template file or read an excel file to modify it, but
> create a new named range. Everything works with single rows/columns, but
> when I use something like this for HSSFName.setReference(), Excel
> doesn't seem to accept it (no error message though, it simply doesn't
> work):
> 
> subjob_01!$A$6:$C$14,subjob_01!$D$15:$D$20,subjob_01!$D$27:$D$32,subjob_01!$
> G$14:$H$26,subjob_01!$D$4:$H$8,subjob_01!$G$9,subjob_01!$E$13:$E$14
> 
> (that actual string I use is way longer, but has exactly the same format).
> 
> Now I'm not sure, if this is my bug or POI's or Excel's. Does anyone
> have a clue for me here? 
> 
> Thanks in advance,
> Rog
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 
> 
> *********************************************************************** 
> 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. Cedar’s 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: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org


/*
 * Roger Misteli - ABACUS Research AG
 * email: roger.misteli@abacus.ch (PGP key available)
 * "If you think the problem is bad now, just wait until we've solved it."
 */



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org