Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||To merge cells removes cell formulas|
|Component:||editing||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
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. ***