next »

[Gary C.]

Hello

I have a query which centres on Excel output and cell management with null values.

On occasion, the report output is not printing cells with a null value and in effect shifting to the left all of the cells to the right. I have attached a screenshot example. Column H is null and not populated and correctly occupies a cell, up until row 195 where it is collapsed and everything shifts to the left.

Can anyone give me a pointer as to what may be causing it? For information, I tend to set the page width very large with Excel output and make a call to fgl_report_setXLSXMergeCells(false). As a workaround I can use RTL to set the value to a space rather than null.

Thanks
Gary

[Alex G.]

Hi Gary,
This is a known issue (GRE-661 Excel output: Empty columns are ignored making vertical alignment corrupted) that was fixed and back ported to GRE 3.10.07.
If you can't upgrade to that version then the workaround that you have found, is precisely what I would have suggested.
Sorry for the inconvenience,

Alex

[Gary C.]

Hi Alex

Thanks for the quick response. I will upgrade.

Gary