Free Support Forum - aspose.com

Chose from a List in a Cell in Excel not working

Hello Aspose-Team.

We are working with asp.net webforms and using “aspose:GridWeb” to edit an Excel-File.
The Excel-File contains Lists to choose from, see picture1.
The list for cell F7 in sheet “Erläuterungen der FNB” depends on the selection of cell D7 in sheet “Erläuterungen der FNB”.
When I load this Excel in the aspose:GridWeb, I can choose in cell D7 but not in cell F7 when D7 is filled up. See picture2.

How can I made it work to choose from the cell F7?

Thanks in advance
Matthias

Picture1.jpg (163.8 KB)
Picture2.jpg (91.8 KB)
MW_BK9-20-604_Festlegung_Anlage-F2_BF.zip (260.9 KB)

@Matthias_Winzer,
We have observed this issue and logged it in our database for further investigation. You will be notified here once any update is ready for sharing.
This issue is logged as:
CELLSNET-47897 - List item selection not working when loaded into ASP.NET application

Please try this fix.
Aspose.Cells.GridWeb.21.2.8.zip (5.3 MB)

Hello Peter zhou,

I tried your fix, but when I choose something in e.g. cell D7 then I get the following error:

Blockquote
error happens,please check the below info:
can not load GridWeb control instance from session.please check site setting.

Thanks in advance for your help
Matthias

@Matthias_Winzer,
I have tried to reproduced the issue with the latest hot fix but could not observe it. Please share a simple runnable solution to reproduce this issue here for our reference.
Issue Pic 1
Issue Pic 2

Hallo ahsaniqbalsidiqui,

please try to choose something new in e.g. cell D9 or D10 etc.
The error appears only if you choose something new.

See examples in the added pictures.

Thanks in advance for your help
Matthias

Aspose_Fehler_Alert.JPG (81.8 KB)
Aspose_Fehler_Auswahl.JPG (30.3 KB)

@Matthias_Winzer,
I am afraid that this error does not appear in my environment. Please share your environment details including the browser where this application is tried.

The issues you have found earlier (filed as CELLSNET-47897) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao

Hallo ahsaniqbalsidiqui,

as requested here are a few more details:

Environment:

  • Browser: Chrome Version 89.0.4389.72 (Offizieller Build) (64-Bit)
  • Target framework: .NETFramework,Version=v4.7.1
  • Aspose.Cells.dll -> Version: 21.3
  • Aspose.Cells.GridWeb.dll -> Version: 21.2.8

Code-Snippet Backend:

protected void Page_Load(object sender, EventArgs e)
{
    xlsEdit.ImportExcelFile(Server.MapPath("~/App_Data/MW_2_BK9-20-604_Festlegung_Anlage-F2_BF.xlsx"));

    xlsEdit.EditMode = true;
    xlsEdit.ActiveSheetIndex = 0;
    xlsEdit.CurrentPageIndex = 0;
    
    xlsEdit.ACWLanguageFileUrl = @"~\aspose_client\lang_de.js";
}

Code-Snippet Frontend:

<%@ Page Title=“Home Page” Language=“C#” MasterPageFile="~/Site.Master" AutoEventWireup=“true” CodeFile=“Default.aspx.cs” Inherits="_Default" %>
<%@ Register TagPrefix=“aspose” Namespace=“Aspose.Cells.GridWeb” Assembly=“Aspose.Cells.GridWeb” %>

<asp:Content ID=“BodyContent” ContentPlaceHolderID=“MainContent” runat=“server”>

<div class="panel panel-default" style="margin-top:30px">
    <div class="panel-heading">Aspose: Laden einer Exceldatei</div>
    <div class="panel-body">
        <p>Nachstellung des Fehlers</p>
        <p>Bezug auf Ticket-Nr. [XXX]</p>
    </div>
</div>

<aspose:GridWeb
    ID="xlsEdit"
    runat="server"
    Width="2500px"
    Height="100%"
    PageSize="500" 
    ShowContextMenu="false" 
    ShowCellEditBox="false" 
    ShowBottomBar="true" 
    ShowTabBar="false" 
    ShowLoadingPosition="true" 
    ShowUndoButton="false" 
    ShowSubmitButton="false" 
    ShowSaveButton="false" 
    ShowTabNavigation="true" 
    HeaderBarWidth="100pt"
    EnableClientResizeColumnRow="false" 
    ForceValidation="false"
/>

</asp:Content>

Please test out the code with my revised excel document “MW_2_BK9-20-604_Festlegung_Anlage-F2_BF.xlsx”:

MW_2_BK9-20-604_Festlegung_Anlage-F2_BF.zip (260.8 KB)

Thanks in advance for your help
Matthias

@Matthias_Winzer,
We are not able to reproduce this issue using this sample data and environment details. You may share a complete runnable solution that can be compiled and executed here to reproduce this issue.

Hallo ahsaniqbalsidiqui,

as requested here are a runable Solution:

AsposeDemo2.zip (7.5 MB)

Please put the needed Aspose-Dlls in the bin-folder

  • Aspose.Cells.dll -> Version: 21.3
  • Aspose.Cells.GridWeb.dll -> Version: 21.2.8

I had to remove this files because of max. upload-size.

Thanks in advance for your help
Matthias

@Matthias_Winzer,
We have observed the issue and logged it in our database for further investigation. We will notify you here once any update is ready for sharing.

This issue is logged as:
CELLSNET-47925 - Error raised in browser when select item from a list in a cell

@Matthias_Winzer
the client js file of GridWeb control shall be updated to the latest one.
please try this one
acw_client.zip (110.8 KB)

Hallo ahsaniqbalsidiqui,

the JavaScript-Error is fixed but not the other issue:

When I chose something in e.g. cell D7 then the list in cell F7 should be filled, see picture Correct.jpg
But I got a wrong result, see picture Wrong.jpg

The chooseable list in cell F7 depends on the choice in cell D7 and so on.
Can you please fix this issue also.

Thanks in advance for your help
Matthias

Correct.jpg (88.1 KB)
Wrong.JPG (29.1 KB)

@Matthias_Winzer,
We have observed the issue and analyzing it in detail. You will be notified here once any update is ready for sharing.

We’ve add new propertie GridWeb.RefreshValidation which
Gets or sets whether to refresh validation value after cell value changes.
Please try the fix and check the code in the Default.aspx .

Aspose.Cells.GridWeb.21.3.1.zip (5.4 MB)
pageupdate.zip (1.2 KB)

Hallo ahsaniqbalsidiqui, hello petor.zhou

I have tried your fix but have still the same issue.

Could you provide your test-project for me that I can test it with your code?

Thanks in advance for your help
Matthias

@Matthias_Winzer,
You may please try this project with the latest version shared here. It is a complete project, therefore you may please open following link once the application is started in the web browser.

http://localhost:40056/GridWebBasics/ImportExportFile.aspx

Examples_GridWeb.zip (7.8 MB)

Hallo ahsaniqbalsidiqui

Sorry for the late reply.
We have checked your project and checked the new aspose.dll’s in a small project and it seem to work.
But in our big project it did not work.
I don’t know why.
So I have to close this ticket for now.

Thanks for your help.

Matthias

@Matthias_Winzer,
Thanks for the feedback. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.