Sunday 23 May 2021

jQuery load() method for calling partial view in mvc with loading progress bar

 //////////// HTML


  <div class="EEReport Summary" id="divSummary">
        <div id="Progressbar" class="ExportReportProgress"></div>
        <div class="loaddataURL"></div>
    </div>

////////////////// J-Query

function LoadUrl(th, IntWidth, showDivButtonId) {
        $("#Progressbar").show();
        $('.loaddataURL').load(
            "URL",
            DataContent or Form Data
            function (data, status, jqXGR) {
                    //// Here set any thing after loading the url data or form
                $("#Progressbar").hide();
            }
        );

}


Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...