Questions on UI for ASP.NET Core Forum

1 answer

30 views

Hi,

the following template is partially working when used in a grid-row-template.

                <grid-row-template>
                    <div>${data.Name}</div>
                    #if(data.HasLastName){#
                          <div>${data.LastName}</div>
                    #} else {#
                          <div>some other stuff</div>
                    #}#
                </grid-row-template>

values inside ${ } are properly replaced, however the code inside # # is not executed, it is rendered as text.

What is the proper way to include conditionals in this case?

regards

Grid

answered on 15 Jan 2025

1 answer

42 views

Issue with Formulas Not Reflecting in Upload and Download Sheets

Hi Team,

I am facing an issue where formulas in the spreadsheet are not properly reflecting when importing or downloading sheets in my application. Specifically, the formulas are not retained during the upload process or included correctly during the export/download operation.

Below are the reference codes for upload and download functionality:

Upload Code:
using (var package = new ExcelPackage(stream))
{
var workbook = package.Workbook;
var worksheet = workbook.Worksheets[0];

var rows = new List<dynamic>();
for (int row = 1; row <= worksheet.Dimension.End.Row; row++)
{
var rowData = new List<string>();
for (int col = 1; col <= worksheet.Dimension.End.Column; col++)
{
rowData.Add(worksheet.Cells[row, col].Text);
}
rows.Add(new { cells = rowData.Select(val => new { value = val }).ToArray() });
}

var sheetData = new
{
name = worksheet.Name,
rows = rows.ToArray()
};

return Json(new { success = true, data = sheetData });
}

Download Code:
using (var package = new ExcelPackage())
{
var sheet = spreadsheetData.sheets.FirstOrDefault();
if (sheet != null)
{
var worksheet = package.Workbook.Worksheets.Add(sheet.name);

foreach (var row in sheet.rows)
{
foreach (var cell in row.cells)
{
var excelCell = worksheet.Cells[row.index + 1, cell.index + 1];

// Set font properties
excelCell.Style.Font.Size = cell.fontSize > 0 ? cell.fontSize : sheet.defaultCellStyle.fontSize;
excelCell.Style.Font.Bold = cell.bold;

// Set background color
if (!string.IsNullOrEmpty(cell.background))
{
excelCell.Style.Fill.PatternType = ExcelFillStyle.Solid;
excelCell.Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(cell.background));
}

// Set font color
if (!string.IsNullOrEmpty(cell.color))
{
excelCell.Style.Font.Color.SetColor(ColorTranslator.FromHtml(cell.color));
}

// Set text alignment
excelCell.Style.HorizontalAlignment = cell.textAlign switch
{
"center" => ExcelHorizontalAlignment.Center,
"right" => ExcelHorizontalAlignment.Right,
_ => ExcelHorizontalAlignment.Left,
};

// Set number format
if (!string.IsNullOrEmpty(cell.format))
{
excelCell.Style.Numberformat.Format = cell.format;
}

// Set formula if available
excelCell.Formula = cell.formula;

// Set cell value
excelCell.Value = cell.value;
}
}
}

fileStream = new MemoryStream(package.GetAsByteArray());
}

Could you please guide me on resolving this issue to ensure formulas are preserved and processed accurately?

Thank you for your assistance!

Spreadsheet

answered on 14 Jan 2025

2 answers

72 views

Dynamic TabStrip and nested Grids

I need to be able to render a tabstrip with a dynamic number of tabs, and then within each tab a griid to display records that relate to the tab.

Basically it is grouping sets of data into tabs, and then displaying the records from that group in the grid.

The underlying source of the grids is all the same, albeit each one would be showing a different subset of records.

The number of tabs/grids required would be unknown until the data is loaded.

Is this even possible? I have searched but can't find an example doing exactly what I need.

Thanks

Grid

TabStrip

updated answer on 10 Jan 2025

0 answers

57 views

Dockmanager save and restore layout

Hi,

How to save the layout of the dockmanager ? I need to restore panels in the right place.

Best regards

DockManager

asked on 09 Jan 2025

2 answers

430 views

Getting Cascading Dropdownlist working with RazorPages

I can't seem to get the Cascading DropdownList functionality to return the selected value from the parent. I will list what I have and if someone can point out my problem I would appreciate it. The parent loads the selected items correctly, and it calls the child dropdownlist event when a new select is made, but the parameter that should have the selected id is always null.

.cshtml page

html.cs

public JsonResult OnGetCLINTaskTypes(int? ddlCLIN)
{
TaskTypes tt = new TaskTypes(SQLWrapper);
DataSet ds = new DataSet();


if(ddlCLIN == null)
{
ddlCLIN = 0;
}
ds = tt.SelectRecordsForDropDown("TITLE", Int32.Parse(HttpContext.Session.GetInt32(Globals.SessionName.Org.ToString()).ToString()), ddlCLIN);

List<Projects> list = new List<Projects>();

foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new Projects(SQLWrapper)
{
ProjectID = Convert.ToInt32(dr["TYPE_ID"].ToString()),
Title = dr["TITLE"].ToString(),

});
}

