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 -- - giving openoffice.org its foundation :: The Document Foundation - -- 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 *** -- 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 ***
