Is it possible to have AutoFitAll function of the ContextMenu to leave no white space?
Hello,
I have noticed that when clicking "Autofit all columns" from the context menu that the columns are sized correctly to accommodate the contents of each column but this can leave whitespace at the end of the grid:
Is it possible to get the grid to set the column widths slightly wider in order to utilise this white space?
Thank
Hi Monisha,
Thanks for the quick reply. I appreciate that the grid is behaving as documented. However, the problem this causes is that if you have EnablePersistance="true" and you choose the option to Auto Fit All then navigate away and back again, the columns change size.
To reproduce you can use the following grid code:
<SfGrid @ref="DefaultGrid" DataSource="@Orders"
AllowSorting="true"
AllowResizing="true"
ID="TestAutoResize"
EnablePersistence="true"
ContextMenuItems="@(new List<object>() { "AutoFit", "AutoFitAll"})"
>
<GridColumns>
<GridColumn Field=@nameof(Order.OrderID) HeaderText="Order ID" TextAlign="TextAlign.Right" Width="120"></GridColumn>
<GridColumn Field=@nameof(Order.CustomerID) HeaderText="Customer Name" Width="150"></GridColumn>
<GridColumn Field=@nameof(Order.OrderDate) HeaderText=" Order Date" Format="d" Type="ColumnType.Date" TextAlign="TextAlign.Right" Width="130"></GridColumn>
<GridColumn Field=@nameof(Order.Freight) HeaderText="Freight" Format="C2" TextAlign="TextAlign.Right" Width="120"></GridColumn>
</GridColumns>
</SfGrid>
@code{
private SfGrid<Order> DefaultGrid;
public List<Order> Orders { get; set; }
protected override void OnInitialized()
{
Orders = Enumerable.Range(1, 20).Select(x => new Order()
{
OrderID = 1000 + x,
CustomerID = (new string[] { "ALFKI", "ANANTR", "ANTON", "BLONP", "BOLID" })[new Random().Next(5)],
Freight = 2.1 * x,
OrderDate = DateTime.Now.AddDays(-x),
}).ToList();
}
public class Order
{
public int? OrderID { get; set; }
public string CustomerID { get; set; }
public DateTime? OrderDate { get; set; }
public double? Freight { get; set; }
}
After Auto Fit All Columns the grid looks like this:
After navigating to Home and back again it looks like this:
I believe this is because on initialising it is trying to make use of all of the space available to it rather than leaving white space. This is what I would like to the Auto Fit All Columns to do so that as the user navigates back to the grid the columns are still sized as they were previously.
I hope that is clear.
Thanks,
Chuck
