next »

[Gary C.]

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

[Alex G.]

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

[Gary C.]

Hi Alex

Perfect! Many thanks

Gary

[Reuben B.]

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