Bug 47815 - Implementation of HSSFCell#getRichStringCellValue() does not match its contract
Summary: Implementation of HSSFCell#getRichStringCellValue() does not match its contract
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.2-FINAL
Hardware: PC Linux
: P2 normal with 1 vote (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-09-10 03:39 UTC by Grzegorz Bloch
Modified: 2010-06-04 11:58 UTC (History)
0 users


Attachments
failing test for HSSFCell#getRichStringCellValue() (2.08 KB, application/zip)
2009-09-10 03:39 UTC, Grzegorz Bloch 		Details
View All 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 Grzegorz Bloch 2009-09-10 03:39:42 UTC 
Created attachment 24244 [details]
failing test for HSSFCell#getRichStringCellValue()

The contract of HSSFCell#getRichStringCellValue() specifies that "For
formulaCells that are not string Formulas, we return empty String".

What actually happens is that for numeric formula an IllegalArgumentException
is thrown. (See attached test).
Comment 1 Nick Burch 2010-06-04 11:58:41 UTC 
Documentation fixed in r951466 - it now reflects the long-standing behaviour

I've also added a test that ensures that both xssf and hssf do the same thing in these cases