-------- Original Message -------- From: Carol <cee_...@verizon.net> To: <users@openoffice.apache.org> Date: Fri, 21 Oct 2016 07:08:35 -0400
> /This is a snapshot of the red outlines. They weren’t here originally, > but when I added this new column it’s now outlined in red and won’t go > away. Is this from a newer version of Open Office? Thanks for any > help you can give me./ > > *From:* Carol > *Sent:* Friday, October 21, 2016 7:03 AM > *To:* users@openoffice.apache.org > *Subject:* spreadsheet locked documents > > /I can’t seem to copy and paste so snapped a photo of the documents. > All locked, and I can’t get them to open. Not sure how they got locked > in the first place. When it says open with, Open Office doesn’t show up./ > // > /I have 4.1.2/ > // > /Had a spreadsheet all made up, was fine, but I added a new column on > the 10th, and the squares were all outlined in red. If I placed the > arrow on one, info popped up. I can’t make them go away, and actually, > not sure what I did, but all the info is gone. When I track down the > document this is what I see, and I can’t get it to open. / > // > // Hi Carol, Attachments are removed by the mailing list server and normal list subscribers cannot see them. The "/.~lock./" files shown in your screen captures are not your working files. They are temporary files used by the software while it has a working file open and are normally removed when a working file is closed. The fact that you can still see them suggests that the software is being forcibly closed or has crashed before the working document was properly saved or closed. Did you get this spreadsheet from someone else? If so, what software (eg. MS Excel) was it created in? The "/red outlined/" cells with the "/info pop-up/" are called comments, but this is not the standard cell format for cell comments, which is what makes me ask the two previous questions. It should be possible to remove the cell comment, by right mouse clicking on the cell and selecting "/Delete Comment/" from the context (pop-up) menu that opens. Is it possible to upload a sample spreadsheet to a public file sharing service (eg. Dropbox, Google Docs, MediaFire, etc.) and email the list with a link to the sample? This will make it possible to accurately answer your question and offer possible solutions. Regards Dave -- Please address any reply to the mailing list only. Any messages sent to this noreply@ address are automatically deleted from the server and will never be read.
