Aspose.Cells GridJs - Hide menu to InsertrRow below the maximum row

Aspose.Cells Product Family
,
1

Hello,

I am working with an Excel worksheet, and I’ve noticed a new functionality at the bottom of the sheet, just below the last row. This functionality displays a menu for inserting a specified number of rows.

This menu was not present before, and it seems to have appeared after the most recent update.

I am looking for a way to disable this menu so that users cannot see it or use it to add rows.

Could you please let me know how to achieve this?

Thank you in advance!
menuAddRows.png (12,1 KB)

2

@klep

To disable the menu that allows users to insert rows below the maximum row in Aspose.Cells GridJs, you can customize the GridJs settings. Specifically, you should set the showContextmenu option to false when initializing the GridJs instance. This will prevent the context menu from appearing, which includes the option to insert rows.

Here’s a simple example of how to do this:

const xs = x_spreadsheet('#gridjs-demo', {
    updateMode: 'server',
    updateUrl: '/GridJs2/UpdateCell',
    mode: 'edit',
    showToolbar: true,
    local: 'en',
    showContextmenu: false // Disable the context menu
});

By setting showContextmenu to false, users will not see the menu for inserting rows, effectively preventing them from adding rows below the maximum row.

If you have any further questions or need additional assistance, please feel free to ask!

3

Unfortunately, this is not the correct property. ShowContextmenu is responsible for displaying the menu when you right-click. That is not what I mean. The relevant element is visible in the screenshot I sent in the first thread.

4

@klep,

Thanks for the screenshot and details.

We understand your requirements and we will be looking into it on hiding/disabling menu to InsertRow below the maximum row in GridJs matrix. We have opened the following new ticket(s) in our internal issue tracking system and will either provide configuration options or deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSGRIDJS-1884

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.

5

@klep,

We are pleased to inform you that your issue (Ticket ID: “CELLSGRIDJS-1884”) has been resolved with priority, following your escalation through Priority Support desk. As part of the resolution, we have introduced the showRowAppenderToolbar option, allowing you to control its display. By default, this enhancement will be included in the upcoming release of Aspose.Cells.GridJs 25.9, scheduled for the next week of September 2025. Please stay tuned.

6

The issues you have found earlier (filed as CELLSGRIDJS-1884) have been fixed in this update. This message was posted using Bugs notification tool by leoluo

7

@klep
You shall update serverside to the latest v25.9 version in nuget package.
and the client js to the latest v25.9 version also.
the document for the showRowAppenderToolbar in loadoptions is here:
https://docs.aspose.com/cells/net/aspose-cells-gridjs/how-to-use-gridjs-client-api/