Description: In HyperLink, "#C" does not activate the sheet name "C" and selects the cursor column. Steps to Reproduce: 1. Open new Calc 2. Enter =HYPERLINK("#C") in the cell "A1" 3. Add a sheet and make the name "C" 4. Hyperlink entered in "A1" function Actual Results: 5. The column of the cursor will be selected Expected Results: 5. Activate the sheet name "C" Reproducible: Always User Profile Reset: No Additional Info: "#A"--> Activate Sheet Name "A" "#B"--> Activate Sheet Name "B" "#C"--> Select Cursor Column "#D"--> Activate Sheet Name "D" "#E"--> Activate Sheet Name "E" I checked the five cases, but "#C" is not consistent. --- --- It may be related to this bug. Bug 62289 - Adding hyperlinks via the GUI to other sheets with only a number for the name in the same work https://bugs.documentfoundation.org/show_bug.cgi?id=62289 --- --- I confirmed the problem with the following system Version: 7.4.3.2 (x64) / LibreOffice Community Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 CPU threads: 4; OS: Windows 10.0 Build 10240; UI render: default; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: threaded Version: 7.6.1.2 (X86_64) / LibreOffice Community Build ID: f5defcebd022c5bc36bbb79be232cb6926d8f674 CPU threads: 4; OS: Windows 10.0 Build 10240; UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: CL threaded
Created attachment 189640 [details] sample file
For me, clear a duplicate of tdf#62289. Please take a look of comment 30. https://bugs.documentfoundation.org/show_bug.cgi?id=62289#c30 *** This bug has been marked as a duplicate of bug 62289 ***
Not Reproduced with LibreOffice Portable Version 4.4.3.2
Version 5.0.0.5 #C is Sheet C. #R is Sheet R. --- Version 5.1.0.3 Version 6.4.7.2 #C is First Column. #R is First Row. --- Version 7.3.7.2 Version 25.2.0.0.alpha0+ #C is Current Column. #R is Current Row.