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.
@salah010
We are sorry for the inconvenience. For a temp workaround, you may search “edge scroll clear interval” in the client js:xspreadsheet.js and comment the related log code.
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 : CELLSGRIDJS-1937 Optimize console output on the client side
1 Like
Hi Aspose Team,
We are using Aspose.Cells GridJs in our application and want to implement lazy loading of rows to improve performance for large Excel files.
Requirement:
We would like to emit an event when the user scrolls down in the spreadsheet so that we can detect when more rows should be fetched from the backend.
Question:
- Does GridJs provide any built-in event or callback for detecting scroll or viewport changes?
- If not, what is the recommended approach to hook into the scrolling mechanism in GridJs so we can trigger a backend call for additional rows?
- An example or guidance on integrating lazy loading with GridJs would be very helpful.
Thanks in advance for your support!
You have the option to enable or disable lazy loading for worksheets in Aspose.Cells.GridJs. We will evaluate your queries carefully to provide detailed information soon.
@salah010
We are sorry but currently we only support lazy loading for the whole worksheet. We haven’t supported lazy loading for rows in the worksheet. It is more complicated than you expected.
Long ago, we opened the following ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.
Issue : CELLSGRIDJS-1390 Support pagination for GridJs
We will schedule and push this feature in future. However it is not easy and simple to support it.
Thanks for the Update,
- Do we have any event or callback when the user scrolls the spreadsheet?
- If not, is there a recommended way to detect scrolling (e.g., attaching a listener to the GridJs container) without breaking internal behavior?
@salah010
we don’t have public event call for scroll bar.
there are js functions:
xs.sheet.scrollV
xs.sheet.scrollH
they are not designed for public usage.
@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 : CELLSGRIDJS-1960 Support scroll event call back
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.