How to add menu items conditionally for some cells or row headers?

[sankarkumarP66]

I can add new items. Is it possible to add a menu item conditionally? For example, I’d like to show a custom menu item only in the row header if a specific cell in that row meets certain criteria.
I do not want to show this item for ColumnHeader and CellContextMenu

[sankarkumarP66]

I am able to add the row header text conditionally

@if(somemethod(context)) //context has index property.. we can use that to get the row's model { // add your text here }

I'm still working on how to restrict the menu item so that it only appears for RowHeader.

[deanparker-web]

I will post what I have done with Menus and hopefully learn from it?!?

The code removes the dropdown icon and you right click for menu. Menu only appears in header row.

In the razor page
<Datasheet Sheet="sheet"
MenuOptions="_options"
FrozenTopCount="0"
FrozenLeftCount="1"
ShowColHeadings="true"
StickyHeaders="true"
Virtualise="true" />

In the razor code behind
private SheetMenuOptions _options = new()
{
MergeEnabled = false,
ClearEnabled = false,
AlignmentEnabled = false,
DeleteColsEnabled = false,
DeleteRowsEnabled = false,
HideColsEnabled = false,
HideRowsEnabled = false,
InsertColsEnabled = false,
InsertRowsEnabled = false,
HeaderMenuEnabled = false,
};

[sankarkumarP66]

I was able to disable all these. I have added my own menu time.. but it is getting displayed in all 3 places.. I noticed Sort was added
only to the Header Row.. Similarly I wanted to add only to the RowHeader again conditionally.. only for few rows I want to show
the menu item. On cell right click I do not want to show any MenuItems.
Appreciate if you can point me the code file.. Hopefully I can figure it out myself

[deanparker-web]

I have not done a lot in the menu part, but wanted to share code and see if other experts can help out.

The following code will completely disable the default menu.
The right click is disabled.

The next step would be to create a custom menu. I turned on HeaderMenuEnabled so the drop-down arrow appears. Sort was turned on for the custom menu.

Example from anmcgrath demo page

In the razor code behind

    private bool _showSortByRow = true;

    private SheetMenuOptions _options = new()
    {
        MergeEnabled = false,
        ClearEnabled = false,
        AlignmentEnabled = false,
        DeleteColsEnabled = false,
        DeleteRowsEnabled = false,
        HideColsEnabled = false,
        HideRowsEnabled = false,
        InsertColsEnabled = false,
        InsertRowsEnabled = false,
        HeaderMenuEnabled = true,
        SortRangeEnabled = true,
        FilterColumnEnabled = false,
        ContextMenuEnabled = false
    };

In the razor page
The line: @if (_showSortByRow && sheet.Selection.ActiveRegion!.Height > 1)
You would put in your (somemethod(context)) in the if.

<Datasheet Sheet="sheet"
           MenuOptions="_options"
           FrozenTopCount="0"
           FrozenLeftCount="1"
           ShowColHeadings="true"
           StickyHeaders="true"
           Virtualise="true">
          <MenuItems Context="sheet">
              @if (_showSortByRow && sheet.Selection.ActiveRegion!.Height > 1)
              {
                  if (!_options.SortRangeEnabled)
                      <SheetMenuDivider />

                  <SheetSubMenu Label="Sort By Row">
                      <SheetMenuItem OnClick="() => sheet.SortRange(sheet.Range(Axis.Row, sheet.Selection.ActiveRegion.Top, sheet.Selection.ActiveRegion.Bottom)!.Region, new List<ColumnSortOptions>() { new ColumnSortOptions(sheet.Selection.ActiveCellPosition.col, true) })">
                          Sort Rows Ascending
                      </SheetMenuItem>
                      <SheetMenuItem OnClick="() => sheet.SortRange(sheet.Range(Axis.Row, sheet.Selection.ActiveRegion.Top, sheet.Selection.ActiveRegion.Bottom)!.Region, new List<ColumnSortOptions>() { new ColumnSortOptions(sheet.Selection.ActiveCellPosition.col, false) })">
                          Sort Rows Descending
                      </SheetMenuItem>
                  </SheetSubMenu>
              }
          </MenuItems>
</Datasheet>

[anmcgrath]

Hi all, wanted to add to what @deanparker-web wrote (thanks for giving the code.)

You can indeed use the ActiveRegion to determine which row is being selected. I would just add that you can use

if(sheet.Selection.ActiveRegion is RowRegion r && Satisfies(r.Top)){
// show your menu items if the row satisfies
}

to only show specific menu items for certain rows.

If you wanted to show a caret for the row headings only on specific rows you can use the RowHeaderTemplate.