[Libreoffice-bugs] [Bug 40590] New: Formulas stored as defined names "lost" when spreadsheet opens

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Sat Sep 3 01:57:03 CEST 2011


           Summary: Formulas stored as defined names "lost" when
                    spreadsheet opens
           Product: LibreOffice
           Version: LibO 3.4.3 release
          Platform: x86 (IA32)
        OS/Version: Windows (All)
            Status: NEW
          Severity: critical
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: b.bugs.freedesktop at learyfamily.net

I have attached a spreadsheet that demonstrates the problem.

1) Open the attached spreadsheet that contains formulas stored as defined

2) Note that cell E4 displays #NAME?.

3) Ctrl-F3 to open the defined names window and examine defined name
"ElecUsageKW".  Note that the Assigned To field contains a valid formula.

4) Highlight and copy the formula.  Then click Delete.  (note: you cannot click
modify as that will crash 3.4.3.  A separate bug report was submitted about
that problem which is not related to the subject of this bug)

5) Immediately paste the saved formula back into the Assigned To field and then
click Add.

6) Click OK and note that cell E4 now displays the correct value value of 1682. 

7) Resave the spreadsheet.  

8) Close the spreadsheet.

9) The next time the spreadsheet is opened the problem will be the same as

I have not been able to find a work-around to this problem.  This was not a
problem in 3.4.2.  It is new to 3.4.3.

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

More information about the Libreoffice-bugs mailing list