Hello All,
I added conditional formatting objects to my generated excel file
using MS Excel application. I then inspected the file using
BiffViewer. The CF records created by the code look like:
Offset=0x00010B95(68501) recno=711 sid=0x01B0 size=0x0016(22)
[CFHEADER]
.id = 1b0
.numCF = 1
.needRecalc = false
.enclosingCellRange= org.apache.poi.hssf.util.CellRangeAddress [254,
254, 8, 9]
.cfranges=[org.apache.poi.hssf.util.CellRangeAddress [254, 254, 8, 9]]
[/CFHEADER]
Offset=0x00010BAF(68527) recno=712 sid=0x01B1 size=0x0098(152)
[CFRULE]
OPTION FLAGS=0x243bffff
while the CF record created by the excel application looks like:
Offset=0x00010C4B(68683) recno=713 sid=0x01B0 size=0x0016(22)
[CFHEADER]
.id = 1b0
.numCF = 1
.needRecalc = true
.enclosingCellRange= org.apache.poi.hssf.util.CellRangeAddress [4, 4,
6, 6]
.cfranges=[org.apache.poi.hssf.util.CellRangeAddress [4, 4, 6, 6]]
[/CFHEADER]
Offset=0x00010C65(68709) recno=714 sid=0x01B1 size=0x0022(34)
[CFRULE]
OPTION FLAGS=0x203bffff
The difference is that the code does not set the .needRecalc to true;
while excel sets it to true. Any idea which patch would fix this? I
rememer seeing a discussion on formula (re)evaluation on excel files
generated by POI. Could it possibly be related to this?
On Wed, Dec 30, 2009 at 3:29 PM, Josh Micich <[email protected]> wrote:
> Did you check whether the problem exists in POI 3.6? If so, it's
> possible that your problem was fixed as a side effect of some other
> bug fix. Try reviewing the history of changes in related files
> (CFHeaderRecord, CFRuleRecord, CFRecordsAggregate,
> ConditionalFormattingTable, HSSFConditionalFormatting etc)
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
