1
Vote

Export to Excel gives data in wrong columns

description

Hi!
I am using DNN 7.3.4 in a site where Helferleinform 2.3.10 and Helferlein Babelfish 1.1.4 is used in a quite large form. Data is saved in the databas and is also emailed correctly, but when I export to Excel the result is strange!

Data in certain columns and above is shifted to the right one step, giving no data in one column but instead data in a column to the right, data is "shifted to the right". This happens on 4 different columns giving no data i those 4 columns and columns to the right are shifted to the right.

Please open the supplied Excel file which shows the result and also the expected result!!

I have tried VERY HARD to find the cause but did not succeed. I am most grateful for a solution or way around the problem.


I did also do a few more tests involving other versions of Excel and different browsers. IE 11, IE 9 and Firefox 34.0.5, Excel 2007 and Excel 2013 are tested, but do all give the same result.


Best regards,
Peter

file attachments

comments

PeterWill wrote Jan 9, 2015 at 7:23 AM

The Excel-file ...

PeterWill wrote Jan 18, 2016 at 8:24 AM

Hi agan!

Regarding the problem we reported some time ago about exporting to Excel, unfortunately we have not been able to solve it.

We still face the problem that gives an Excel file with data columns are shifted to the right relative the column labels. To correct the problem we have to manually edit the Excel file as follows:

1.
Data in column L and all columns to the right of L until column AD, must be moved one column to the left.

2.
Data in column M and all columns to the right of M until column AC, must be moved one column to the left.

3.
Data in column O and all columns to the right of O until column AB, must be moved one column to the left.

4.
Data in column P and all columns to the right of P until column AA, must be moved one column to the left.

If this can be solved it would be great!

Kind regards,
Peter

PeterWill wrote Jan 18, 2016 at 8:26 AM

I forgot to tell about versions:

DNN: 7.4.2

Helferlein Form: 2.3.10

Babelfish: 1.1.4

/Peter