OS version: macOS Sequoia 15.0
App version: 8.1.1
Downloaded from: ONLYOFFICE website
When creating or editing the function which includes a cell range (e.g. B2:B8) changing cell references by using the F4 key does not work. The F4 key only works on single cell references such as C2, but not a range such as B2:B8. Is there any way to fix the reference other than by manually entering preceding $ characters in the reference to the cell range?
Hello @steelenz
Information on how to change cell reference type on macOS was provided in your previous topic, please see it here:
Placing a cursor into the referenced array and using mentioned combination Fn+F4 will change reference type.
Please try to avoid creating duplicate posts. I will close your previous topic, continue communication in this one if you face any difficulties.
Hello @Constantine
Thank you for your remarks. However, this does not solve the problem when the cell reference is to another sheet of the same spreadsheet file. In this case, the F4 key neither works for single cell references (e.g. Sheet2!A1), nor references to a cell range (e.g. Sheet2!A1:A7). Is there a solution for this?
Hello,
Sorry for the delayed response. I’ll join this thread too. We are currently analyzing the issue, thank you for sharing
Hello @steelenz, sorry for it taking so long, we have registered the relevant bug in our bug tracking system regarding the fact that F4 is not working for the above-described scenario and will be working on the issue. Currently, there is no solution available
