https://bugs.documentfoundation.org/show_bug.cgi?id=154075
--- Comment #5 from ady <[email protected]> --- (In reply to Justin L from comment #4) > please provide the > exact formula/steps that you are following to trigger this cycle. Using: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 0484a9a3f5e2ecb678f6fb41bbb251529e89c00d CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: CL threaded Built 2023.03.07 1. Open new Calc with Sheet1 and Sheet2 2. With the focus on Sheet1.A1, click on the "=" icon on the Formula bar. 3. Click on Sheet2's tab. 4. Click on Sheet2.A1 (do _not_ press [enter]) 5. Currently the Formula bar shows $Sheet2.A1 (step 0), still in edit mode (the formula is not yet fully introduced). By pressing F4 we cycle: Sheet2.$A$1 Sheet2.A$1 Sheet2.$A1 Sheet2.A1 $Sheet2.$A$1 $Sheet2.A$1 $Sheet2.$A1 $Sheet2.A1 > we are back to the same status as step 0 above. At any given step, we can press [enter]. Evidently, when users type-in the formula, there is no "default" type of reference, other than whatever they typed-in. From that point, the cycle should be in the same order as I described, depending on what they initially typed-in. The concept of "default" references are relevant for 2 alternative situations: * when clicking on the cells (while building the formula; that is, the function is typed-in, and the arguments are selected by mouse+click); or, * when using the Formula wizard, in which case the "default" type of references varies depending on the function and the argument. Unfortunately, while using the Formula Wizard (whether in full mode or shrink mode), the F4 key doesn't work (I wished it would, because it saves a lot of time when it works in it, in other spreadsheet programs). So I am mentioning here the first alternative, as I just described. Hopefully this clarifies the steps / procedure. From it, I am suggesting to change the behavior as I posted in comment 1. -- You are receiving this mail because: You are the assignee for the bug.
