[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-user
Subject:    RE: Opening HSSFSheets in MS Project - Is it a bug?
From:       "Andrea Nenni" <Andrea.Nenni () methodpark ! de>
Date:       2004-01-27 15:39:36
Message-ID: 005e01c3e4eb$c4bcc960$46010a0a () cl000894
[Download RAW message or body]

Hello again,

if anybody happens to stumble across the same MS Project problem that
I had:
I just added what I consider the solution to the problem as bug report 
and patch to the POI bugzilla database. The bug number is 26465.

Thanks for your interest.

Andrea


> -----Original Message-----
> From: Andrea Nenni [mailto:Andrea.Nenni@methodpark.de] 
> Sent: Friday, January 23, 2004 9:45 AM
> To: 'POI Users List'
> Subject: Opening HSSFSheets in MS Project - Is it a bug?
> 
> 
> Hello everybody,
> 
> I still could not find a solution for my MS Project import problem.
> 
> Perhaps I shoud give you some more detailed information:
> 
> I create Excel sheets with POI and open them with Microsoft Project.
> Each row in my sheet corresponds to a "task" in MS Project. (You can  
> define special mappings to and from MS Excel in MS Project.)
> 
> Everything works fine, when the number of rows in the created Excel
> file is odd. However, when the row number is even, MS Project 
> will just
> ignore the last row, i.e. one "task" is missing. There seems 
> to be some
> difference in the file ending between HSSFSheets with odd and 
> even row 
> numbers. Im still not sure, if this is a bug or just part of 
> Microsoft's 
> definition of the MS Excel format.
> 
> Next, I tried to cheat MS Project, by using an additional 
> empty row at 
> the end of the sheet. Consequentially, MS Project shows an 
> empty "task"
> at the bottom.
> 
> What I found somehow amazing: When I remove the additional 
> row immediately
> after adding it in POI, MS Project still shows the additional "task".
> 
> Has anybody an idea how to work around this problem?
> Please help me.
> 
> Andrea
> 
> 
> ---------------------------------------------------------------------
> 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

[prev in list] [next in list] [prev in thread] [next in thread]