Private view for filters

I've been trying to choose between EditGrid and Zoho for a business need here. Zoho is great, as it is being supported and is developing over time, but there are a few features I'd like to put on the request list:

1. Private view for filters. On EditGrid, if one user filters, only that user's view is changed. So different users can filter differently depending on what portion of the spreadsheet they are working on. In Zoho, it appears that if one user filters, all users get that same filter, which essentially means we can't filter at all.

2. Lists for the "pick for list". Only Excel has this, but I wish I could hardcode and define the options that show up when you "pick from list". If I put the values at the top of the column, I can no longer freeze panes since freeze panes only works on 5 rows. If I put the values at the bottom, I have to move them every time I append to the list. I haven't found a good solution.

Thanks!