[Libreoffice-bugs] [Bug 41056] New: Contents of certain .ods files are deleted. FILESAVE

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=41056

           Summary: Contents of certain .ods files are deleted. FILESAVE
           Product: LibreOffice
           Version: LibO 3.4.3 release
          Platform: x86 (IA32)
        OS/Version: Linux (All)
            Status: NEW
          Severity: critical
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: cranberrydoughan at yahoo.com


Created an attachment (id=51423)
 --> (https://bugs.freedesktop.org/attachment.cgi?id=51423)
Original template for grades

The contents of certain .ods files I have are utterly deleted when saved,
either as new files or as simple changes to the same file.

I am a graduate student, and received an .xls file from my department as a
template for recording grades (see attachment: grades.xls). It contains macros
that automatically calculate the final grade from the assignment grades.

A while ago I had converted it to an .ods file, and went on my way recording
grades. This worked just fine when I was using the 3.3 series of LibreOffice
(and before, and even OpenOffice before that). When I most recently returned to
it and edited it, I found that what it saved was a blank file - all the data
and formating was gone as far as I can tell (thankfully I had a backup!). I
went back to the original .xls template and saved it as an .ods, and sure
enough, all information is lost (see: grades.ods). If I try to edit this new
.ods and save it, an error message appears: "Error saving the document grades:
Write Error. The file could not be written."

One way I can get the contents of the .xls file into an .ods is to create a new
.ods and copy and paste the contents. I can then save it and still be able use
the file properly. (It also doesn't warn me of the file containing macros when
started.)

I am running LibreOffice 3.4.3 on Ubuntu 10.10, though the problem is also
present in 3.4.2. The 3.3 series did not have this problem.

Apologies if a similar bug has been filed before, though I could not find one.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.