Thank you Brian, I apologise I really wasn't shouting, just emphasising. Thank you for your suggestions I will look further. It was in .xls and I haven't checked what it recovered as.Regards.Alan.
-------- Original message -------- From: Brian Barker <b.m.bar...@btinternet.com.INVALID> Date: 21/10/2019 16:27 (GMT+00:00) To: users@openoffice.apache.org Subject: Re: Unwanted Dialogue Box At 10:33 21/10/2019 +0100, Alan Pearce wrote:>I am in Open Office Calc and a dialogue box has kept appearing >saying "The document you are about to export has one or more >protected items with password that cannot be exported. Please retype >your password to be able to export your document" I AM NOT TRYING TO >EXPORT MY DOCUMENT.Er, it seems you are. (And you may not need to shout!)>WHAT'S MORE IT MUSTN'T BE EXPORTED.What do you think "exported" means here? It just means the creation of a version of your document in an alternative format, e.g. as Portable Document Format. Your document isn't being sent anywhere inappropriate.>I have managed to delete it by pressing cancel about 3 times but now >the box won't go away however many times I press cancel. Any ideas please?It seems that this happens if you are keeping your document in a format foreign to OpenOffice and when AutoRecovery information is saved. Are you saving in something other than OpenOffice's native .ods format - perhaps .xls? That's generally not advisable. It seems that saving the AutoRecovery information when your document is in a foreign format is described as "exporting".If this is the problem, there appear to be a number of solutions:o Provide the password each time it is asked for.o Remove the password protection from the relevant items. (Probably not what you want to do.)o Disable AutoRecovery. To do this, remove the tick from Tools | Options... | Load/Save | General | Save | Save AutoRecovery information every xx Minutes. (Also probably not a good idea.)o (Best) Save your document as .ods. Keep it in that form and always edit that copy. If necessary for transmission to a correspondent, save a copy in the foreign format each time you need to do this. This is good practice anyway.At 15:40 21/10/2019 +0100, Alan Pearce wrote:>Typing into a cell, I was modifying an old document. I didn't note >wether it was text or figures, it happened quite a few times over >the last two days so I am sure it was probably both, it could have >been either. After cancelling about three times each time it >appeared it would go away. However in the end it wouldn't stay away >and it was not possible to work on it or save it.Still sounds like AutoRecovery.>I got out of the problem in the end by forcing a computer shutdown >and then re-opening via recovery.You see how useful this was, so don't disable the facility but use the first or last suggestions above.I trust this helps.Brian Barker---------------------------------------------------------------------To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional commands, e-mail: users-h...@openoffice.apache.org