Export to Excel not exporting all columns from query

weblike

Hi,

I have a query and 2 Panel Buttons in Top Panel Toolbar; "Export to EXCEL" "Export to CSV"

Export to Excel -> does not export all the columns from the query
Export to CSV-> exports all the columns

anyone knows this tricks ?

thank you.

weblike

I have tested further this action and appears that:

The columns which are part of a group are NOT exported to EXCEL.
Same record is exported multiple times (I see it on multiple lines in Excel).

Attached is a sample bsv.
How to Reproduce:

Create 1 customer
Create 1 order for that customer
Click the button "Export Excel"
Open exported file in Excel.

ExportToExcel-05092016.zip
35.83kB

ExportToExcel-05092016.zip
35.83kB

karelh

I am running build 2237 and have the exact same problem with the excel export creating duplicates.

Is there a way to work around this at the moment?

Regards,
Karel

weblike

This was fixed in build 2224. Strange that appeared again (didn't test it).

Bugs:
1. Dynamic recalculation of a multi-selector field didn't work sometimes
2. LIST_TABLE_START didn't work if only one parameter was specified
3. Export in Excel didn't work correctly for queries with column groups

karelh

Hi,

I have tested it a few times with other queries and still have the same results:

Duplicates are exported for some records.(only on XLS. CSV is 100%)
The item that it is grouped by is not exported.

Anyone else that experienced the same problem?

Thanks & regards

weblike

Hi,

What build are you using?
I have tested on 2236 developer edition and is exporting grouped items and is not duplicating...

karelh

I am running on developer edition 2237

weblike

karelh wrote
Hi

I am running on developer edition 2237

Strange....i will make more tests with bigger data...