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.
We have Excel files that contain hidden rows, columns, and sheets.
Scenario:
- Initially, we render the spreadsheet in GridJs Viewer without hidden content.
- When the user clicks a toggle button, we request fresh data from the backend and re-render the spreadsheet with hidden content enabled.
Problem:
- For some sheets, the hidden rows and columns become visible as expected.
- But in other sheets, the hidden rows and columns are not displayed (even after the toggle).
- Hidden sheets work fine — they are displayed correctly once the toggle is applied.
Question:
- Is there a specific API or recommended way to ensure that hidden rows and columns are consistently rendered across all sheets when toggled on?
image.png (8.9 KB)
@salah010
we dont quite understand your requirement,
can you show some detail case on a specific sample file.
the document is here:
you can use the below client api to hide the rows in current active sheet,
xs.sheet.hideRows(sri,eri)
// the parameters are:
sri:the start row index
eri:the end row index
if you want to do this for other worksheets,
we need to add new APIs to support your requirement.
if you mean autofilter,it shall work as in ms excel.when select the items in the filter combobox ,only the rows with selected values will show.
How can we make filter accessible
When I click on Filter I got Below console error 
@salah010
Please update to latest v25.9 version for both client and serverside.
We can reproduce this issue in the previous version, it was fixed in the v25.9 version.
1 Like
Thank You, for your reply
Title:
How to Remove “edge scroll clear interval” Console Log in Aspose.Cells GridJs
Body:
Hi Aspose Team,
We are using Aspose.Cells GridJs to render Excel spreadsheets in our web application.
While selecting or dragging cells inside the spreadsheet, the browser console keeps logging the following message repeatedly:
edge scroll clear interval
This is filling up the console and makes it harder to debug real issues.
Question:
- Is there a way to disable or remove these internal debug/console logs?
- Can this be controlled via a GridJs configuration option, or do we need to override/patch something in the library?
Any suggestions would be greatly appreciated.
We will evaluate your queries regarding controlling or suppressing the “edge scroll clear interval” console logs and reply you with our insights soon.