Bug 30862 - Support Excel Ptg 0x14 (percent)
Summary: Support Excel Ptg 0x14 (percent)
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: POI Overall (show other bugs)
Version: 2.5-FINAL
Hardware: PC All
: P3 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
: 39136 (view as bug list)
Depends on: 40024
Blocks:
  Show dependency tree
 
Reported: 2004-08-26 09:53 UTC by bart
Modified: 2006-07-28 22:02 UTC (History)
1 user (show)


Attachments
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 bart 2004-08-26 09:53:18 UTC 
When trying to read in our excel we got this warnings :
[WARNING] Unknown Ptg 14 (20) at cell (2,85)

When trying to figure out what was going wrong, we found in our excel file at 
that cell the following formula : 
=IF(CG3>=CF3,100%,0%)

If we remove the % signs in the formula and run again, the warnings are gone.
However the result is as expected, the value with % signs.
Comment 1 Avik Sengupta 2004-08-26 10:03:40 UTC 
14 is, as you can probably guess, ptgPercent. Its currently not implemented.
I'll get to it, but you should probably be OK with a workaround. The appearance
of a '%' sign in the result cell would have nothing to do with the return value
of the function, but would depend on the formatting of the cell.
Comment 2 Trejkaz (pen name) 2006-07-12 02:33:15 UTC 
My bad.  I didn't see this bug when I created my own one later on.
About to close this one as a duplicate:
http://issues.apache.org/bugzilla/show_bug.cgi?id=39136
Comment 3 Trejkaz (pen name) 2006-07-12 02:33:27 UTC 
*** Bug 39136 has been marked as a duplicate of this bug. ***
Comment 4 Trejkaz (pen name) 2006-07-12 02:33:59 UTC 
Incidentally, the patch is available in bug 39136, I thought it would be messy
to upload the same file twice.
Comment 5 Jason Height 2006-07-29 05:02:05 UTC 
40024 fixed.