We are using ASPOSE.CELLS DLL (Version: 188.8.131.52) for generating EXCEL Document in our application.
Over there we are facing issues in the below scenario,
Whenever we are adding any number of sheets in a workbook and are using dropdown list with
data source provide from workbook sheet itself.
Source sheet is sheet1
- sheet2 dropdown list bind to from sheet1 data values range is A1:A3
- sheet3 dropdown list bind to from sheet1 data values range is A4:A7
- sheet4 dropdown list bind to from sheet1 data values range is A8:A15
and so on.
Whenever save workbook into a MemoryStream object it changes a formula value (please refer below screen shorts). Below is the C# code for the same.
before1.PNG (11.1 KB)
after1.PNG (15.5 KB)
We are only getting values of dropdown list displayed in the last sheet.
Can you please provide us help for the above scenario to fix the issue.