Perhaps this bug will be classified in non-bug problem, but for me it is a critical problem : When you use many cells in one cell fusion, the system asks you to chose between putting values of all previous cells in the surving one, or not (using i must admin the terms "hidden cells"). The first choice (to Keep) is frequently useless, creating a non-calculable array of values and forcing you to select and delete the cell content, the re-type a new value, so your habbit is to choose the second choice, wich appears rendering the same result you could have in Excel : only the value of the first cell survives, (wich in estimate works is often the good one...) The big problem is that all the old cells has survived as hidden cell, why not, but their values keep counting in the SUM and all other calculations ! And never, never you will fusion cells in order to keep the previous cell in your calculations, if there is not a clear warning, you cannot imagine that it will be the logical behaviour.
If you agree, this bug can be marked as duplicate of bug 30456. The new dialog coming with 5.3 version is more clear.
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping-20170502
*** This bug has been marked as a duplicate of bug 30456 ***