Skip to Content (Press Enter)
Back to Ideas
38
Like
Follow Idea
RecordListToExcel widget column export order
1453Views
9Comments
On our RadarOn our Radar
Backend

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

29 Nov 2016
Copy link to comment
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)
20 Dec 2018
Copy link to comment

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
19 Dec 2018
Copy link to comment
2014-02-07 17-02-43
Vasco Pessanha
Changed the category to
Backend
and the status to
On our RadarOn 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
19 Dec 2018
Copy link to comment

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
19 Dec 2018
Copy link to comment
2014-02-07 17-02-43
Vasco Pessanha

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
19 Dec 2018
Copy link to comment
Merged this idea with '[Service Studio] Format for excel export file (order, naming)' (created on 25 Apr 2011 05:32:05 by - -)
20 Dec 2018
Copy link to comment
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
25 Apr 2011
Copy link to comment
Merged this idea with 'Ability to Sort ListToExcel selected columns' (created on 13 Jun 2021 21:05:51 by Sherif Diab)
14 Jun 2021
Copy link to comment

it would be great if you allowed the developer to sort the selected attributes in ListToExcel Server Action




This comment was:
- originally posted on idea 'Ability to Sort ListToExcel selected columns' (created on 13 Jun 2021 by Sherif Diab)
- merged to idea 'RecordListToExcel widget column export order' on 14 Jun 2021 05:15:08 by Daniël Kuhlmann
13 Jun 2021
Copy link to comment