Closed Noah-Chiu closed 2 weeks ago
Thanks for your issue. The MergeCell
function doesn't remove cell value except for the upper-left cell in the merging cell range, so this behavior is expected. If you need to clear cell value, please use the SetCellValue
or another function to set nil
value for these cells before merging cells.
I've closed this issue. If you have any questions, please let me know, and you can reopen this anytime.
Description
Steps to reproduce the issue:
Describe the results you received: When I select the merge cell and it display that there are 2 cells in my selection And when I unmerged the cell, it still got two cells in the sheet instead of one cell Still count 2 when I use excel formula to count Still sum 19.38 when I use excel formula to sum
Describe the results you expected: It should be one cell in my selection And when I unmerge it, it should be only be cell have the value
Output of
go version
:Excelize version or commit ID:
Environment details (OS, Microsoft Excel™ version, physical, etc.): Microsoft 365