https://bugs.documentfoundation.org/show_bug.cgi?id=154075
--- Comment #1 from ady <[email protected]> --- As of: 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 Currently the cycle goes like this: 0. $Sheet2.A1 < this is before pressing F4. With successive F4, the cycle currently continues as: 1. Sheet2.$A$1 2. Sheet2.A$1 3. Sheet2.$A1 4. Sheet2.A1 5. $Sheet2.$A$1 6. $Sheet2.A$1 7. $Sheet2.$A1 8. $Sheet2.A1 > we are back to the same status as step 0 above. The suggestion is for the F4 cycle to work as follows: 0. $Sheet2.A1 < this is before pressing F4 (no change) 1. $Sheet2.$A$1 2. $Sheet2.A$1 3. $Sheet2.$A1 4. Sheet2.A1 5. Sheet2.$A$1 6. Sheet2.A$1 7. Sheet2.$A1 8. $Sheet2.A1 > we are back to the same as step 0 above. So, the suggested cycle changes nothing regarding rows and columns. FWIW and FYI, a little bit of background history... Absolute and relative references for cells/rows/columns are supported in every spreadsheet software, but relative references for worksheets is not as widely supported, and thus it is a less-known feature. Users that are unaware of the existence of relative references for worksheets used to complain that some formulas didn't work when copying entire worksheets several times (e.g. more than 2 worksheets with the first one as "template" or as “summarize”, or one plus a dozen worksheets that were not working all the same as they expected) and so they used to report the behavior as a bug; that is, without anyone knowing that the real problem was that the worksheets' references were relative, instead of the "expected" absolute reference, which was the only type they knew. The repetitive reports, forum posts, investigations and explanations were all reduced when the default worksheet reference was set as absolute instead of the prior relative reference. This was a few years back already. For most users, the suggested modified cycle should not have negative consequences, and the amount of F4s might probably be reduced rather than increased. -- You are receiving this mail because: You are the assignee for the bug.
