thank you very much, Brian. Ashish Aghera
-----Original Message----- From: Brian Barker [mailto:[email protected]] Sent: Saturday, July 11, 2009 6:51 AM To: [email protected] Subject: Re: [users] applying filter in Calc At 10:18 10/07/2009 +0530, Ashish P Aghera wrote: >While applying filter to spreadsheet data, complete data needs to be >selected. But is there any option by which we can apply the filter >to the top row (selected row) and all continuous data below that row >comes in filter data. Yes, I think there is. Just select any *single* cell in the block (not necessarily in the header row) before applying the filter. Calc expands the range to be dealt with as you desire. I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] Standard Disclaimer Conditions as per Tatachemicals Ltd Email Security Policy apply --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
