[Libreoffice-bugs] [Bug 136405] New: Merging Cells Removes Formulas

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=136405

            Bug ID: 136405
           Summary: Merging Cells Removes Formulas
           Product: LibreOffice
           Version: 6.2.7.1 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: bhurtwork at gmail.com

Description:
When merging a Cell into another Cell, the program copies the "answer" of the
cell contents into the new cell. This needs to be reworked to copy the formula
used into the new cell. When you have a complicated formula and realize you
need to merge because the answer is #### and word wrap isn't working correctly
(that is, when disabled on right justification, the results should overflow
into the left box when it's empty, another bug I guess.) then you need the
formula to be carried over that when if the input changes, then the results
change. However as current, you have to remake the formula, which is not only
tedious, but also counter productive. Safe Mode also allows this issue to exist 

Version: 6.2.7.1 (x64)
Build ID: 23edc44b61b830b7d749943e020e96f5a7df63bf
CPU threads: 8; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded

Actual Results:
type formula into a cell, merge that cell with another, formula is gone, but
the "asnwer" is still there. 

Expected Results:
The formula should carry into the newly merged cell. 


Reproducible: Always


User Profile Reset: Yes



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200902/acebb787/attachment-0001.htm>