Hi,
Is it possible to have hyperlink text in the spreadsheet ?
Also, some functions are not operation in spreadsheet. Is it possible to make all Excell functions working in the spreadsheet I integrated todolist ?
Thanks.
Hyperlinks in spreadsheet Topic is solved
Moderator: abstr
Re: Hyperlinks in spreadsheet
What kind of hyperlinks are you referring to? The TDL Comments spreadsheet does support hyperlinks to files and URLs for example. It also supports hyperlinks to other TDL tasks, however I have encountered a bug with this that I have not been able to document yet. It works sometimes but not others.
It's cool having the integrated spreadsheet to use for comments, but it has only very basic calculating, editing and formatting abilities. I use it just for simple lists and things like that, but use an external dedicated spreadsheet program (primarily Excel) for anything more complicated.
It's cool having the integrated spreadsheet to use for comments, but it has only very basic calculating, editing and formatting abilities. I use it just for simple lists and things like that, but use an external dedicated spreadsheet program (primarily Excel) for anything more complicated.
Re: Hyperlinks in spreadsheet
Unfortunately not. Excel has been in development 30+ years and has 10s of developers working on it. Also I didn't write this component so my ability to fix some of the internals is limited.
Yes. Right-click a cell and change its type to 'Hyperlink' or just paste a URL into a cell.
Re: Hyperlinks in spreadsheet
Hi,
I've written an text in a cell and changed a cell type to hyperlink. However, how can I add link behind that text ? When I right click on the text, there is no option to add link. Just the text turns blue and an underline appears. But the cell nor the text have links. Would you please tell me how to do it ? Thanks
I've written an text in a cell and changed a cell type to hyperlink. However, how can I add link behind that text ? When I right click on the text, there is no option to add link. Just the text turns blue and an underline appears. But the cell nor the text have links. Would you please tell me how to do it ? Thanks
Re: Hyperlinks in spreadsheet
If you type a URL in the cell for example, you shouldn't even have to select hyperlink as the cell type, it should automatically select it after you type in the URL.
Example:
Type 'http://www.google.com' in a cell
It should automatically select the 'Hyperlink' cell type.
Press the control key and click on the link to go to the link.
If you are asking whether there is a way to display the link as alias text instead of the actual hyperlink text, I think the answer is no. You can only display the link text not an alias.
Hope this helps.
Example:
Type 'http://www.google.com' in a cell
It should automatically select the 'Hyperlink' cell type.
Press the control key and click on the link to go to the link.
If you are asking whether there is a way to display the link as alias text instead of the actual hyperlink text, I think the answer is no. You can only display the link text not an alias.
Hope this helps.