@parthiveera,
You shall update both GridJs server package and client js.
You may download/get the client js: gridjs speradsheet here:
https://www.npmjs.com/package/gridjs-spreadsheet/v/25.5.0
Also, you may download/get the server side dll: Aspose.Cells.GridJs v25.5 from Nuget repos. here:
https://www.nuget.org/packages/Aspose.Cells.GridJs/25.5.0
@parthiveera
the latest demo is here:
.net
https://github.com/aspose-cells/Aspose.Cells.Grid-for-.NET/tree/master/Examples_GridJs
java
https://github.com/aspose-cells/Aspose.Cells.Grid-for-Java/tree/master/Examples.GridJs
python
https://github.com/aspose-cells/Aspose.Cells.Grid-for-Python-via-.NET/tree/main/Examples.GridJs
I have implemented the option to disable cell editing, but I have one more question. I need to freeze and disable the first row in Excel using JavaScript. Can you share a code snippet for that?
image.png (2.8 KB)You may try the following API to set the freeze panes in the worksheet:
xs.sheet.data.setFreeze(ri,ci)
// the parameters are:
ri:row index
ci:column index
Moreover, see the document on how to use GridJs client APIs: Working with GridJs Client Side|Documentation
We will also devise example code to accomplish your task (e.g., freeze and disable first row in the sheet) on client side and get back to you soon.
@parthiveera
please try xs.sheet.freeze(1,0)
if you want unfreeze, just try xs.sheet.freeze(0,0)
sheet.freeze deals with both data freeze and images freeze
Thank you. Freezing the first row is working fine. However, I also need to disable cell editing for the first row. Could you help with that? Also, I want to hide the bottom label that displays values like count, average, min, and max. How can I achieve this in the latest version of Gridjs?
image.png (16.5 KB)Good to know that freezing rows feature works for your needs. Regarding your other requirements (e.g., disable cell editing for the first row and hide the bottom labels), we will soon devise code snippet and share with your for your needs.
@parthiveera
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-1714,CELLSGRIDJS-1715
CELLSGRIDJS-1714 Support APIs to enable /disable editable range in client js
CELLSGRIDJS-1715 Support options to hide the bottom label that displays values like count, average, min, and max
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.
I noticed that tickets CELLSGRIDJS-1714 and CELLSGRIDJS-1715 are marked as resolved. May I know when the latest version including these fixes will be available?
One more query — in Excel, we can select multiple cells and copy the data. However, in Grid.js, when I press Ctrl and try to select multiple cells, it doesn’t allow selecting multiple cells across the grid.
Could you please confirm whether Grid.js supports multi-cell selection across rows and columns? If yes, is there any configuration required to enable it?
Yes, both tickets have been resolved. This fixes/enhancements will be included in the release (Aspose.Cells.GridJs v25.7) scheduled for the first half of July 2025. We will inform you once the next version is released.
Aspose.Cells.GridJs may not support multiple cells selection via Ctrl key although it allows to select a continuous range of cells via Shift key. 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 support policies.
Issue ID(s): CELLSGRIDJS-1755
Once we have an update on it, we will let you know.
Implementing the ability to select multiple cells using the CTRL key in the grid is a highly complex task that requires extensive modifications. As a result, this feature will not be available in the near future. However, we will provide updates here as progress is made toward its implementation.
The issues you have found earlier (filed as CELLSGRIDJS-1714,CELLSGRIDJS-1715) have been fixed in this update. This message was posted using Bugs notification tool by leoluo
I am frequently encountering the attached error after upgrading to the latest version of Grid.js. Could you please help me understand why this error is occurring? Also, is there a way to hide or suppress this type of error?
image.png (11.8 KB)Thanks for the screenshot.
We apologize for the inconvenience caused by this error. Could you please provide more details, including sample file(s) and the steps to reproduce the issue on our end? We will look into it soon.
@parthiveera
When you do edit operation at the cell area which is read-only, it will occur. Can you provide more details, sample files and steps? We will check your issue soon.
We have upgraded to version 25.7. Could you please share the JavaScript code snippets required to implement the following tickets in our code?
Additionally, we have a query regarding Aspose error popups. These errors are triggered when clicking on read-only cells, but we would prefer not to show such alerts to users.
Is there a way to suppress or hide all Aspose-related error popups using JavaScript?
Looking forward to your guidance
@parthiveera
If the cells are read-only and no error popups, users will be confused too. They would be puzzled why they cannot edit.
I think we can provide a property to hide all error if you insist.
yes. can you provide a property to hide all error?. and Could you please share the JavaScript code snippets required to implement the following tickets in our code?
@parthiveera
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-1793
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.
@parthiveera
please refer to the below doc guide :
to set readonly/editable range
you can use :
xs.sheet.setEditableRange(range,isenable)
// the parameters are:
range:the cell range ,etc. {sri:0,sci:0,eri:2:eci:2} reprensents range start from cell A1 to C3
isenable:when set to true,the range is editable.other wise,the range is readonly.
to disable the display of statics :
you can set the showBottombarStats in loadoptions to be false.