I opened the document in Excel 2013 to see exactly what protections were in effect.
The first thing that happened (after enabling editing of a file from the Internet), was that Macros were disabled. I did not enable macros, just to see what I could do without them. I was then able to make entries in mileage and mileage-rate cells. When I attempted to change a caption, I was told that cell was protected. I did not see the warning that occurs when the file is opened in either Apache OpenOffice or LibreOffice. In both LibreOffice and Apache OpenOffice I see the same message that Gary is reporting. I also saw a macro warning and I did not allow macros to be enabled. I did what the message says, but the message is repeated if I attempt to enter any mileage greater than 0.01 in any row of the sheet. When I saved the document, I received warnings about the output format and then when I said I wanted .xsl anyhow, the save was reported as unable to preserve all macros. Both LibreOffice and ApacheOpenOffice recognize that some cells are protected and some are not. The validation message about first-time use, etc. is apparently not related to protection. There is some other incompatibility involved. - Dennis PS: For any follow-up, please reply to users @ openoffice.apache.org where other experts may have advice and others can learn the solutions to common problems. The OpenOffice Forums have an extensive knowledge base at https://forum.openoffice.org/ as well. PPS: I also uploaded the .xslx file to OneDrive to see if it could be edited in a browser. Unfortunately, no. The Microsoft Office Web App reported that the file could not be opened on the web and that I would need Office on my computer (which I do have, as already reported) to work with the file. I suspect that has to do with the protections and possibly the macros used on the document. (I was able to open the file in OneDrive on my old-model Windows Phone, but I could not edit it there.) -----Original Message----- From: Scooter [mailto:st...@scootersdesk.com] Sent: Monday, January 26, 2015 06:50 To: users@openoffice.apache.org Subject: Re: Spreadsheet Problem Sorry Gary, The spreadsheet is locked, therefore nobody can help without the password. Unless you have a password none of the cells will register, perhaps that is the problem. I assume you didn't create this spreadsheet form, so you need a password. Take Care. Scooter College Park, MD USA Gary Jackson wrote on 1/26/2015 9:09 AM: > Hi, > > 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? > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
