Re: [libreoffice-users] comments are disappearing

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

--  - giving openoffice.org its foundation :: The Document Foundation -


-- 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 ***


      
-- 
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 ***