We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback
Essential JS2

Syncfusion jQuery based widgets are no longer in active development. Switch to our pure JavaScript based next generation Essential JS 2 library.

ejDropDownList in Spreadsheet

Thread ID:

Created:

Updated:

Platform:

Replies:

147101 Sep 1,2019 08:28 PM UTC May 5,2020 07:34 AM UTC jQuery 3
loading
Tags: ejSpreadSheet
Jose Monzon
Asked On September 1, 2019 08:33 PM UTC

Hi. I am using:
*  filename: ej.web.all.min.js
*  version : 17.2.0.46

This is the way I am creating the spreadsheet:
$("#importSheet").ejSpreadsheet({
                ....
            });

Somewhere else, I have this datamanager:
var dataManagerEmployees = ej.DataManager({
                url: "/api/Employees",
                adaptor: new ej.WebApiAdaptor()
            });

which is used in a dropdownlist in an already working ejGrid:
(this is the column within the Grid):
{
                            field: 'Employee_Id',
                            headerText: 'Employees',
                            foreignKeyField: "Employee_Id",
                            foreignKeyValue: "FullName",
                            dataSource: dataManagerEmployees,
                            editType: "dropdown",
                            allowEditing: false,
                            width: 250,
                            visible: false
                        },

My questions are: 
1. Can the same dropdownlist-dataManagerEmployees be used in a column in ejSpreadsheet?  if so, please provide an example. In other words, I need to display syncfusion controls in ejSpreadsheet columns, as per example "https://www.syncfusion.com/kb/6798/how-to-display-syncfusion-controls-in-grid-columns".

2. Can the above be done dynamically at runtime too? like clicking a button and that would add the dropdownlist to a column within the sheet. Please provide an example if so.


Vinoth Kumar Sundara Moorthy [Syncfusion]
Replied On September 4, 2019 01:38 PM UTC

Hi Jose, 
 
Thank you for contacting Syncfusion support. 
 
Query #1:  Can the same dropdownlist-dataManagerEmployees be used in a column in ejSpreadsheet? 
 
Yes, we can bind the datamanager to the spreadsheet columns. For more details, please refer the link below demo Link for binding datamanager in Spreadsheet, 
 
 
Query #2: Can the above be done dynamically at runtime too? like clicking a button and that would add the dropdownlist to a column within the sheet. Please provide an example. 
 
We have checked your reported requirement and we would like to let you know that your requirement can be achievable by using cellType support in spreadsheet. For more details, please refer the below CellType demo sample Link, 
 
 
 
 
For your convenience, we have prepared the sample that render the DropDownList in Spreadsheet cell using button click event. Please find the sample in below link, 
 
Could you please check the above sample and get back to us, if you need any further assistance on this? 
 
Regards, 
Vinoth Kumar S 


Unknown
Replied On May 4, 2020 06:45 PM UTC

In this example: http://jsplayground.syncfusion.com/bo0mgmhn 

Why after add a new dropdown and select the value in the cell and after that you perform scrolling down and scrolling up the value in the dropdown is not retained??

I have the same issue in my application when I use my own source from data.

Do you know how fix that?

Thanks and regards!


Saranya Dhayalan [Syncfusion]
Replied On May 5, 2020 07:34 AM UTC

Hi Josue, 
 
We have updated the response in the incident #153931 for your reported issue. Please follow the mentioned forum for further updates. 
 
Regards, 
Saranya D 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon