https://bugs.documentfoundation.org/show_bug.cgi?id=147221
--- Comment #1 from Jim Avera <jim.av...@gmail.com> --- When a cell is referenced in a formula in another cell: If the referenced cell content moves as a result of merging adjacent cells, the reference is not updated to refer to the new position. STEPS TO REPRODUCE: (See attached test.ods spreadsheet) 1. Create a spreadsheet with something in cell B2 2. Reference B2 in a formula in some other cell e.g. "=1/B2" 3. Select B1 & B2 4. Format->Merge and Unmerge Cells->Merge RESULTS: The formula breaks, because the value which was in B2 is moved to B1 but the reference was not updated to track it. NOTE: When merging cells, if more than one of the merged cells contains content the user is offered a choice of how to handle the conflict (move all content to the first cell, which is the default; keep hidden cell content as-is; or delete the content of now-hidden cells). References should be updated only when content is moved, i.e. when combining all merged cells into the first cell. -- You are receiving this mail because: You are the assignee for the bug.
