Description: i have bug with =sum, when i add up merge cells, results are incorrect Steps to Reproduce: 1. I merge 4 cells in one (a:1-a:4) 2. I write in this cell number 44 3. under this merge cells, in a:5 cell I use function =sum(A:1) 4. it give me result 70, but should be 44 Actual Results: 4 merge cells with one number "44" give me sum "70" Expected Results: 4 merge cells with one number "44" should give me sum "44" Reproducible: Always User Profile Reset: Yes Additional Info: fix this pls :)
Please attach a sample file.
>I use function =sum(A:1) Are you sure? I got the #NAME? error when I tried to use this strange (and wrong) function
Created attachment 185188 [details] Sample file from reporter Please attach documents and add your comments here, don't send private emails, except if it is essential. By unmerging A9:A12 you can see that all cells have data, SUM(A10:A12)=49 just your difference. When merging cells, LO ask about how to manage the content of hidden cells. No bug.
Please in the future if you have questions like this one, post it on the forum, https://ask.libreoffice.org/c/english/5, it is available in several languages.