Four Js Development Tools Forum

Discussions by product => Reporting tools (GRW, GRE) => Topic started by: Frances W. on June 01, 2018, 03:14:11 pm



Title: Excel data shifting across a column
Post by: Frances W. on June 01, 2018, 03:14:11 pm
Sometimes when we produce Excel reports, the data that was in a certain column will be shifted across a column. E.g. data that was in column D for the first 20 lines of the report will be shifted to column E, with all subsequent columns shifted across one cell and D left empty. This happens infrequently but in multiple reports and won't happen on most datasets, making it difficult to reproduce when it is reported. There is no clear cause in the data (e.g. it does not happen only when there is a null value in the data).

I've attached a .4rp that caused this issue for one user, and an example of the issue they provided. From line 3263, data in columns C-K have been shifted across to D-L respectively. This applies to the OnEveryRow data and AfterGroup data. The BeforeGroup data starts to shift at column D - the header in column C remains in Column C, with no data in column D.

(When I first tried to post it errored due to the attachment size. I created the zip file to solve this, but when I hit post again, it errored saying that the post had already been created. I looked for the post but couldn't find it. So I created the post again in a new tab. Apologies if this created a double post.)


Title: Re: Excel data shifting across a column
Post by: Alex G. on June 01, 2018, 05:35:59 pm
Hi Frances,

if it happens with null values then you might be experiencing bug GRE-661 "Excel output: Empty columns are ignored making vertical alignment corrupted".
If it happens otherwise then you might be having the issues because your group headers change the tabulation from page to page. Why this happens and how to deal with it is explained in the documentation here: http://4js.com/online_documentation/fjs-gst-manual-html/#gst-topics/c_grw_xls_single_sheet.html.
If you create a pdf document of this very output than I can take a look at it and propose how to fix it.

Best regards,

Alex