wrap text not display

[aksh0614]

while converting excel to pdf. Wrap text is cutted on pdf file

[Mike.Zhang]

Hi,

Thanks for your inquiry.
To help us investigate the issue, please provide your sample file here or via email([email protected]).

[aksh0614]

Code: Select all

class Program
    {
        static void Main(string[] args)
        {
            DbEntities db = new DbEntities();
            Console.WriteLine("Hello World!");
            var invoices = db.RWX_Invoices.Select(x => new { x.Id, x.CreatedOn, x.Status, x.Currency, x.LastUpdatedUser, x.Subtotal, x.Total, x.PaidDTTM }).ToList();

            DataTable t = ToDataTable(invoices);

            //export datatable to excel

            Workbook book = new Workbook();
            book.Version = ExcelVersion.Version2010;
            Worksheet sheet = book.Worksheets[0];

            //set header&footer

            sheet.PageSetup.LeftHeader = "Header Footer Sample by E-iceblue Co.,Ltd";

            sheet.PageSetup.CenterFooter = "footer";

            sheet.TabColor = Color.Gold;
            sheet.Range["B11:C14"].Style.Color = Color.Aqua;
            CellRange range = sheet.Range["B10:C14"];
            range.BorderInside(LineStyleType.Thin, Color.Blue);

            range.BorderAround(LineStyleType.Medium, Color.Blue);
            sheet.Range[1, 1, 100, 100].Style.WrapText = true;
            ExcelFont font1 = book.CreateFont();
            font1.KnownColor = ExcelColors.LightBlue;
            font1.IsBold = true;
            font1.Size = 10;
           
            sheet.InsertDataTable(t, true, 10, 2);

            book.SaveToFile("insertTableToExcel.xlsx", ExcelVersion.Version2010);
            sheet.PageSetup.Orientation = PageOrientationType.Portrait;
            //Save to pdf file
            book.SaveToFile("Report.pdf", Spire.Xls.FileFormat.PDF);
            System.Diagnostics.Process.Start("insertTableToExcel.xlsx");

            //System.Diagnostics.Process.Start("Report.pdf");

            Console.ReadKey();
 
        }


[Mike.Zhang]

Hi,

Thanks for your message.
After testing with Spire.XLS Pack(Hotfix) Version:8.12.3, I found the issue only occurred in Excel, yet the style of wrap text in PDF was correct. Attached is my file for checking. I have logged the issue in our bug tracking system. Once it is fixed, we will let you know. Sorry for the inconvenience caused.

[Betsy.jiang]

Hi,

Glad to inform you that the issue is solved in Spire.XLS Pack(Hotfix) Version:8.12.11.

Sincerely,
Betsy
E-iceblue support team

[Betsy.jiang]

Hi,

Greetings from E-iceblue.
Do you use the hotfix? Has your issue been resolved?

Sincerely,
Betsy
E-iceblue support team