Issue 76828 - Merging cells with formula convert the formula to plain text (without variables).
Summary: Merging cells with formula convert the formula to plain text (without variabl...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.2
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-05-01 23:01 UTC by alexpb
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

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

Attachments
Merging issue example (7.75 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-05-01 23:02 UTC, alexpb 		no flags Details
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 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".