Gridweb worksheets seteditablerange

Aspose.Cells Product Family
1

dear support
I am using the gridweb and have problems setting the editable range.

my code is very simple

gridweb1.importexcelfile(…)
gridweb1.editmode=true
gridweb1.worksheets(0).setallcellsreadonly()
gridweb1.worksheets(0).seteditablerange(1,1,1,1)

Unfortunately, none of the cells are editable.
When I remove the setallcellsreadonly statement, all is ediatble.

Any ideas ??

My version is 17.7.0.0

kind regards

2

@GuidoDeBouver,

Thanks for providing us sample code with details.

After an initial test, I observed the issue as you mentioned by using your sample code with a simple template file. I found an issue with GridWorksheet.SetEditableRange method that does not do anything. I use the following sample code but still I cannot edit B2 cell in the first worksheet, all the cells in the worksheet are read-only:
e.g
Sample code:

string fileName = path + "\\GridWebBasics\\SampleData.xls"; 

            // Imports from an excel file. 
            GridWeb1.ImportExcelFile(fileName); 
            GridWeb1.EditMode = true; 
            GridWeb1.WorkSheets[0].SetAllCellsReadonly(); 
            GridWeb1.WorkSheets[0].SetEditableRange(1, 1, 1, 1);

I have logged a ticket with an id “CELLSNET-45717” for your issue. We will look into it soon.

Once we have an update on it, we will let you know here.

3

@GuidoDeBouver

We have tested this issue with the most recent version i.e. 17.10 and found it is working good. Please download and try the sample project. Also see the screenshot for your reference. As you can see in the screenshot, cell B2 is editable while all other cells are non-editable.

Screenshot: