Bug 45234

Summary: Conditional formatting formula breaks after saving with hssf
Product: POI Reporter: Bernhard <bernhard.schwager>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: major    
Priority: P2    
Version: 3.0-dev   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Attachments: Cell references from the conditional formating aren’t at the same place after saving.

Description Bernhard 2008-06-19 01:52:13 UTC
Created attachment 22141 [details]
Cell references from the conditional formating aren’t at the same place after saving.

If a conditional formatting formula contains a cell reference, the reference points to an different cell after saving the excel file with poi.

Look at the attached excel file: After saving the file with poi the conditional formatting from cells B4 and C5 changed from =B3=1 and =C3=1 to =A65536=1
Comment 1 Josh Micich 2008-06-19 12:13:04 UTC
Fixed in svn 669658 
Comment 2 Josh Micich 2009-11-13 16:02:00 UTC
svn r669658