I use the following sample code to set the length of the height of the shape…
worksheet.Shapes[shapeNameText.Key].Text = shapeNameText.Value; var height = worksheet.Shapes[shapeNameText.Key].CalculateTextSize(); ////TODO Aspose Bug for Japanese ticker worksheet.Shapes[shapeNameText.Key].Height = height;
However, it seems the maximum height of the shape for the text(please find in the attachment) is to row 143… when user opened the excel, there is still lots of text hidden.
Example of the hidden text in the shape as below…
image.png (23.6 KB)
image.png (29.7 KB)
after double click the shape, we can see those hidden text.
JapaneseDisclosure.zip (163.7 KB)
If the language is English, there is no issue. Seems Aspose is not able to detect Japanese text height?