@salah010
If you have any additional customization requirements, feel free to bring them up. We will analyze/investigate one by one . Subsequently, we will incorporate them into our product version cycles based on the development progress. If your requirements have a more urgent time constraint, you may opt to purchase our priority service. In that case, we will fulfill your needs according to the level of priority assigned.
for the above ticket:
CELLSGRIDJS-1620
We 've planed to support it in v25.5 version which is expected to be published next month.
We also noticed that the “search functionality” (with a search icon) is built into the GridJs plugin UI. However, we want to “trigger and control the search programmatically” from our Angular application — for example, from a custom input field or button “outside” the GridJs-spreadsheet interface.
Could you please provide:
- The public method (if available) to “trigger a search” in the loaded spreadsheet
- How to programmatically go to the “next” or “previous” match
- Any examples or usage patterns for integrating this with a custom UI
This would help us better integrate the spreadsheet experience into our existing UI.
Thanks once again!
@salah010
For a UI operation ,search feature is yet not designed as open APIs,however we can encapsulated it and provide as open APIs.
@salah010
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-1622
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.
Hi Aspose Team,
Is there any event or callback provided by GridJs that triggers when the active sheet changes?
We would like to hook into this event to perform custom logic (e.g., log analytics, update UI components, or trigger other application behaviors) whenever the sheet changes.
If this event is not available out of the box, is there any suggested workaround or a way to track this through the GridJs instance?
Thank you!
I think you may try to use Aspose.Cells.GridJs’ sheet-selected event that triggers when the active sheet changes. You can use the sheet-selected event to detect when a user switches between sheets. This event provides both the sheet ID and name, allowing you to perform custom logic accordingly. See the following threads for your complete reference.
https://forum.aspose.com/t/gridjs-spreadsheet-event-for-object-selection/263456/6
https://forum.aspose.com/t/accessing-additional-sheets-in-gridjs/264128/19
Hope, this helps a bit.
@salah010
You can use
sheet-selected
or
sheet-loaded
event.
when clicking worksheet, it will raise sheet-selected event .
when worksheet is loaded, especially for images/shapes in the sheet were loaded, it will raise sheet-loaded event .
xs.on('sheet-selected', (id,name) => {
console.log('sheet selected id:', id, ', name: ',name);
}).on('sheet-loaded', (id,name) => {
console.log('sheet load finished:', id, ', name: ',name);
})
Please check the below document,
https://docs.aspose.com/cells/net/aspose-cells-gridjs/how-to-use-gridjs-client-api/#event-call-back
@salah010
Please update to the latest v25.5 release,
the client js.
the server side dll.
we now have supported the below api in the client js.
xs.refreshToken
1 Like
The issues you have found earlier (filed as CELLSGRIDJS-1620) have been fixed in this update. This message was posted using Bugs notification tool by leoluo
Thank you for your support
You are welcome. If you have any additional questions or feedback, please do not hesitate to reach out to us.
we would like to request support for multi-color highlighting in GridJs spreadsheet.
Currently, it appears that cell highlighting supports only a single color.
Would it be possible to:
- Support multiple highlight colors per selection type or condition?
- Allow programmatic control over highlight color styles for different cell ranges?
This would greatly improve the user experience in use cases like comparing data, indicating validation status, or categorizing input zones.
We would appreciate the opportunity to understand your requirements better. Could you kindly share additional details, screenshots, and any relevant resource files on multi-color highlighting feature to help us assess your needs? We will then look into them promptly.
@salah010
let me guess your scenario
1.add the highlight color in range {sri,sci,eri,eci}
xs.sheet.addHighlightRange(sri,sci,eri,eci,style)
// the parameter is:
style: the style for highlight ,currently only support color
for example: {'color':'rgba(85, 57, 47, 0.08)'}
2.update the highlight color in range {sri,sci,eri,eci}
xs.sheet.updateHighlightRange(sri,sci,eri,eci,style)
// the parameter is:
style: the style for highlight ,currently only support color
for example: {'color':'rgba(85, 57, 47, 0.08)'}
are these APIs ok?
or please provide detail scenairo and requirements.
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-1666,CELLSGRIDJS-1667
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.
Hi Aspose Team,
We have a scenario where we need to highlight multiple cell ranges using different colors at the same time—for example, to indicate various statuses or categories within the same sheet.
However, it seems that GridJs only supports a single highlight color at a time, or that setting a new highlight overrides the previous one.
Our Questions:
- Does GridJs currently support applying multiple highlight colors simultaneously to different cell ranges?
- If not, is there a recommended workaround (e.g., using custom cell styles or overlays) to achieve this effect?
- Is there any planned support for this feature in upcoming versions of GridJs?
- is it possible to somehow use different colors for each specific added highlight text?
exmple :
sheet.addHighlightText(1,1,1,2,{color: ‘somecolor’} )
sheet.addHighlightText(1,2,1,2,{color: ‘secondcolor’} )
sheet.showHighlights()
This functionality would be very useful in scenarios involving data comparison, validation, or user-guided workflows.
Thanks in advance for your help and guidance!
Thank you for providing the detailed scenario and requirements.
We have documented them and logged the corresponding tickets (CELLSGRIDJS-1666, CELLSGRIDJS-1667) in our system. We will evaluate them and get back to you with further details.
Hi Aspose Team,
We’re currently using Aspose.Cells GridJs in our web application, and it’s working very well for Excel file display and interaction. We appreciate the capabilities it offers.
1. Multi-Color Highlighting Support
We have a scenario where we need to highlight multiple cell ranges with different colors simultaneously—for example, to indicate various statuses or user inputs in distinct categories.
Currently, it appears that setting highlights may override existing ones, or only one highlight color is supported at a time.
Questions:
- Does GridJs currently support multiple concurrent highlight colors on different cell ranges?
- If not, is there a recommended workaround or customization?
- Is multi-color highlight support planned in future releases?
2. backgroundColor Support in addHighlightText
We’re using sheet.addHighlightText(...) like this:
sheet.addHighlightText(1, 2, 1, 2, { color: 'rgba(255, 0, 0, 0.2)' });
However, when using semi-transparent colors (rgba with low alpha), the highlight is not very visible, especially on light cell backgrounds.
Would it be possible to support a backgroundColor property instead of color? For example:
sheet.addHighlightText(1, 2, 1, 2, { backgroundColor: 'red' });
This would help improve visibility and styling flexibility, particularly when highlight overlays need to stand out clearly.
We would appreciate your feedback or any recommended approaches to achieve these features.
1 .
- Does GridJs currently support multiple concurrent highlight colors on different cell ranges?
not support yet - If not, is there a recommended workaround or customization?
not yet. - Is multi-color highlight support planned in future releases?
yes,we have record a feature request CELLSGRIDJS-1666
2 . you want the style also support backgroundColor
sheet.addHighlightText(1, 2, 1, 2, { backgroundColor: 'red' ,color: 'rgba(255, 0, 0, 0.2)'});
we have record a feature request CELLSGRIDJS-1683
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.
Hi Aspose Team,
I’m facing an issue while working with Aspose.Cells GridJs Spreadsheet Viewer.
Scenario:
- Initially, I want to load the spreadsheet without hidden content.
- Later, when the user clicks a “Show Hidden Content” toggle, the app requests fresh data from the backend with hidden content included.
Problem:
- When the sheet reloads with hidden content, the hidden rows and columns become visible only for a few seconds and then they collapse again automatically.
- This behavior happens only for hidden rows and columns.
- It works fine for hidden sheets (they stay visible as expected).
- Also, the hidden content visibility (rows and columns) persists in the active sheet, but when switching to other sheets, the hidden rows and columns do not remain visible.
Question:
- Is there a recommended way to keep hidden rows and columns visible once they are toggled on?
- Do we need to call a specific method in GridJs after reloading the data to ensure the visibility state is retained?
Thanks in advance for your support!
Could you please provide more information regarding your issue? Additionally, kindly attach a sample Excel file and a code snippet or application (ensure the resource files are zipped before uploading). We will review your specific requirements.