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: 184.108.40.206 (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
type formula into a cell, merge that cell with another, formula is gone, but the "asnwer" is still there.
The formula should carry into the newly merged cell.
User Profile Reset: Yes
[Information automatically included from LibreOffice]
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Created attachment 165046 [details]
Build ID: a726b36747cf2001e06b58ad5db1aa3a9a1872d6
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3;
Locale: ro-RO (ro_RO.UTF-8); UI-Language: en-US
See the video
Created attachment 165047 [details]
working another case
Now in this second video I merged 2 cells, both contaning formula. In this case in the first situation I lost the formula, but keep the values, because I can not have 2 formula in a cell. In the other 2 cases I keep the formula and the result.
Created attachment 165048 [details]
case with #
When you have # you can double click on the line between cells and everything would be fine. See the video. No need for merge.
Have you tested?... Please come back with your test results.
I cannot reproduce your suggested fix to double click on the line of the cell, it just clicks in the box to start typing a new value.
[Automated Action] NeedInfo-To-Unconfirmed
Hi, Ray, have you watch all 3 videos? (one in comment 1, one in comment 2 and one in comment 3). If you can NOt see the video right click and download them, and watch with your mediaplayer.
This looks like a duplicate of Bug 93202, which I marked as a duplicate of 89951.
*** This bug has been marked as a duplicate of bug 89951 ***