Summary: | Cells which control radio buttons get reset when read by Excel | ||
---|---|---|---|
Product: | POI | Reporter: | Gareth Smith <gareth.smith> |
Component: | HSSF | Assignee: | POI Developers List <dev> |
Status: | NEW --- | ||
Severity: | normal | CC: | gareth.smith |
Priority: | P2 | ||
Version: | 2.5-FINAL | ||
Target Milestone: | --- | ||
Hardware: | Other | ||
OS: | All | ||
Attachments: |
XLS file configured to expose this behaviour
Test class which will expose the problem |
Description
Gareth Smith
2006-08-18 10:39:33 UTC
Created attachment 18732 [details]
XLS file configured to expose this behaviour
Created attachment 18733 [details]
Test class which will expose the problem
I forgot to mention: This test uses POI 2.5.1 final (poi-2.5.1-final-20040804.jar). I tried using the latest POI alpha (poi-3.0-alpha2-20060616.jar) however this caused Excel to fail to load the file propely and "repair" the workbook, resulting in the form controls and all cell formatting being lost. Still happens with current poi 3.11-beta2/trunk, one difference in the BiffViewer output seems to be the type of record for the number-value: Originally it is a RKRecord Offset=0x00001077(4215) recno=192 sid=0x027E size=0x000A(10) [RK] .row = 0x0001 .col = 0x0001 .xfindex= 0x001E .value= 2.0 [/RK] but POI only supports reading those and thus converts this to a Offset=0x0000105E(4190) recno=192 sid=0x0203 size=0x000E(14) [NUMBER] .row = 0x0001 .col = 0x0001 .xfindex= 0x001E .value= 3 [/NUMBER] Not sure if this is the culprit here, but it seems to be related as no other big change is visible int he Biff-output |