[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
https://bugs.freedesktop.org/show_bug.cgi?id=40590
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
names.
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
above.
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