https://bugs.documentfoundation.org/show_bug.cgi?id=171298
--- Comment #1 from ady <[email protected]> --- (In reply to Christophe N from comment #0) In English: Steps to Reproduce: 1. Cell B1: =TODAY() 2. Merge range of cells A1:C1 Actual Results: The formula in cell B1 is replaced by its value in case of cell merging 3. Cell B3: =FORMULA(B1) 3.1. The result in cell B3 is #N/A, meaning there is no formula in cell B1. 4. Unmerge range A1:C1 4.1. Cell A1 ends with the value of today's date, and nothing in cells B1:C1. The key point here is that the initial formula is not located on the "first" (upper-left) cell of the merged range (i.e. in cell A1 of the merged range A1:C1). If the initial formula were located at A1, it would work as expected. I am not sure this should be considered as a bug. Generally speaking, the Merge action takes the "first" content and (sort of) "expands" it to the rest of the merged cells. So, maybe this is just WF(?). -- You are receiving this mail because: You are the assignee for the bug.
