在已发布的Google表格中导航 [英] Navigation in published Google Sheets

问题描述

我需要发布我在Google表格中拥有的报告，但是由于该报告非常大，包含许多表格和表格，因此我设置了超链接以便于导航，从而可以将您带到其他表格中.

I need to publish a report I have in Google Sheets, but since the report is very big, with many sheets and tables, I have hyperlinks set up for easy navigation, that take you to ranges in other sheets.

当我发布工作表时，超链接会停止工作(它们会将您带到新浏览器选项卡中的第一个工作表).我也尝试使用脚本来更改带有按钮的页面，但是在已发布的页面中该按钮不可单击.

When I publish the sheet, the hyperlinks stop working (they take you to the first sheet in a new browser tab). I also tried with a script to change the pages with a button, but the button is not clickable in the published page.

感谢您可能提出的任何提示.

Thanks for any tips you might have.

我已经准备了一张测试纸，以查看是否找到解决方案.这是一个具有编辑权限的链接:

I've prepared a test sheet to see if I find a solution for this. This is a link with permissions to edit:

https://docs.google.com/spreadsheets/d /1ZGw_6WjrkcNKdFvS8gIG46gEMfMuw7ex86SR9C7qXTU/edit?usp = sharing

这将是发布的版本:

https://docs.google.com/spreadsheets/d/e/2PACX-1vTa8JDNMzwdvk87kCvbjJXYgK2RGiKy503eJn6eEjxbyU8oIsuvuKTNXCM6yRP16KXrnD9yvLV3J488/pubhtml

这实际上在Excel中有效，我可以嵌入报表，并且超链接仍然可以正常工作，但是Google表格中还有其他所有内容，因此我想找到一种解决方法.

This actually works in Excel, I can embed the report and the hyperlinks still work fine, but I have everything else in Google Sheets, so I'd like to find a workaround.

推荐答案

您需要使用适当的查询参数.必须将工作表ID gid设置为正确导航.您不能使用rangeid.但是，您可以使用range.

You need to use proper query parameters. The sheet id, gid must be set to navigate properly. You cannot use rangeid. You can however use range.

/pubhtml?chrome=false&gid=[YOUR_SHEET_ID]&range=A1:B1

您可以通过访问电子表格(编辑版本)中的工作表(标签)并检查网址来获取工作表ID.

You can get your sheet id by visiting your sheet(tab) in your spreadsheet (edit version) and inspecting the url.

这篇关于在已发布的Google表格中导航的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！