Issue 57550 - To merge cells removes cell formulas
Summary: To merge cells removes cell formulas
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0
Hardware: PC All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
: 89319 (view as issue list)
Depends on:
Blocks:
 
Reported: 2005-11-09 08:42 UTC by fcoiffie
Modified: 2017-05-20 11:13 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description fcoiffie 2005-11-09 08:42:38 UTC 
In a cell, I put a following formula like this one : 
 
=D2+E2 
 
If I merge this cell with the previous one (which is empty), the new cell 
contains the result of the formula instead of the formula. 
 
After merging, the new cell should contain the real content of the previous 
cell, not only the appearance/result.
Comment 1 atdsm 2005-11-17 14:56:17 UTC 
Can confirm - Windows XP SP2, 00o-dev 2.0.169

Like fcoiffie said:
1) Open a new spreadsheet
2) Put the numbers 1 & 2 in cells D2 and E2, respectively
3) Put the formula "=D2+E2" in cell E4. (The result is, of course, 3.)
4) Merge cells D4 and E4 w/ the merge cells button. Choose to move "the contents
of the hidden cells into the first cell."
5) Merged cell D4-E4 now contains the number "3" rather than the formula "=D2+E2"

Confirmed issue.
Comment 2 frank 2005-12-15 10:36:45 UTC 
Hi Niklas,

one for you I think.

Frank
Comment 3 christof.pintaske 2006-03-06 14:58:50 UTC 
due to missing ressources for the next minor updates: set to later target
Comment 4 Regina Henschel 2008-05-11 23:31:05 UTC 
*** Issue 89319 has been marked as a duplicate of this issue. ***
Comment 5 Marcus 2017-05-20 11:13:16 UTC 
Reset assigne to the default "issues@openoffice.apache.org".