asked on July 27, 2017
Hi,
I tried to sort by column1 followed by column 2. once you apply the sort for one column, all other columns become random alphabetically.
it looks only allows to sort on one column and forgets any other column sorting. It should remember all sorting setup and apply those based on column position (first column first, then second column etc). It is working in pivot table classic layout but not in flat.
Please take a look and let me know whether able to recreate this or not. it's happening in DEMO site also.
Thanks & Regards,
Sunilkumar.V
⋅ July 27, 2017
Hello Kumar,
You are right, it the flat view you can apply sorting only by one specific column at a time.
Otherwise, the data in rows will be messed up.
Do you have an example how it works in Excel or other similar software?
Regards,
Ian
⋅ July 27, 2017
Hi Ian,
Yes, the same way it works in Excel with custom sort option. Column 1 then after column2 then...column N.
Please find an attachment with an excel example: Without Sort and With Sort tabs. Please let me know if you need anything else.
Thanks & Regards,
Sunilkumar.V
⋅ July 27, 2017
Please find an excel example that I have attached.
⋅ July 28, 2017
Hello Sunilkumar.V,
Thank you for providing the Excel sample. Currently, sorting with multiple columns is not supported in flat view. This feature is not in our roadmap, however, we have added it to our customers' wish list. We will keep you posted with any updates.
Regards,
Tanya
⋅ April 2, 2018
Tanya - we are also looking for multi-sort capabilities in the flat-view. Any plans on adding this to the roadmap?
⋅ April 3, 2018
Hello Ankit,
Thank you for writing. For now, we do not have any plans on adding this feature to the roadmap. Still, we keep in mind that some of our customers have already requested it. Therefore, this feature may be added to the roadmap in future. We will notify you when the status of this task is changed.
Regards,
Dmytro
⋅ July 5, 2019
Hello. We also would be pleasure if you decide to add multi-column sorting to all view types.
⋅ July 5, 2019
Hello, Sergii,
Thank you for writing to us.
Our team would like to explain that our roadmap is full at the moment.
Please keep in mind that we will notify you in case of any updates on the matter.
You are welcome to contact us in case of any questions.
Best Regards,
Vera
⋅ January 14, 2020
This certainly is a much needed feature. I appreciate that it might not be trivial to implement for pivot tables, but for flat tables it's a standard feature in most spreadsheet programs.
Best regards,
Richard
⋅ January 15, 2020
Hello, Richard,
Thank you for contacting us.
Your suggestion sounds reasonable, and the task on creating such a feature is added to our backlog. However, our team would like to kindly inform you that our roadmap is full for the current moment.
We will keep you posted with any updates.
Please contact us in case additional questions occur.
Best regards,
Illia
⋅ January 24, 2020
+1 for this feature
⋅ January 24, 2020
Hello, Matthew,
Thank you for your interest.
Please kindly note that our roadmap is full at the moment.
However, our team has taken your request into consideration and we will notify you in case of any changes.
Kind regards,
Vera
⋅ March 11, 2020
Hello, Kumar, Ankit, Sergii, Richard, and Matthew,
We are happy to let you know that multi-column sorting is now available for the flat table (use Ctrl + click to sort via UI).
Please see the following JSFiddle example for illustration: https://jsfiddle.net/flexmonster/eknwq2ma/
This is available in the 2.8.2 version of Flexmonster: https://www.flexmonster.com/release-notes/
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/
Please let us know if everything works fine for you.
Looking forward to your feedback.
Best regards,
Vera
