Bug 30862 - Support Excel Ptg 0x14 (percent)
Summary: Support Excel Ptg 0x14 (percent)
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
: 39136 (view as bug list)
Depends on: 40024
  Show dependency tree
Reported: 2004-08-26 09:53 UTC by bart
Modified: 2006-07-28 22:02 UTC (History)
1 user (show)


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 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:
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.