https://bugs.documentfoundation.org/show_bug.cgi?id=172349
Jörn Kaster <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|NOTABUG |--- Ever confirmed|0 |1 Status|RESOLVED |REOPENED --- Comment #3 from Jörn Kaster <[email protected]> --- (In reply to ady from comment #2) > The default behavior is not to destroy / overwrite data, unless the user > explicitly does it. > > You can copy the content of one cell to the others, and then merge them. You > could even do it after the cells are already merged, but it is slightly more > cumbersome so I would suggest to separate the merged cells, copy the content > of the first to the rest, and merge them again. While you merge them, Calc > will ask you whether to keep the values of each cell, and there are 2 > additional possibilities you could select. > > Please keep in mind that this also allows for each cell to have different > values, even when they are shown as merged. > > Calc must keep its standard reference methods, even for merged cells. > > This is not a bug. thank you for your answer and advice. I think this is not a wanted behaviour in case of productivity. When i merge cells, then i want all the merged cells to hold the value that is shown. Not a value that is not shown. Also if i later write a new value in the merged cells, i want to retrieve the shown value from all of the merged cells. Not just from the first one. I think this is not a behaviour anyone expect from the merge cells feature in spreadsheets. Probably this is not a bug, but i think an unwanted behaviour it is definitely. -- You are receiving this mail because: You are the assignee for the bug.
