Bug 45234 - Conditional formatting formula breaks after saving with hssf
Summary: Conditional formatting formula breaks after saving with hssf
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.0-dev
Hardware: PC Windows XP
: P2 major (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-06-19 01:52 UTC by Bernhard
Modified: 2009-11-13 16:02 UTC (History)
0 users


Attachments
Cell references from the conditional formating aren’t at the same place after saving. (13.50 KB, application/vnd.ms-excel)
2008-06-19 01:52 UTC, Bernhard 		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 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