Four Js Customer Forum

Hi

Can anyone give advice on how to stop cells being merged when the output of the report is XLSX?

In the attached example output you can see that column E is represented as one merged cell and this is because the items have not been despatched yet and thus the passed date is null.

I have tried setting the removeWhitespace  option of the fgl_report_configureXLSXDevice call to false but to no avail.

I'm sure I'm missing something but I'm struggling to find it.

Thanks

Hi Gary,

call the function fgl_report_setXLSXMergeCells(FALSE).
I cell merging was introduced some time after the function fgl_report_configureXLSXDevice () had already been published and since we can't change an existing API function, we introduced a new function for this.

Best regards,

Alex

Hi Alex

Perfect! Many thanks

Gary

A handy tip when searching for possible GRW API functions is to include the phrase fgl_report in the search expression.

With the online Studio docs, a search for "merge", the answer is 19th of 27 using Online search, or 9th of 64 when using Studio search.  Include the phrase fgl_report in the search expression and the answer is 1st of 149, 1st of 8 respectively.

Reuben