https://bugs.documentfoundation.org/show_bug.cgi?id=93202
Bug ID: 93202
Summary: When merging cells formula is lost
Product: LibreOffice
Version: 5.0.0.5 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
LibreOffice 5.0.0.5 on Ubuntu 14.04 using PPA:
http://ppa.launchpad.net/libreoffice/ppa/ubuntu
1. Open new Calc document.
2. In cell A1 type in value: 100
3. In cell A2 type in value: 200
4. In Cell B1 type in formula: =sum(A1:A2)
5. Click on B1 cell, press Shift key and click on B2 cell. Now both B1 and b2
cells are selected.
6. Click on "Merge and Center Cells" to merge selected cells (B1 and B2). Works
fine.
7. In Cell C2 type in formula: sum(A1:A2)
8. Click on C2 cell, press Shift key and click on C1 cell. Now both C2 and C1
cells are selected.
9. Click on "Merge and Center Cells" and now dialog opens with question:
"Should the contents of hidden cells be movied into the first cell?" with
Yes/No/Cancel options.
10.
a) Pressing Cancel, merge is canceled. Works fine.
b) Pressing No, cells are merged and all content lost. Works fine.
c) Pressing Yes, and value "300" is copied from C2 into cell C1. This is not
fine.
I expect to formula in C2 to be copied into C1, so after pressing Yes I expect
to have formula =sum(A1:A2) present in cell C1. But it looks like value is
copied instead of formula. In my humble opinion step 6 and step 9 should result
in the same state, having formula in cell after merge.
P.S. If you think this is not a bug, then at least there should be this bug
marked as "enhancement".
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
