wood burning stoves 2.0*
The moose likes Other Open Source Projects and the fly likes wb.setSheetName exception : Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "wb.setSheetName exception : "not implemented yet"" Watch "wb.setSheetName exception : "not implemented yet"" New topic
Author

wb.setSheetName exception : "not implemented yet"

salim chami
Greenhorn

Joined: Nov 16, 2012
Posts: 2
Hello,

I'm using apache poi for handling an excel file in which I have about 90 tabs with some 800 formulas on each tab.

The generation of the second half of the tabs is done automatically using the following code:




So far, so good. But the cloned tab contains formulas that reference cells in external tabs (in the same workbook).

When I rename the tab, I do this:




And then I have a beautiful exception:



In fact, it happens when poi re-evaluate all workbook's formulas.

the following method is executed (it's in the FormulaParser class) :



Parameter values :
formula: [1] January! # REF!
formulaType: 4
sheetIndex: -1! (which I do not understand ...)


He spends two times in this method, and I have twice the value [1] January! # REF! parameter in the formula. that throws the exception, the second time.

Do you have an idea to solve this problem.

Thank you very much.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: wb.setSheetName exception : "not implemented yet"