https://bugs.documentfoundation.org/show_bug.cgi?id=62289
--- Comment #30 from Eike Rathke <[email protected]> --- Again took a look at this. There's no real fix for it without quite a rewrite. The link target picker doesn't know anything about a spreadsheet or whether a name is a sheet name or anything else, the link targets like sheet names, named ranges, et al are obtained through css::document::XLinkTargetSupplier as css::container::XNameAccess interfaces that are also part of the API and used in other context, it can't return anything else than just the sheet name. So, if you happen to have a sheet named like a column name or row number or cell reference or named/database range then append .A1 or any other cell reference to use it as a jump target. The other way we could solve *this* would be to take priority on existing sheets, i.e. if a sheet name exists for the link target then use that instead of any cell reference, column or row number or named/database range. Which can be equally wrong as it would make jumping to such target impossible that can not be workarounded. YMMV. Given that appending a cell reference works it is the better approach. Maybe on the long term someone wants to implement another XNameAccess interface holding objects that deliver sheet names appended with a .A1 cell reference just for this XLinkTargetSupplier case. -- You are receiving this mail because: You are the assignee for the bug.
