File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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
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"
 
Similar Threads
exception while creating a new instance of SXSSFWorkbook
Cross referencing of excel sheets in jxl
#REF! error when trying to access cell of another Sheet in same workbook.
Formula not rendered with POI 3.6
Best strategy for handling actions across multiple windows?