Re: [libreoffice-users] comments are disappearing

** Reply to message from John McAtee <jlm_connection@yahoo.com> 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 <oolst@nouenoff.nl>
> To: users@libreoffice.org
> Cc: Andy <convenientparking@gmail.com>
> 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 users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***