[Macro does not execute when attached to exporter using API]

First of all look into http://community.jaspersoft.com/jasperreports-library/issues/2363#comment-710646 as apparently Jasper Reports provided the solution I suggested years ago.

 

If that does not work then I assume XLS macros do still load correctly (for example following  http://thinkinginsoftware.blogspot.com/2011/11/excel-jasper-reports-with-macros.html). Similar code should be available for XLSX.

 

I would create a java standalone program (containing main method) that would load the original xlsm, add some text in A1 and then save it with POI could help in understanding if there is an issue with Apache POI. We should manually open the saved file and expect it still opens the message box just like the original xlsm. If it does not then we need to open a bug with Apache POI project. If it does then we add that information here and potentially create a bug ticket for Jasper Reports API.

 

In addition posting the question to stack overflow just as you did over a year ago (http://stackoverflow.com/questions/28593223/apache-poi-opcpackage-unable-to-save-jasper-report-generated-xlsx) could help as well.

 

Best regards,

 

- Nestor

[How can I set a custom palette? Getting net.sf.jasperreports.export.xls.create.custom.palette=true causes NullPointerException at net.sf.jasperreports.engine.export.JR]

Hello,

We cannot make custom palette to work. 

From iReport Designer version 5.6.0 we can set a custom backcolor which will correctly export the excel cell with expected backgroiund color:

<reportElement mode="Opaque" x="0" y="26" width="250" height="26" forecolor="#FFFFFF" backcolor="#5D87A1" uuid="67e64e41-d7ac-4a1a-aba1-d44eb862c564"/>[/code]

It is expected that we can set jasperreports.properties:

net.sf.jasperreports.export.xls.create.custom.palette=true[/code]

or as a property in JRXML 

<property name="net.sf.jasperreports.export.xls.create.custom.palette" value="true"/>[/code]

To get the exact color from a jasperreports exporter however  after using the jrxml from jasperreports 5.6.0 jar it will not respect the custom color and instead break with a NullPointerException:

Caused by: java.lang.NullPointerExceptionat net.sf.jasperreports.engine.export.JRXlsExporter.getWorkbookColor(JRXlsExporter.java[/code]

Going back to version 4.7.1 it will not break but it will not change the color either. Moving forward to jasperreports version 6.0.0 will also result in NullPointerException.

Apparently this works correctly for Jasper Server ( https://community.jaspersoft.com/wiki/discrepancy-report-xls-output-cell-background-color-using-jasperreports-server-web-services ) so the question is if anybody has managed to use custom colors from the jasperreports library and how.

Thanks in advance,

- Nestor

 

 

[worksheet tab background color support?]

Hi guys,

iReport uses POI library which has support for setting the worksheet tab background color via http://poi.apache.org/apidocs/org/apache/poi/xssf/usermodel/XSSFSheet.html#setTabColor(int). Is Jasper reports / iReport supporting this feature?

Thanks!

- Nestor

[ireport 4.6.0 disabling uuid propertie generation]

Hello,

We faced this issue *only* in Windows after an installation + settings import. As I explained in http://thinkinginsoftware.blogspot.com/2012/10/ireport-attribute-uuid-is-not-allowed.html you can go around the issue if you ignore importing settings (or if you work from OSX or Linux you should not see the issue at least in our case going from 4.1.3 to 4.7.1.

I hope it helps somebody out there.

Cheers,

-Nestor

[Cross Sheets Formulas not working for XLS but working for XLSX]

Hi,

I have created ticket http://jasperforge.org/projects/jasperreports/tracker/view.php?id=5553

We are lucky enough in our current scenario to have no bidirectional formula references so we are pushing the sheet containing the formula at the end of the workboo and then using a macro that runs automatically once the book is loaded. You can find more information about this trick and a proposal to add macro support in http://jasperforge.org/plugins/mantis/view.php?id=2363

Best,

-Nestor

[Cross Sheets Formulas not working for XLS but working for XLSX]

 I can confirm this issue does not happen when we use JRXlsxExporter. The JRXlsExporter does fail so this is I think a bug.

Any feedback? Should I go ahead and feel a bug fix request?

Thanks,

-Nestor

[Cross Sheets Formulas not working for XLS but working for XLSX]

 Hi,

When running with "Excel 2007 (XLSX) Preview" the cell does get what we expect:

=mySheet2!A1

 

However when we pick "XLS Preview" we get:

=#REF!A1

 

You can find more information including source code/test case in http://thinkinginsoftware.blogspot.com/2011/11/jasper-reports-excel-cross-sheet.html

 

Any help on this issue is highly appreciated.

 

Thanks,

-Nestor 

[Text Field Number Format]

Here is how to solve this issue:

http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=32273

[Text Field Number Format]

Hi,

 

Sorry to resucitate an old thread but the suggested link does not work. I am wondering how did you resolve this issue? Excel formatting allows for more options than Jasper as far as I can tell.

Thanks in advance,

-Nestor

[hacking jasper to hide columns, need dev advice]

Here is what I did to solve this issue. Hopefully will help others.

Thanks,

-Nestor

[hacking jasper to hide columns, need dev advice]

Hi Danda,

I am wondering how did you solve the issue. I see you were on the right track as I believe the table component is the way to go however it is not working for me.

 

Thanks in advance,

-Nestor