Hi,
Is there any method like excle hyperlink that set the sheet and cell to make spreadsheet jump to that cell?
Good day @coony ,
There is an Excel-like Hyperlink function.
At the moment, it accepts only url that opens an external page or a document.
However, it is possible to override the existing method to achieve the expected behavior: Code Snippet .
We will add this feature in one of our future releases, and now you may use this workaround.
Thank you, it’s great news for me!
Hello @coony ,
With the release of Webix 10.0.1 it is possible to add links to the cells, ranges or named ranges in HYPERLINK (via #).
Here is an example: Code Snippet .
Notice that the cell adress is shown in the block at the photo where it is also possible to write a link to show a cell.
Also a showCell method has been added in the new version.
@MariyaDemy hello, I find scrollbar in spreadsheet UI which use with Firefox broser(version 107) have a problem.
That scroll bar wouldn’t be used. Like the picture( that is invisible)
Thank you, @coony .
Now I am able to reproduce the issue. We will fix it in one of our future releases.
Hi, @MariyaDemy I encountered a problem that I tryied to edit a cell on sheet,
but I need it in multimple line in same cell.
I tried to use “<br>”, it also can be complete the template.
I need like method, alt+enter, of EXCEL to reach that hot key.
Hello, @coony
If you just need to wrap the text inside the cell, you can use text wrap
Otherwise, you are right, it’s necessary to use
.
In case you’d like to use hotkey, please, use the following customisation (necessary to avoid default on enter behavior): Code Snippet
@MariyaDemy
When do you fix this bug? It is very IMPORTANT for me.
Otherwise how can I adjust this setting?
Hello @coony ,
Here is the information from our developers: starting from version 100, FF uses the native Ubuntu scrolling mechanism, which means that they do not reserve space for the scroll, but draw a marker over the scrollable content when the mouse is over it.
This approach works well for our widgets like a list and other widgets where a native scroll is used, but not for a datatable (which is a part of the Spreadsheet) where vscroll is used that simply draws the scroll separately from the active area.
At the moment, there are only two options to solve this problem/deal with this feature.
It can be solved on the client side - by disabling the option described in the discussion below :
Or by enabling our CustomScroll (in this case our software scroll is used, which works the same on all platforms).
@MariyaDemy
OK, thank you .
And I have another question.
I have an exsit spreasheet I hope increase convenient for use.
When user key in spreadsheet, they can use keyboard to operate like, type ‘tab’ can move to next cell need to type.
How can I achieve like that?
My exist spreadsheet is:Code Snippet
In this spreadsheet, when I press tab can focus next need to key in cell (blue cell)
Hello @coony ,
Am I right that you need the following: when a user types, for example, “tab” in a cell and presses enter, then it behaves as if tab button was pressed (focus moves to the next cell to type in it)?
YES,ALMOST like that. And I need to the next like the pic. When I press TAB , focus will move to the next blue cell ( need to keyin ). the locked cell autolly skip.
OK, thank you ver much.