C# (CSharp) BTable.Cmd_Select_Referenced_Cells Examples

Example #1

        public void Cmd_Update()
        {
            if (Curr_Value.Substring(0, 1) == "=")
            {
                string a = MyFunctions.MarkReferencedCells(Curr_Value.ToUpper());
                if (!Current_BTable.CheckFormulaForCircuitReference(a, Current_BTable.ActiveCell.Address))
                {
                    Current_BTable.ActiveCell.Formula = a;
                    Current_BTable.Calculate();
                    Curr_Value_old = Curr_Value;

                    Current_BTable.Cmd_Select_Referenced_Cells();
                }
                else
                {
                    JsInterop.Alert("Detected circuit reference!");
                    Curr_Value = Curr_Value_old;
                }
            }
            else
            {
                Current_BTable.ActiveCell.Value = Curr_Value;
            }



            StateHasChanged();
        }

Example #2

File: CompBlazorSpreadsheet.razor.cs Project: violetheath45/LupusaBlazorDemos

        public void Cmd_Update()
        {
            if (!string.IsNullOrEmpty(Curr_Value))
            {
                if (Curr_Value.Substring(0, 1) == "=")
                {
                    string a = MyFunctions.MarkReferencedCells(Curr_Value.ToUpper());
                    if (!Current_BTable.CheckFormulaForCircuitReference(a, Current_BTable.ActiveCell.Address))
                    {
                        Current_BTable.ActiveCell.Formula = a;
                        Current_BTable.Calculate();
                        Curr_Value_old = Curr_Value;

                        Current_BTable.Cmd_Select_Referenced_Cells();
                    }
                    else
                    {
                        jsRuntime.InvokeVoidAsync("alert", "Detected circuit reference!");
                        Curr_Value = Curr_Value_old;
                    }
                }
                else
                {
                    Current_BTable.ActiveCell.Value = Curr_Value;
                }
            }
            else
            {
                Current_BTable.ActiveCell.Value = string.Empty;
            }



            StateHasChanged();
        }