Using R1C1 notation for XLS formula

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

Hello!

 

Is there a possibility to use R1C1 notation for formula in JasperReports? Try to use "SUM(R[1]C:R[10]C"  as an expression with net.sf.jasperreports.export.xls.formula

but Excel can't open the file and remove this formula. Excel swithced to R1C1 for fomulas

nord_tramper's picture
Joined: Aug 6 2007 - 10:27pm
Last seen: 3 years 1 month ago

1 Answer:

Instead of R1C1 notation I use smth/ like this SUM(INDIRECT(ADDRESS(10,COLUMN())):INDIRECT(ADDRESS("+$V{_u1.cnt}+10+",COLUMN()))). it is working )

nord_tramper's picture
Joined: Aug 6 2007 - 10:27pm
Last seen: 3 years 1 month ago
Feedback
randomness