Bug 47815

Summary: Implementation of HSSFCell#getRichStringCellValue() does not match its contract
Product: POI Reporter: Grzegorz Bloch <gtb-bugs.apache>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: 3.2-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: Linux   
Attachments: failing test for HSSFCell#getRichStringCellValue()

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