** Reply to message from John McAtee <[email protected]> on Wed, 23 Feb 2011 18:56:53 -0800 (PST)
Comments at end. > List > > I created a file in LO called TEST with a comment and saved as xlsx. > > I used 7zip to unzip the TEST.xlsx file and found that it created a folder > called test with three folders inside one of which is called xl. In the xl > folder there is an xml document called comments1. When I opened the file in > my browser it had the xml code that listed the cell reference and comment > associated with that cell. > > That seems to answer the question. I certainly hope this helps because I too > use Calc spreadsheets as a grade book for students and understand the panic > this problem could create. > > John McAtee > > > From: Cor Nouws <[email protected]> > To: [email protected] > Cc: Andy <[email protected]> > Sent: Wednesday, February 23, 2011 6:11 PM > Subject: Re: [libreoffice-users] comments are disappearing > > Hi Andy, > > Andy wrote (23-02-11 21:59) > > I've been using LibreOffice for a couple months now to grade student's > > papers, > > to which I append ample comments. I've just discovered that when I save the > > document in Microsoft 2007 format and then open it up again, all the > > comments > > I've written disappear. I know now to not use this format any more, but > > I've now > > lost comments for about 25 papers. Is there any way to retrieve them? > > When you worked on the document for some time, sure there will be a backup in > the original .odt format? (Saving as .doc does not replace the .odt). > > That would be the best solution, IMO. > > Best regards, > Cor I've just tried it with LO 3.3.1 and the comments are saved in both cases, i.e. saving as .ods or as .xlsx. I did find that I had to save the spreadsheet after adding/editing comments or they would not be saved. Of course that is to be expected, but I verified it so am mentioning it here. -- Cliff -- Unsubscribe instructions: E-mail to [email protected] List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
