Jump to content
Changes to the Jaspersoft community edition download ×

Excel Formula


2005 IR Help

Recommended Posts

By: lyf - yufeng00

Excel Formula

2004-06-15 00:25

Hi,

 

Is there a way to write a excel formula in JasperReport: a simple formula such as value of Colume C = sum of Column A and Column B. In POI, there are some APIs for Formula, if JasperReport does not directly support it, can I get a handle to POI in Jasper? Thanks in advance.

Link to comment
Share on other sites

  • 2 years later...
  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Hi,

I have the same requirement.Was this solved?

I tried to set formula for cells in excel using POI HSSF API...

DETECT_CELL_TYPE attribute is set to true in my jasper code..Column for which we have to set SUM formula is set to Double.

When we try to set formula to the cells using HSSF ,it doesn't works why?

I tried a simple sample by setting the cell type as Integer - formula works with Integer cell type..but with double it doesn't ?anyways to fix this?

 

 

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...