Issue 76828

Summary: Merging cells with formula convert the formula to plain text (without variables).
Product: Calc Reporter: alexpb <apbmail>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.2   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Merging issue example none

Description alexpb 2007-05-01 23:01:14 UTC 
Merging cells with formula convert the formula to plain text (without variables).

Example:

setup:
Cell-> Content
A1->   empty
B1->   =A2+B2
C1->   empty
A2->   2
B2->   3

Instructions: Merge cell A1 + B1 + C1, and look at the resulting content of that
cell (it is 5 but the formula disappeared).
Comment 1 alexpb 2007-05-01 23:02:43 UTC 
Created attachment 44793 [details]
Merging issue example
Comment 2 frank 2007-05-02 14:13:03 UTC 
Hi Niklas,

Excel does copy the formula into the merged cell, we do copy the value and
remove the formula from b1 which can be seen if you de-merge the cells.

Frank
Comment 3 Marcus 2017-05-20 11:13:10 UTC 
Reset assigne to the default "issues@openoffice.apache.org".