Problem of setTextWrapped(true)

Aspose.Cells Product Family
1

Hi,

I use setTextWrapped(true) to return automatically to the line when i have a long text, but what i remark when i generate the excel file(See attachement) is that the TextWrapped characteristic is done but the text still out of the cell. and i need to open the file an double click on the cell in order to get the expected result.

Any explanation?

I use Aspose cells 7.2.1.8 for java.

Thanks fo help.

2

Hi,


Can you please download and try our latest version of Aspose.Cells for Java and let us know your feedback?

You can download download all the required libraries from the latest major release: Aspose.Cells for Java 7.2.2 and then update the aspose.cells jar with the latest related jar from the latest minor release: Aspose.Cells for Java v7.2.2.1

Let’s us know your feedback after testing.

3

Hi,


I have tested your issue with the following lines of code, and it works fine for me. It sets the 3rd column WrapText property. Please have a look at the following code:

Workbook workbook = new Workbook("C:\\Application.xlsx");

Worksheet sheet = workbook.getWorksheets().get(0);
Style style = new Style();
style.setTextWrapped(true);
StyleFlag styleFlag = new StyleFlag();
styleFlag.setAll(true);
Column col = sheet.getCells().getColumns().get(2);
col.applyStyle(style, styleFlag);
workbook.save("Test.xls");

Let us know if you still face problems. We will try to assist you ASAP.