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
