poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bigwood, David" <dbigw...@metatomix.com>
Subject RE: AW: phantom cells?
Date Wed, 24 Mar 2004 21:44:02 GMT
There appears some sort of concept of blocking areas in Excel to cover this.
Each block of data seems to pad rows to the same length, but block to block
they may vary. I am looking at this problem right now for something I am
working on. May have more info later.
-DAB


> -----Original Message-----
> From: Ryan Crumley [mailto:ryan.crumley@whisperwire.com] 
> Sent: Wednesday, March 24, 2004 1:28 PM
> To: POI Users List
> Subject: RE: AW: phantom cells?
> 
> 
> Ive seen a situation where:
> 
> Row1 has 20 cells
> Row2 has 30 cells
> 
> Row2.getLastCellNum() = 30 and...
> Row1.getLastCellNum() = 30 (don't ask why)
> 
> -----Original Message-----
> From: Karl-Heinz Zengerle [mailto:karl-heinz.zengerle@sawag.com] 
> Sent: Wednesday, March 24, 2004 8:52 AM
> To: 'POI Users List'
> Subject: AW: AW: phantom cells?
> 
> Hi David.
> 
> Your item 2 was exactly the point with the last cell number. 
> It's error
> prone when reality and intuition differ.
> 
> Regards,	Karl-Heinz.
> 
> 
> -----Ursprüngliche Nachricht-----
> Von: Bigwood, David [mailto:dbigwood@metatomix.com] 
> Gesendet: Mittwoch, 24. März 2004 15:34
> An: POI Users List
> Betreff: RE: AW: phantom cells?
> 
> Couple of points here:
> 
> 1. There ARE entries for empty cells (no values) that have some
> formatting
> associated with them.
> 
> 2. Also, some functions that return index of cells in row return
> number+1 -
> this is apparently what the Excel spec dictates (I previously reported
> it as
> a bug and it was rejected for that reason).
> 
> -DAB
> 
> 
> > -----Original Message-----
> > From: Avik Sengupta [mailto:avik.sengupta@itellix.com] 
> > Sent: Wednesday, March 24, 2004 6:03 AM
> > To: POI Users List
> > Subject: Re: AW: phantom cells?
> > 
> > 
> > Lord Tennyson wrote this 1854, but it applies to working 
> with Excel as
> > well ;)
> > 
> > Theirs not to make reply,
> > Theirs not to reason why,
> > ......
> > 
> > But seriously, there are entries for many empty cells in an 
> > Excel file.
> > Dont ask why, but history of operations could be one reason. 
> > So you cant
> > depend on the index of a record in the file.. you can only go 
> > by the row
> > and col numbers inside the record. 
> > 
> > 
> > On Wed, 2004-03-24 at 16:27, Karl-Heinz Zengerle wrote:
> > > Hi world.
> > >  
> > > In a row containing 12 elements getLastCellNum() returns 12 
> > also I'ld
> > > expect 11 (because of being 0-based). Also there a phantom 
> > cell seems to
> > > be counted.
> > >  
> > > Regards,    Karl-Heinz.
> > >  
> > > 
> > > -----Ursprüngliche Nachricht-----
> > > Von: Karl-Heinz Zengerle [mailto:karl-heinz.zengerle@sawag.com] 
> > > Gesendet: Mittwoch, 24. März 2004 11:49
> > > An: poi-user@jakarta.apache.org
> > > Betreff: phantom cells?
> > >  
> > > Hi world.
> > >  
> > > In a row containing text in column A and column C and 
> > having explicitly
> > > deleted the other cells in the line the cell table for the 
> > row (in the
> > > debugger) shows me an entry for index 0 (which should be 
> > according to
> > > column A) and an entry for index 14 (according to the content
> > > corresponding to column C - intuitively I'ld expect this at 
> > index 2).
> > >  
> > > How can that be interpreted? Is the history of manipulation 
> > operations
> > > performed on that Excel file the reason for such a strange 
> > situation?
> > >  
> > > MfG 
> > > Karl-Heinz Zengerle
> > > ___________________________________________________
> > >  More than competence in Document Management 
> > > ___________________________________________________
> > > 
> > > SAW AG
> > > Waldmünchenerstr. 12
> > > 81549 München
> > > Tel.: ++49-89-68088368
> > > Fax: ++49-89-68088389
> > > www.sawag.com
> > > 
> > > ___________________________________________________
> > >  
> > 
> > 
> > 
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: poi-user-help@jakarta.apache.org
> > 
> > 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 
> 

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


Mime
View raw message