The bottom of the text is cut in columnHeader

  • babe59 6 days, 12 hours ago


    The bottom of the text is cut in columnheader
    see “G” in word “message”.

    I try to increase height

    childSheet.ColumnHeader.Rows[0].Height = 30;

    and vertical alignement

    childSheet.ColumnHeader.Rows[0].VerticalAlignment = CellVerticalAlignment.Top;

    but no success…


    You must be logged in to view attched files.
  • 23p
    GinaDan23p 6 days, 10 hours ago


    I tried this code with V10 and it seemed okay. Perhaps you could try this code and see if you get the same issue?

    DataSet ds = new System.Data.DataSet();
                DataTable name;
                DataTable city;
                name = ds.Tables.Add("Customers");
                name.Columns.AddRange(new DataColumn[] {new DataColumn("LastName", typeof(string)), new DataColumn("FirstName", typeof(string)),new DataColumn("ID", typeof(Int32))});
                name.Rows.Add(new object[] { "Fielding", "William", 0 });
                name.Rows.Add(new object[] { "Williams", "Arthur", 1 });
                name.Rows.Add(new object[] { "Zuchini", "Theodore", 2 });
                city = ds.Tables.Add("City/message");
                city.Columns.AddRange(new DataColumn[] {new DataColumn("City", typeof(string)), new DataColumn("Owner", typeof(Int32)), new DataColumn("message", typeof(string))});
                city.Rows.Add(new object[] { "Atlanta", 0, "Georgia" });
                city.Rows.Add(new object[] { "Boston", 1, "Mass." });
                city.Rows.Add(new object[] { "Tampa", 2, "Fla." });
                ds.Relations.Add("City/message", name.Columns["ID"], city.Columns["Owner"]);
                fpSpread1.ActiveSheet.DataSource = ds;
                fpSpread1.ActiveSheet.DataMember = "Customers";
                fpSpread1.ActiveSheet.SetColumnWidth(2, 150);
                fpSpread1.ActiveSheet.SetRowExpandable(0, false);

    Thanks, Gina

  • babe59 2 days, 8 hours ago


    After test I saw that the proble is visible with Arial font

    fpSpread1.ActiveSheet.Columns.Count = 3;
    fpSpread1.ActiveSheet.ColumnHeader.DefaultStyle.Font = new Font(“Arial”, 10, FontStyle.Regular);
    fpSpread1.ActiveSheet.ColumnHeader.Rows[0].Height = 50;
    fpSpread1.ActiveSheet.ColumnHeader.Columns[0,2].Label = “abcdefghi”;
    fpSpread1.ActiveSheet.Columns[0,2].Width = 200;
  • 23p
    GinaDan23p 2 days, 5 hours ago


    This looks okay when I try it. I attached an image.

    Thanks, Gina

    You must be logged in to view attched files.
  • babe59 2 days, 4 hours ago

    It’s not the sam for me
    I’ve attached an image for my PC

    I work with Vs2015 Win 10
    What other settings should I look at?

    You must be logged in to view attched files.
Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to create new topics.