Hi Folks,
We have a application in which a student's lesson progess details are populated on a screen viz, a
JSP from a database column. This is generated as a Jasper Report and the values extracted from database contains a lot of
String Data and inserted into an excel sheet.
One of the problems that we came across recently was, Teachers created an assignment by copying and pasting a mathematics formula as a assignment name. The Formula is like this X(
Square)+2x, here
Square refers to the actual raise to the power 2, now when this data is inserted in excel sheet, it is inserted like this :
x<sup>2</sup>+2
x which is so hard to read and teachers and students are complaining about this incorrect data.
Is there anyway in
Java that we can parse the HTML tags as actual mathematics formula inside an excel sheet directly, like generally if we want to superscript a value we use superscript function of excel sheet,the same functionality we need on the data that is getting populated inside the excel sheet.
Thanks a lot in advance,
Yogendra N Joshi.