Cross Sheets Formulas not working for XLS but working for XLSX

[nestoru]

 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 

[nestoru]

 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

[szaharia]

Hi,

Looks like a bug, you're right. Thank you for noticing it.

At the moment I'm not sure if the issue comes from JR, or rather from the Apache POI library.

And yes, it's a good idea to fill in a bug fix request.

Regards,

sanda

[iamwoodyjones]

When you write the ticket, can you post the link/ticket # here?  We're having the same issue here on our end and I'd like to put a watch on the ticket.

[nestoru]

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

[iamwoodyjones]

Sweet!  Thanks for the ticket references and the source code on your web site.  I bumped you up on your karma