Jeannie: I'm puzzled by the symptoms you describe. I've done data entry forms in Calc exactly like you describe and they're worked just like they're supposed to (like you describe Excel does). So my main input is that it SHOULD work in Calc, but that doesn't help you figure out why it doesn't. Possibly you could re-do the whole protection/unprotection process and see if that helps. Dick Detwiler, Webster, NY In a message dated 1/24/2006 3:08:43 PM Eastern Standard Time, [EMAIL PROTECTED] writes:
We have both Open Office and Microsoft users in our organization. I have constructed a form in Microsoft Excel. The data entry field cells are formatted unprotected, all other cells protected. Sheet Protection is turned on, with "Select Unlocked Cells" activated. The result is that the cursor goes directly to the next unprotected data entry field when the Tab key is pressed. Makes for very efficient data collection. Using this form in Open Office 2.0, Tab key seems to move the cursor to the protected cell immediately right of the last input, and then to the next unprotected data entry cell, but not always. The unpredictable nature of the beast makes for ghastly data entry. Any suggestions? Jeannie McQuaid, CHRP Supervisor, Human Resources BELSHIELD ENTERPRISES LIMITED ph: (613) 966-3399 Ext. 272 fax: (613) 967-8948 email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
