|
Title: Merged Cells in Excel Post by: Gary C. on February 15, 2018, 09:24:16 pm 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 Title: Re: Merged Cells in Excel Post by: Alex G. on February 16, 2018, 09:02:58 am 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 Title: Re: Merged Cells in Excel Post by: Gary C. on February 16, 2018, 11:59:35 am Hi Alex
Perfect! Many thanks Gary Title: Re: Merged Cells in Excel Post by: Reuben B. on February 19, 2018, 05:14:37 am 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 |