Eclipse Community Forums: BIRT » Aggregate values not appearing in excel

Home » Archived » BIRT » Aggregate values not appearing in excel(When saving a report that has aggregation as .xlsx, the values are blank when spreadsheet is opened. However, if you just run it and choose "Open" instead of "Save", the values app)

Aggregate values not appearing in excel [message #1785763]

Thu, 19 April 2018 08:14

Eclipse User

When saving a report that has aggregation as .xlsx, the values are blank when spreadsheet is opened. However, if you just run it and choose "Open" instead of "Save", the values appear.

Any suggestions?

Re: Aggregate values not appearing in excel [message #1785773 is a reply to message #1785763]

Thu, 19 April 2018 10:23

Eclipse User

Found the issue. I had to uncheck the protected view options in excel. Now it works as expected.

Previous Topic:	Crosstab - Hide NULL dynamic column (also when exporting to Excel)
Next Topic:	Query result limit

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Mar 21 22:26:17 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter