• Post Reply Bookmark Topic Watch Topic
  • New Topic

wb.setSheetName exception : "not implemented yet"  RSS feed

salim chami
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!