Import to excel missing columns

posted on May 13th, 2022

Answered

Tony asked on May 13, 2022

Hi there!
I have a problem importing data to excel.
I have a great number of columns in my pivot, and so when I import in excel, some columns are empty.
The number of empty columns goes from 677 to 702.
In excel those are ZA - ZY columns.
Columns before and after those columns are fulfilled correctly.

Attachments:
flexmonster_to_excel.png

3 answers

Public

Solomiia Andrusiv ⋅ Flexmonster ⋅ May 13, 2022

Hello, Tony!

Thank you for contacting us.

We could not reproduce such exporting behavior in our samlpe data.
Kindly ask you to try the following steps:

Export your data to CSV and check if all fields are present in the file.
Open the Excel file in another viewer, e.g. Microsoft Excel.
Modify our example to make the case reproducible: https://jsfiddle.net/flexmonster/b9tqsfdm/.
Please provide us with your browser and Flexmonster versions

It would greatly help us to continue the investigation.

Looking forward to your response.

Regards,
Solomiia

Public

Tony ⋅ May 13, 2022

Solomia thanks a lot. This is the bug in my Excel viewer LibreOffice! Sorry for the disturbance.

Public

Solomiia Andrusiv ⋅ Flexmonster ⋅ May 13, 2022

Hello again!

Thank you for your quick response.

We are glad to hear that you resolved the issue.

Feel free to ask in case of any other questions.

Best regards,
Solomiia

Import to excel missing columns

3 answers

Please login or Register to Submit Answer