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

Win a copy of REST with Spring (video course) this week in the Spring forum!
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.
I agree. Here's the link:
subject: wb.setSheetName exception : "not implemented yet"
It's not a secret anymore!