At 14:09 26/01/2015 +0000, Gary Jackson wrote:
I don't seem to be able to complete the attached spreadsheet.
Whatever I try to enter in the "mileage" column gives me the box
saying "If this is your first claim.... etc". Any ideas?
Here's a potential workaround:
o Open the spreadsheet in OpenOffice (Calc).
o Go to File | Save As..., select "ODF Spreadsheet (.ods)" for "Save
as type" and save in OpenOffice's native format.
o In the Re-type Password dialogue, click "Re-type" for Volunteer
Form (the visible sheet).
o In the further Re-type Password dialogue, select "Remove password
from this protected item".
o Click OK and OK.
o Close the new file.
o Reopen the new file.
o Populate the spreadsheet.
o If desired, save the document back as .xls for submission. The
document appearance is likely to be similar to what is expected, but
there are no guarantees as to the hidden functionality.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
