Accessing additional sheets in GridJS

@billkamm
Below is the updated index.html file which may work as per your expectation.
Please have a pre-review.
index.zip (5.5 KB)
You need to update to v23.7 version. We now add new APIs: xs.sheet.clearHighlights and xs.sheet.updateHighlightStyle and a new event sheet-loaded. We just simply use the addhighlight_in_sheet method instead of very complicated method drawRedactions for adding highlight process.
We use shape.setVisible method (which will work after image is loaded) instead of the visiblefilter (which will work before image is loaded from server).

We will soon publish the v23.7 release may be tomorrow.

Stay tuned!

The issues you have found earlier (filed as CELLSGRIDJS-852) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi

@billkamm
now you can update to our latest version v23.7.0. ,… wait for your feedback.
the latest dll
the latest js

After implementing these changes in our project I’ve run into an issue where xs.isLoaded() sometimes gets stuck never being true, so the setTimeout features in some of these methods end up in an infinite loop

    const tryWaitImageReadyDoSetVisible = () => {
    if (!xs.isLoaded()) {
        setTimeout(tryWaitImageReadyDoSetVisible, 500);
    } else {
        setAllImageShapeVisibleStatus();
    }

I haven’t been able to an exact steps to reproduce to send you an example yet, but it seems to happen after I set one of these such as hide highlights or add transparency and then switch between sheets and try again

@billkamm,

Thank you for your feedback. We will be looking into it and getting back to you soon. Additionally, we would appreciate it if you could provide us with a sample project/example and detailed steps to reproduce the issue on our end. This will help us evaluate the issue precisely and find a solution quickly.

@billkamm I also had an issue with loading state in 23.7.0. You may want to check the repro steps at Images are rendered in incorrect location if sheet is scrolled before image is loaded (gridjs-spreadsheet) - #19 by jrf.att to see if it’s the same problem.

@jrf.att
We’ve fixed this issue.It seems the issue has the same root cause from Images are rendered in incorrect location if sheet is scrolled before image is loaded (gridjs-spreadsheet)
We will send out new release version soon in this week.

@jrf.att
please try the latest v23.8.0 GridJs dll and the client side js ,the issue shall be fixed.

In read only mode we can’t access the text inside of a textbox object. Our application allows users to highlight text inside of a textbox object, but doesn’t want users to be able to delete or edit the text. Would it be possible to make read only mode the way it was where you could select objects and the text within without being able to delete or edit objects or the data in the sheets?

To simplify I would like to be able to select text within a textbox object while in read only mode

it would be nice to still have the selection indicators on the images and shapes as well and being able to move them still like before would also be a plus

@billkamm,

Thanks for sharing details about your new requirements. We will evaluate your needs and get back to you with details.

@billkamm
We will support select text within a textbox object while in read only mode.
We will support select on images/shapes in read only mode.(for move operation we don’t think it is suitable in read only mode)
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSGRIDJS-897,CELLSGRIDJS-898

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

1 Like

@billkamm
Please try the latest client js v23.8.2
It changes the selection behavior for read mode. Please feedback to us if you meet any issue.

There appears to be issues with the highlights disappearing when you click on some objects and also at times it looks like there is two sets of bordered outline around the stuff that is clicked and I also no context menu appears when I right-click inside of a textbox. I did check our existing functionality and we don’t need to highlight the text inside of the textbox as long as we can right-click the object and get a context menu

appears to be two squares and highlight disappears.gif (61.6 KB)
right-click no context menu.gif (30.9 KB)
highlight disappears when clicked.gif (29.6 KB)

@billkamm,

Thank you for providing the screenshots. We have recorded your findings and concerns in your relevant existing tickets. We will evaluate the mentioned issue(s) and get back to you soon.

@billkamm
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSGRIDJS-902

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

@billkamm
We have adjusted the textbox selection behavior a little. For left-click on the textbox, it enters the text mode and the text can be selected, but it will not show the highlight effect. For right-click on the textbox, it still remains in image mode and displays the highlight effect, and the right context will be shown as normal.
Please try the latest client js v23.8.3.

The issues you have found earlier (filed as CELLSGRIDJS-897,CELLSGRIDJS-898,CELLSGRIDJS-902) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi

I’m still experiencing issues with some highlight not hiding when I hide all highlights in this latest version