https://bugs.documentfoundation.org/show_bug.cgi?id=101124
Bug ID: 101124
Summary: MERGE and centre cells loses formula
Product: LibreOffice
Version: unspecified
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: rob...@iafrica.com
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:47.0)
Gecko/20100101 Firefox/47.0
Build Identifier: LibreOffice 5.2.1.0.0
If I create a formula in a cell, and I then want it to act in a merged group of
cells, the formula is converted to text.
Say I want this to be part of a heading across multiple columns.
Reproducible: Always
Steps to Reproduce:
1. create formula in a cell
2. select 2 or more cells
3. select "Merge Cells"
4. the formula is converted to text
Actual Results:
formula converted to text
Has been doing this in previous beta versions
does the same in LO 4.4.3.2 so is not a new issue.
work around is to merge cells first, then to paste formula into merged cells,
however, this is counter-intuitive, especially for persons who have to use MS
Excel a lot
Expected Results:
Should keep the formula, or there should be an option to do so.
not apply relative addressing changes, since this is a move (cut&paste), not
copy, if it has to move the formula to the first cell.
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Reset User Profile?No
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs