Hi Rajesh,
Thanks for your update.
Query #1 “Can we completely hide the Menu options ribbon so that We can see only search bar and columns and rows.”
Your requirement for hide the ribbon option can be achievable by using ‘ShowRibbon’ API to set as false in Spreadsheet. Please refer the below code example.
|
@(Html.EJ().Spreadsheet<object>("Spreadsheet")
.ShowRibbon(false) //To hide Ribbon
//...
)
|
Query #2 “The attached pic shows what we want to hide. Is it possible to achieve this using ASP.NET MVC Spreadsheet control.”
We have checked this query and we would like to let you know that we couldn’t find any attachment which represent your requirement for about hide. So, could you please check this and get back to us with that attachment or provide more information to procced further?
Meanwhile, please check the below API links and get back to us with the details whether this requirement can be achievable or not.
Query #3 “Can we add drop down list in a cell(from datasource) and user can select a value and based on selected value, can we auto fill the a range of cells in the column.”
Yes. Your requirement can be achievable in Spreadsheet by using ‘XLCellTypes.addCellTypes()’ client-side method to add dropdownlist with custom datasource and using ‘XLDragFill.autoFill()’ to fill the data in specified cell range. Please refer the below code example.
|
@(Html.EJ().Spreadsheet<object>("Spreadsheet")
//...
.ClientSideEvents(eve => eve.LoadComplete("onLoadComplete").CellSave("onCellSave"))
)
var ddData = [{ text: "C5:C15", value: "C3:C4" } , ...];
function onLoadComplete(args) {
if (!this.isImport) {
//...
this.XLCellType.addCellTypes("A3", { 'type': ej.Spreadsheet.CustomCellType.DropDownList, 'dataSource': ddData, 'field': 'text' });
}
}
function onCellSave(args) {
if (args.selectedText && args.selectedValue) {
this.XLDragFill.autoFill({
dataRange: args.selectedValue,
fillRange: args.selectedText,
direction: ej.Spreadsheet.autoFillDirection.Down,
fillType: ej.Spreadsheet.AutoFillOptions.FillSeries,
isKeyFill: true
});
}
}
|
For your convenience, we have modified the provided sample to demonstrate these requirements and the same can be downloaded from the below link,
Could you please check the above sample and let us know whether is this fulfilling your requirement, if not please share us more information regarding this so that we can analyze based on that and provide you a better solution.
Regards,
Silambarasan
