Re: Problem with HSSF shiftRows()

[Danny Mui]

we try to shift all the formulas based on their row indexes.  if the ptg 
isn't supported we leave it alone since we have no idea how to move the 
index.

i dont have my excel book handy so if u can log this into bugzilla 
somebody (or yourself!! nothing better than immediate results!!) can 
create the Ptg support.  Ptg support should be pretty easy :)

[EMAIL PROTECTED] wrote:
I need to shift several rows in a workbook and insert a new row before the shifted 
rows. The rows to be shifted contain some formulas that reference other shifted rows, 
therefore the formula needs to be updated. The shift causes several warnings and the 
rows are not shifted:
//book is an HSSFWorkbook
HSSFRow row = book.getSheet("Sheet1");
sheet.shiftRows(11, sheet.getLastRowNum(), 1);
//out is a FileOutputStream to the xsl file.
book.write(out);
[WARNING] Unknown Ptg 2a (42) at cell (1,35)
[WARNING] Unknown Ptg 2c (60) at cell (3,12)
[WARNING] Unknown Ptg 3c (60) at cell (3,13)
etc.....


---------------------------------------------------------------------
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]