Bug 57430 - XSSFName.setRefersToFormula throws exception for valid reference
Summary: XSSFName.setRefersToFormula throws exception for valid reference
Status: RESOLVED WORKSFORME
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.11-FINAL
Hardware: Macintosh All
: P2 regression (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-01-10 07:08 UTC by Jørn Ola Birkeland
Modified: 2015-09-13 21:04 UTC (History)
0 users


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jørn Ola Birkeland 2015-01-10 07:08:09 UTC 
The following code snippet will reproduce the error:

        XSSFWorkbook wb = new XSSFWorkbook();
        XSSFSheet sh = wb.createSheet("Sheet1");

        //applies to the entire workbook
        XSSFName name1 = wb.createName();
        name1.setNameName("FMLA");
        name1.setRefersToFormula("Sheet1!$B$3");

This works with version 3.10.1, but not 3.11.
Comment 1 Nick Burch 2015-01-13 09:58:24 UTC 
I've just added a unit test based on your code in r1651314, and it passes just fine!

Are you sure you're using the POI jars you think you are?
Comment 2 Dominik Stadler 2015-09-13 21:04:43 UTC 
Seems to work and no response for some months, therefore closing WORKSFORME.