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: Another Excel Query  (Read 4533 times)
Gary C.
Posts: 89

« on: February 27, 2018, 12:21:22 pm »


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.


* ScreenShot.png (55.94 KB, 1252x403 - viewed 698 times.)
Alex G.
Four Js
Posts: 134

« Reply #1 on: February 27, 2018, 02:38:32 pm »

Hi Gary,
This is a known issue (GRE-661 Excel output: Empty columns are ignored making vertical alignment corrupted) that was fixed and back ported to GRE 3.10.07.
If you can't upgrade to that version then the workaround that you have found, is precisely what I would have suggested.
Sorry for the inconvenience,

Gary C.
Posts: 89

« Reply #2 on: February 28, 2018, 09:23:38 am »

Hi Alex

Thanks for the quick response. I will upgrade.

Pages: [1]
  Reply  |  Print  
Jump to:  

Powered by SMF 1.1.21 | SMF © 2015, Simple Machines