https://bugs.freedesktop.org/show_bug.cgi?id=62289
--- Comment #12 from V Stuart Foote <[email protected]> --- (In reply to comment #5) @Eike, > The full syntax to address a cell is #Sheet.ColRow, so for you example to > jump to sheet 100 cell A1 it would be #100.A1 and that works. Giving only a > number is a shortcut to jump to a row in the same sheet. This is not a bug. With the default row short cut you describe, what cell should you end up in in the numbered row? Also, this issue is occurring when using the Insert > Hyperlink GUI sheet picker for a "Target in document". The hyperlink entered as a number should not behave that way from the sheet picker--since it is a sheet name that is valid. Why should an incomplete hyperlink to a sheet with a numeric name not work, but an incomplete hyperlink to a sheet with a string name work--sort of. So suspect there is a test for string that is failing. And neither incomplete hyperlink takes you to the cell in a sheet where you'd expect which could lead to unwelcome results. Suggest the "Target in Document" validation logic for sheets needs a little tweaking to not generate a hyperlink that is fully addressed--rather than leaving a number that gets interpreted as a row short cut. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