var dsResult = list;//.ToDataSourceResult(request);
return new JsonResult(dsResult);


}
public JsonResult OnGetCLINS()
{
Projects Projdb = new Projects(SQLWrapper);
DataSet ds = new DataSet();
ds = Projdb.SelectRecordsForDropDown("TITLE", Int32.Parse(HttpContext.Session.GetInt32(Globals.SessionName.Org.ToString()).ToString()));

List<Projects> list = new List<Projects>();

foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new Projects(SQLWrapper)
{
ProjectID = Convert.ToInt32(dr["PROJECT_ID"].ToString()),
Title = dr["TITLE"].ToString(),


});
}

var dsResult = list;//.ToDataSourceResult(request);
return new JsonResult(dsResult);
}

DropDownList

updated answer on 02 Jan 2025

1 answer

82 views

Not able to see clear button in Aspnet core Textbox control

I am not able to see clear button aspnet core text box control. I have added clear-button="true" to textbox tag helper code and still not able to see the clear button when the data is entered in the text box.

TextBox

answered on 25 Dec 2024

2 answers

47 views

Formatting data bound menu

Hi

I have a data bound menu component where I would like to override the styles of individual items - namely at the moment I would like to make some bold.

What I actually want to do is to render a separator, then a bold header, and then a normal weight list of options - something like :

-----------------------------
Recent Customers
Customer 1
Customer 2
Customer 3
-----------------------------

I do not want them to be a sub menu ideally. I am struggling to work out how to set the class/style of individual menu items.

This is my code for rendering the menu currently, I will add another property to item/subitem as a flag to denote requiring to be bold :

            @(
            Html.Kendo().Menu()
            .Name("mainMenu")                
            .BindTo(Model.Menus.Where(s => s.ParentMenuId == 0), mappings =>
            {
                mappings.For<Welcomm_CRM.Core.Application.Menu>(binding => binding // Define the first level of the Menu.
                .ItemDataBound((item, type) => // Define the mapping between the Menu item properties and the model properties.
                {
                    item.Text = type.MenuTitle;   
                    if (type.MenuSource == 999999)
                    {
                        item.LinkHtmlAttributes.Add(type.ControllerName, type.ActionName);
                    }
                    else if (type.MenuSource == 999998)
                    {
                        item.Separator = true;
                    }
                    else if (type.MenuSource == 0)
                    {
                        item.Url = @Html.Encode(type.Url);
                    }
                }
                )
                .Children(type => Model.Menus.Where(s => s.ParentMenuId == type.MenuId)));
                mappings.For<Welcomm_CRM.Core.Application.Menu>(binding => binding
                .ItemDataBound((item, subtype) =>
                {
                    item.Text = subtype.MenuTitle;                        
                    if (subtype.MenuSource == 999999)
                    {
                        item.LinkHtmlAttributes.Add(subtype.ControllerName, subtype.ActionName);
                    }
                    else if (subtype.MenuSource == 999998)
                    {
                        item.Separator = true;
                    }
                    else
                    {
                        item.Url = @Html.Encode(subtype.Url);
                    }
                })
                );
            })
            )

Menu

answered on 18 Dec 2024

1 answer

46 views

Grid - right justify keeps text left

We have been using the grid control for quite some time and we just now noticed the logic we use to right-justify the header text appears to not be styling as intended. I have attached a screen shot to show the odd display. The text is right-justified but the header text is still on the left of the column. I should note it is common practice, especially for reports, to right justify both the text and the header when showing numeric values so the decimals align.

<column field="CurrentOverCount" title="Over<br />Employee Count" width="70"
        header-html-attributes='new Dictionary<string,object> { ["class"]="text-end" }' html-attributes='new Dictionary<string,object> { ["class"]="text-end" }' />

I have also tried using pure CSS for the header with the same result:

<column field="CurrentOverCount" title="Over<br />Employee Count" width="70"
        header-html-attributes='new Dictionary<string,object> { ["style"]="text-align:right;" }' html-attributes='new Dictionary<string,object> { ["class"]="text-end" }' />

Grid

Styling

answered on 18 Dec 2024

1 answer

123 views

Icons in menu not visible in latest library (2024 Q4)

@(Html.Kendo().Menu()
  .Name("Menu")
  .Items(items =>
  {
      items.Add()
              .Text("Products - Expand me")
              .Items(children =>
              {
                  children.Add().Text("Furniture");

                  children.Add().Encoded(false).Text("<span class=\"k-icon k-i-clock\"></span>I have a Font Icon");

                  children.Add().Text("Decor");

              });

      items.Add().Text("Stores");
  })
)

The above code does not render the icon. All the examples in the demos are with Images. Latest update broke my application. What is the new way to achieve this?

Menu

answered on 16 Dec 2024

1 answer

43 views

How best to implement pop up To Do List

My app has a static footer bar, and in the bottom left of all pages I want to add a button which will launch the users "To Do List", ideally also down in the bottom left hand corner.

Obviously the content within that will be dynamic, and will likely be a list of items to attend to, groups by type, which will actually just be links off the various other pages.

What is the best way to achieve the pop up To Do List? I was looking at the Action Sheet, but the position / sizing is off, as I can only seem to have it open in the centre of the screen, or full width.

ActionSheet

Popover

answered on 15 Dec 2024