Please respond to the list, so others may try and help you out. The attachments probably get stripped though... ---------- Forwarded message ---------- From: Jamie Mitchell <[EMAIL PROTECTED]> Date: 2008/9/11 Subject: Re: [discuss] Calc Suggestion: Sort with Auto Filter To: Guy Voets <[EMAIL PROTECTED]>
Thank you, Guy, for responding so quickly. I am aware of the Sort icons and menu command. I apologize if my suggestion was confusing. I've attached two screen caps to, hopefully, explain more clearly. Each shows the Auto Filter drop down menu. In Excel, you can see the Sort options. In Calc, these are not offered. Many, if not most, of my spreadsheets have up to 40 or 50 columns. These require constant sorting as new info is entered. The Data>Sort option is a little cumbersome and, in my opinion, not very intuitive. Further. just using the Sort icons results in the header rows being sorted with the rest of the data. This is just one of those little things that make it difficult to justify switching to OpenOffice. While I would very much like to start moving away from dependency on Microsoft Office, it's little things like this that are keeping me from making the switch. Thanks, again. --- On *Thu, 9/11/08, Guy Voets <[EMAIL PROTECTED]>* wrote: From: Guy Voets <[EMAIL PROTECTED]> Subject: Re: [discuss] Calc Suggestion: Sort with Auto Filter To: [EMAIL PROTECTED], [EMAIL PROTECTED] Date: Thursday, September 11, 2008, 6:10 AM 2008/9/11 Jamie Mitchell <[EMAIL PROTECTED]> > I've been anxiously awaiting the release of OpenOffice.org 3 and just > downloaded the RC1. As my job requires me to use spreadsheets with dozens > of columns, the Sort Ascending/Descending feature of Excel's Auto Filter is > crucial. I was hoping this would be implemented in the new version of > Calc. It seems it has not. This alone will keep me from migrating from > Excel. Please consider this for future versions or even inclusion in the > final release or first incremental update. Thanks for reading my > suggestion. > > Jamie Mitchell > Hello Jamie, I don't understand your question since Sort Ascending and Sort Descending have been available in OpenOffice.org for quite some time... See 18th and 19th icon in Standard Toolbar (AZ with down arrow / ZA with down arrow) Furthermore, you can specify 3 columns to sort on through Data > Sort, an specify whether there are column labels or not (Options tab) Under Data you also have Filter. So what are you missing? -- Guy using dutch OOo Aqua 3.0.0 Beta-2 on a iMac Intel DualCore Tiger and brazilian OOo Aqua 3.0.0 Beta-2 on an Intel MacBook Pro Leopard -- please reply only to [email protected] -- Dodoes can't afford to have headaches -- Guy using dutch OOo Aqua 3.0.0 Beta-2 on a iMac Intel DualCore Tiger and brazilian OOo Aqua 3.0.0 Beta-2 on an Intel MacBook Pro Leopard -- please reply only to [email protected] -- Dodoes can't afford to have headaches
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
