In Jasper for the excel report, we can use FORMAT_PATTERNS_MAP to control the display format for number, for example here:
Only display the integer part in the cell, but when we click that specific cell, we can see all the decimal part.
But when it come across the Percentage type, i really have no idea how to deal with it. have tried many times to figure out the solution, still no lucky till now. Is anyone there have the same issue? or any good idea for this issue?
How to control the percentage format for excle export
in Products
Posted
In Jasper for the excel report, we can use FORMAT_PATTERNS_MAP to control the display format for number, for example here:
Only display the integer part in the cell, but when we click that specific cell, we can see all the decimal part.
But when it come across the Percentage type, i really have no idea how to deal with it. have tried many times to figure out the solution, still no lucky till now. Is anyone there have the same issue? or any good idea for this issue?