File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

wb.setSheetName exception : "not implemented yet"

salim chami

Joined: Nov 16, 2012
Posts: 2

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.
It is sorta covered in the JavaRanch Style Guide.
subject: wb.setSheetName exception : "not implemented yet"