Chose from a List in a Cell in Excel not working

Matthias_Winzer · February 26, 2021, 2:21pm

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)

ahsaniqbalsidiqui · February 26, 2021, 4:39pm

@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

peter.zhou · March 5, 2021, 8:55am

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

Matthias_Winzer · March 8, 2021, 12:25pm

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

ahsaniqbalsidiqui · March 8, 2021, 2:45pm

@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

Matthias_Winzer · March 10, 2021, 10:58am

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)

ahsaniqbalsidiqui · March 10, 2021, 1:49pm

@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.

aspose.notifier · March 11, 2021, 2:33am

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

Matthias_Winzer · March 11, 2021, 12:45pm

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

ahsaniqbalsidiqui · March 11, 2021, 3:30pm

@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.

Matthias_Winzer · March 12, 2021, 10:42am

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

ahsaniqbalsidiqui · March 12, 2021, 4:52pm

@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

peter.zhou · March 15, 2021, 8:40am

@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)

Matthias_Winzer · March 15, 2021, 4:20pm

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)

ahsaniqbalsidiqui · March 15, 2021, 6:08pm

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

peter.zhou · March 16, 2021, 8:56am

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)

Matthias_Winzer · March 18, 2021, 4:27pm

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

ahsaniqbalsidiqui · March 18, 2021, 6:33pm

@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)

Matthias_Winzer · April 7, 2021, 8:11am

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

ahsaniqbalsidiqui · April 7, 2021, 10:29am

@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.