poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 29957] New: - HSSFSheet removeRow() & shiftRows() do not deal with hyperlinks
Date Wed, 07 Jul 2004 18:28:15 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=29957>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=29957

HSSFSheet removeRow() & shiftRows() do not deal with hyperlinks

           Summary: HSSFSheet removeRow() & shiftRows() do not deal with
                    hyperlinks
           Product: POI
           Version: 2.5
          Platform: PC
        OS/Version: Other
            Status: NEW
          Severity: Major
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: zhaoweiusa@yahoo.com


HSSFSheet removeRow(HSSFRow row) does not actually remove the row, instead it 
clears the entire row. That is not a big problem. I can bear with that. However 
I just discovered that if there is a cell in that row that has a real hyperlink 
(not a formula), that cell will become empty but still will have that hyperlink 
associated permanently. Besides, HSSFSheet's shiftRows(int startRow, int 
endRow, int n) does not actually shift hyperlinks.

Now, here is the real problem. I have an input binary EXCEL file with ten rows. 
It has hyperlinks in its second column. So, for example, cell B1 points to 
link1, cell B2 points to link2, etc., cell B10 points to link10. If I use 
removeRow() to remove the first 9 rows and use shiftRow() to shift the 10th row 
to the first row. I then output an EXCEL file. Since the hyperlinks in the 
second columns actually do not go away with the removeRow() method and shiftRows
() does not actually move hyperlinks, in the output EXCEL file, B1 (used to be 
B10) now has a hyperlink that points to link1 instead of link10.

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


Mime
View raw message