Did you try to Google: "select blank cells in calc"? One that might apply:
How to check blank cell in Find & Replace: http://www.oooforum.org/forum/viewtopic.phtml?t=55351 If none of these help then you need to create a macro and map it to whatever key shortcut you like. Your comment: "But I think Database program will not suit our calculation requirements." make we wonder why, since I believe that a Base macro can call any function available in Calc. Hope this helps; On Mon, Apr 18, 2011 at 6:19 PM, <[email protected]> wrote: > Dear Dan, > > Thanks for your interest. We are processing the payment of health claims. > This involves application of pricers from CMS and so many other > calculations > depending on contract with contracted (In-network) providers/hospitals, > which varies case-to-case. Also deduction of copayment/coinsurance etc. We > are using Database program to keep track of claims, members, etc. But I > think Database program will not suit our calculation requirements. If you > can suggest a way to use filters effectively with keyboard shortcut keys > that will be fine. > > Thanks > Venkat > Asst. Manager > Process Refinement Team. > > e4e > Tel India : +91 (44) 22681240 - Extn. 164 > email: [email protected] > www.e4e.com > > ‘e4e Healthcare Business Services is ISO 9001:2008 & SAS 70 certified > company’. > > > > -----Original Message----- > From: Dan Lewis [mailto:[email protected]] > Sent: Monday, April 18, 2011 10:56 AM > To: [email protected] > Subject: [users] Re: Filtering options in Calc > > [email protected] wrote: > > > > Dear All, > > > > I introduce myself as Asst. Manager in my company which is handling > > huge data files of Healthcare Providers. > > > > The problem my team encounters while using Calc are as follows: > > > > 1. As we are handling huge data, using mouse will hinder the speed of > > operation. There is no alternative keyboard shortcut available for > > Alt+Down arrow as in Excel to quickly select the filtered data. > > > > 2. There is an option in Excel Ctrl+G --> _S_pecial, which allows me > > to fill the blanks with the text/number above referred by pressing > > Ctrl+Enter. I do not find an alternative in Calc Navigator. > > > > I will be grateful if you can help me to overcome the above. > > > > Thanks > > *Venkat* > > > > Asst*. *Manager > > > > Process Refinement Team. > > > > > Is there any particular reason why you are not using Base instead > of Calc? Huge data files seem to lend themselves to databases instead of > spreadsheets. The tables of the database would contain the data, and > queries can be used to access this information in whatever form you > needed. I personally think a database would fit your needs > > Dan > -- > ----------------------------------------------------------------- > To unsubscribe send email to [email protected] > For additional commands send email to [email protected] > with Subject: help > > > > CONFIDENTIALITY NOTICE: This e-mail and any attachments may contain > confidential and privileged information for the use of the designated > recipients named above. If you are not the intended recipient, you are > hereby notified that you have received this communication in error and that > any review, disclosure,dissemination, distribution or copying of it or its > contents is prohibited. If you have received this communication in error, > please notify the sender and destroy all copies of this communication and > any attachments. > > > 'e4e Healthcare Business Services is an ISO 9001:2008 & SAS 70 certified > company'. > > > > > -- > ----------------------------------------------------------------- > To unsubscribe send email to [email protected] > For additional commands send email to [email protected] > with Subject: help > -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
