Issue 57550

Summary: To merge cells removes cell formulas
Product: Calc Reporter: fcoiffie <frederic.coiffier>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, mloiseleur
Version: OOo 2.0Keywords: oooqa
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

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".