For GridWeb, in order to update the cell content for rich text, we can edit the content. For example, if you want to change the color, just update the color tag with a new value. It is a simple design for rich text. However, it is not so visually direct. We can improve it in the future by using HTML editable span (we will log a ticket for it).
For GridJs, it is a .NET Core web app based on JSON and MVC. It can be used in a .NET 6 web application. Both MVC and Razor Pages should be ok.
@nagasivaos
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.
Issue ID(s): CELLSNET-55077
You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.
Seems the issue is still there. I see it working intermittently but still the issue is there. Please find attached recording after upgrading to 24.2, I could see it works some times but not working always.
Can you please kindly look into and let us know what if I’m missing something? Dropdown_Issue.zip (4.6 MB)
Thank you for pointing it to right direction. There is some change in network path in gridcontroller. After updating it, Dropdowns are working fine. However, there are 2 issues.
When I click on 1st sheet, it is throwing below error.
@nagasivaos
By using your template file, we can reproduce those two issues. We will fix them soon. Sorry for the inconvenience.
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.
Issue ID(s): CELLSNET-55117,CELLSNET-55118
You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.
We are pleased to inform you that your issues (logged earlier as “CELLSNET-55117” and “CELLSNET-55118”) has been resolved. The fixes/enhancements will be included in the upcoming release (Aspose.Cells v24.3) that we plan to release in the next month. You will be notified when the next version is released.
Could you possibly let us know the specific cells or formulas that is causing the issue here? If we know that, we can change our template as a temporary workaround until your fix is published.
@nagasivaos
There is a validation which uses “=effectivedate”.
The “effectivedate” is a defined name which references a cell with a datetime. When parsing the datetime, GRIDWEB encounters some issues.
Could you please point me to that specific validation rule which is causing the issue? I’ll remove/update and see if that helps to resolve the issue quickly at our end?
@nagasivaos
Please add the below code for this spread sheet file prduction_worksheet_0205.xlsx. After removing the date validation, it can be loaded.
GridValidationCollection vcs = GWExcelEditor.WorkSheets[4].Validations;
for(int i= vcs.Count-1; i>=0;i--)
{
Console.WriteLine(i+" validation info: type:"+ vcs[i].ValidationType+ " , "+vcs[i].Formula1 +" "+ vcs[i].Formula2);
ArrayList list = vcs[i].AreaList;
foreach(GridCellArea area in list)
{
Console.WriteLine(i + " area in validation " +area.StartRow+" "+area.StartColumn) ;
}
if(vcs[i].ValidationType==GridValidationType.Date)
{// just remove the date validation, we now have issues when parse the value
vcs.RemoveAt(i);
Console.WriteLine(i + " removed validation " );
}
}
//the first visible worksheet: NOTES & RATING
Console.WriteLine(GWExcelEditor.WorkSheets[4].Name);
The issues you have found earlier (filed as CELLSNET-55077,CELLSNET-55117,CELLSNET-55118) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi
