6
 Followers
35
 Likes

RecordListToExcel widget column export order

Backend
On our radar

It would be nice to be able to set the required order of columns when output in the excel file.

We've had various requirements/complaints about the column ordering in exported files that make life harder than it needs to be for business users.

PS: I am eager to assist in extending the widget ;)

Created on 29 Nov 2016
Comments (7)
Merged this idea with 'Possibility to order the columns to be exported to excel' (created on 19 Dec 2018 09:56:11 by William Antunes)

It would be good to have an option/property to set the order in the Record List To Excel attribute selection.

Now it is only possible to do this using an structure but sometimes the structure is only used because of that. So this could avoid extra structures just to workaround it.



This comment was:
- originally posted on idea 'Possibility to order the columns to be exported to excel' (created on 19 Dec 2018 by William Antunes)
- merged to idea 'RecordListToExcel widget column export order' on 20 Dec 2018 09:58:58 by Kilian Hekhuis

Changed the category to Backend and the status to

On our radar


Hey William,

That indeed makes sense. Thanks a lot for your idea!



This comment was:
- originally posted on idea 'Possibility to order the columns to be exported to excel' (created on 19 Dec 2018 by William Antunes)
- merged to idea 'RecordListToExcel widget column export order' on 20 Dec 2018 09:58:58 by Kilian Hekhuis

I had a few cases where i indeed used a structure to circumvent the lack of the possibility of ordering the columns. Maybe an addition to this idea is the ability to choose seperate tabs for seperate column groups as well?



This comment was:
- originally posted on idea 'Possibility to order the columns to be exported to excel' (created on 19 Dec 2018 by William Antunes)
- merged to idea 'RecordListToExcel widget column export order' on 20 Dec 2018 09:58:58 by Kilian Hekhuis

Having multiple sheets already exists:

https://www.outsystems.com/ideas/969/%5bService+Studio%5d+RecordListToExcel+should+able+to+export+to+several+sheets?IsFromAdvancedSearch=True



This comment was:
- originally posted on idea 'Possibility to order the columns to be exported to excel' (created on 19 Dec 2018 by William Antunes)
- merged to idea 'RecordListToExcel widget column export order' on 20 Dec 2018 09:58:58 by Kilian Hekhuis
Merged this idea with '[Service Studio] Format for excel export file (order, naming)' (created on 25 Apr 2011 05:32:05 by - -)
Excel file: Allow the user to specify the excel column listing order and alias naming.

This comment was:
- originally posted on idea '[Service Studio] Format for excel export file (order, naming)' (created on 25 Apr 2011 by - -)
- merged to idea 'RecordListToExcel widget column export order' on 20 Dec 2018 10:01:08 by Kilian Hekhuis
views
696
Followers
6