Secondary Sort Broken In Quip Spreadsheets - Ideas - Salesforce Trailblazer Community

All Ideas

Idea Details

Post an Idea
90  Points
Open
Idea has been posted. Give it an upvote or downvote.

Secondary Sort Broken In Quip Spreadsheets

Spreadsheets

Consider the following two columns of letters, "one" and "two": 

one	two
A	F
A	G
B	X
B	Y
C	N
C	Q

Sorting Z -> A by column "two" then Z -> A  by column "one" yields the following in both Excel and Google Sheets: 

one	two
C	Q
C	N
B	Y
B	X
A	G
A	F

In Quip, I get the following: 

one	two
C	N
C	Q
B	X
B	Y
A	F
A	G

Running the second descending sort on column "one" flips the initial descending sort on column "two" to an ascending sort. This behavior is a bug because it deviates both from what is considered standard in the market as well as what most people would consider intuitive behavior in terms of sorting by multiple values.

 

Merge Idea · Flag

  • Upvotes
  • Downvotes

Ideas

Apps

from AppExchange

Questions

Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



 

 

Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


 

Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.