Subscribe for automatic updates: RSS icon RSS

Login icon Sign in for full access | Help icon Help
Advanced search

Pages: [1]
  Reply  |  Print  
Author Topic: Merged Cells in Excel  (Read 9247 times)
Gary C.
Posts: 109


« 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


* example.png (7.46 KB, 558x128 - viewed 1866 times.)
Alex G.
Four Js
Posts: 148


« Reply #1 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

Gary C.
Posts: 109


« Reply #2 on: February 16, 2018, 11:59:35 am »

Hi Alex

Perfect! Many thanks

Gary
Reuben B.
Four Js
Posts: 1046


« Reply #3 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

Product Consultant (Asia Pacific)
Developer Relations Manager (Worldwide)
Author of https://4js.com/ask-reuben
Contributor to https://github.com/FourjsGenero
Pages: [1]
  Reply  |  Print  
 
Jump to:  

Powered by SMF 1.1.21 | SMF © 2015, Simple Machines