How to Set Authorization Token for Internal API Calls in Aspose.Cells GridJs Spreadsheet

Also, we currently have a valid Aspose.Total license for our project.

Can you please let us know if this qualifies us for any priority support or if we need a separate paid support subscription to get advanced technical help (especially for GridJs-spreadsheet customization like this)?

Looking forward to your response.

Thanks again!

@salah010
Thank you for your feedback. When you have a valid license to use Aspose products normally, the saved file does not have an evaluation page or evaluation information. And it is not limited by the evaluation version. However, the created ticket still provides normal support. If you need to upgrade support for the ticket, you need to purchase priority services.

In normal support here, we deal with issues on a first come, first served basis. We believe this is the fairest and most appropriate way to meet the needs of our customers.

Please check our paid support option where issues are prioritized and posses highest priority if your issue is a real blocker.

@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!

@salah010,

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

@salah010,

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.

@salah010,

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:

  1. Does GridJs currently support applying multiple highlight colors simultaneously to different cell ranges?
  2. If not, is there a recommended workaround (e.g., using custom cell styles or overlays) to achieve this effect?
  3. Is there any planned support for this feature in upcoming versions of GridJs?
  4. 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!

@salah010,

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.