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.)
