wrap text

[ict@sogedin.it]

Hi
Is possibile Wrap text in a column value pivot ??
you are the best
thanks

[harry.support]

Hi,

I'm afraid that it's impossible to set the WrapText style of the column at present.
But I have added it as a new feature to the schedule of our dev team. If we have any progress, we will tell you.

Thanks and Regards,

[ict@sogedin.it]

I'm sorry I meant only the header of the column
this is possible?
thanks

[Benjamin Du]

Hello,

To wrap text in the header of the column, please refer to the following code:

Code: Select all

         Workbook workbook = new Workbook();
            workbook.LoadFromFile("sample.xlsx");
            Worksheet worksheet = workbook.Worksheets[0];

            //set the header of column "A1" WrapText
            worksheet.Range["A1"].Style.WrapText = true;
            //set the header of column "C1" WrapText
            worksheet.Range["C1"].Style.WrapText = true;
            workbook.SaveToFile("result.xlsx");

            System.Diagnostics.Process.Start("result.xlsx");

And you can check the screenshots in the attachment.
If there are any questions, welcome to tell us.

Regards,
Benjamin
E-iceblue support team

[ict@sogedin.it]

Hi, but i want wrap in HeadColumn Table Pivot
this not is bad for this case,
thanks

[Gary.zhang]

Hi,

Thanks for your feedback.

Sorry that it's impossible to set the WrapText style in HeadColumn Table Pivot at present.

If there are any questions, welcome to get it back to us.

Sincerely,
Gary
E-iceblue support team

[pradhan.subhankar@gmail.com]

I am using free spire.net.I am trying to make wrap text in pivot table header column. How can I do that.I need your help
Thanks

[Nina.Tang]

Hello,

Thanks for your inquiry.
Please try the following code to set the format of cells where the header columns of pivot table locates. If it doesn't help, please provide your input Excel file as well as your desired output file for our reference.

Code: Select all

sheet.Range["D3"].IsWrapText = true;

Sincerely,
Nina
E-iceblue support team

[Nina.Tang]

Hi,

Greetings from E-iceblue!
How is your issue going?
Thanks in advance for your valuable feedback and time.

Sincerely,
Nina
E-iceblue support team

[ict@sogedin.it]

Nes of tihs case ??

[Abel.He]

Nes of tihs case ??

Hello,

Thanks for your following-up.
Now, you can set “wrap text” to true for the header of pivot column, you can refer to the following code.

Code: Select all

//The "F10" is the location of the header of pivot column
            sheet.Range["F10"].IsWrapText= true;

Sincerely
Abel
E-iceblue support team