Description: Excell has a "CELL" function that allows to take the currently active cell and use it. The active cell is the one that is clicked with the mouse. To date, there is a "Cell" function in Calc that takes only the cell where the formula is entered. Some users previously created documents in MS Office to automate part of the routine, tying their xlsx files to the behavior when the "CELL" takes the current mouse-selected cell. In particular, on the "CELL" behavior, some implement auto-completion of the input data. Perhaps it is worth adding a similar function, such as "ActiveCell" to Calc? Actual Results: Expected Results: Reproducible: Always User Profile Reset: No Additional Info:
This is indeed a compatibility issue, even though the definition of ODF CELL is fixed [1] and different from Excel's CELL [2]. [1] https://docs.oasis-open.org/office/OpenDocument/v1.4/csd01/part4-formula/OpenDocument-v1.4-csd01-part4-formula.html#__RefHeading__1018348_715980110 [2] https://support.microsoft.com/en-us/office/cell-function-51bd39a5-f338-4dbe-a33f-955d67c2b2cf
*** This bug has been marked as a duplicate of bug 106151 ***