How to set 'Use Asian rules for controlling first and last characters' in a textbox?

Aspose.Cells Product Family
1

I am looking for ‘Use Asian rules for controlling first and last characters’ setting in Aspose.Cells.Drawing.Texts. I assumed that it could be in TextParagraph class but not found in there.
Would you kindly help me to find it?

Thank you.

2

@AT1
Would you like to provide your sample file and test code? If you could take a screenshot and highlight your requirements, it would be very helpful for us to locate the problem. We will check it soon.

3

Thank you very much for your reply.
Please find the attached, this setting is what I’m looking for.

image.png (20.2 KB)

4

@AT1
Please refer to TextParagraph.IsEastAsianLineBreak property. If you have any further questions, please send us the runnable code for further analysis. Thank you!

5

Thank you very much for your reply.
I tried the code below but no success yet. In the print preview ‘。’ still comes at the beginning of the 2nd line.
Please find attached for the details.
Aspose Textbox.pdf (24.8 KB)

I’m using Aspose.Cells v22.30, if this works well in another version please kindly let me know.

        using Workbook workbook = new Workbook();
        Worksheet worksheet = workbook.Worksheets.First();

        int textboxIndex = worksheet.TextBoxes.Add(1, 1, 60, 235);
        TextBox textbox = worksheet.TextBoxes[textboxIndex];
        textbox.IsTextWrapped = true;
        textbox.Text = "こんにちは、今日はいい天気です。";

        foreach(TextParagraph p in textbox.TextBody.TextParagraphs)
        {
            p.Font.Name = "MS Gothic";
            p.IsEastAsianLineBreak = true;
        }

        MemoryStream stream = new MemoryStream();
        workbook.Save(stream, SaveFormat.Xlsx);
        stream.Seek(0, SeekOrigin.Begin);

        string filename = "test.xlsx";
        return File(stream, MimeKit.MimeTypes.GetMimeType(filename), filename);
6

@AT1
Please set language for the text as the following:


            foreach (TextParagraph p in textbox.TextBody.TextParagraphs)
            {
                p.Font.Name = "MS Gothic";
                p.TextOptions.LanguageCode = CountryCode.Japan;
                p.IsEastAsianLineBreak = true;
            }
7

Great, that worked! Now I save the excel file in pdf as below, then ‘。’ comes at the beginning of the lien again.

Aspose Textbox 2 (2).pdf (23.0 KB)

        MemoryStream stream = new MemoryStream();
        workbook.Save(stream, SaveFormat.Pdf);
        stream.SeekToZero();

        string fname = "test.pdf";
        return File(stream, MimeKit.MimeTypes.GetMimeType(fname), fname);
8

@AT1,

It is nice to know that it works when rendering to XLSX. Regarding rendering to PDF, we found the issue as you mentioned and will be looking into it soon.

9

@AT1,

As we reproduced Asian line break issue for shapes when rendering Excel file to PDF you pointed above, so, we have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-55511

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

10

@amjad.sahi
Thank you so much for your support!

11

@AT1,

You are welcome.

12

@AT1
Hi,
Your issue(CELLSNET-55511) has been resolved and the fixed functionality will be released with version 24.5.
Here is the resulting file generated using the latest function:
CELLSNET-55511.pdf (23.0 KB)

13

@duojie.yang
Thank you for the fix. I really appreciate your support as always.

14

@AT1
You are welcome. If you have any questions, please feel free to contact us.

15

The issues you have found earlier (filed as CELLSNET-55511) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi

16

This issue still persists with v24.5 when the text has multiple lines. Can you please advice me how to resolve this?

17

@AT1
Could you provide a sample file or code? We will further analyze it. Thank you!

18

@AT1,

I tested your scenario/case using the following sample code with Aspose.Cells for .NET v24.5 and it works fine. Both Excel and PDF files (attached) are Ok.
e.g.,
Sample code:

using Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets.First();

int textboxIndex = worksheet.TextBoxes.Add(1, 1, 60, 235);
TextBox textbox = worksheet.TextBoxes[textboxIndex];
textbox.IsTextWrapped = true;
textbox.Text = "こんにちは、今日はいい天気です。";

foreach(TextParagraph p in textbox.TextBody.TextParagraphs)
{
   p.Font.Name = "MS Gothic";
   p.TextOptions.LanguageCode = CountryCode.Japan;
   p.IsEastAsianLineBreak = true;
}

workbook.Save("e:\\test2\\out1_new1.xlsx", SaveFormat.Xlsx);
workbook.Save("e:\\test2\\out1_new1.pdf");

files1.zip (11.0 KB)

Could you please share your sample (runnable) code and output files for reference. We will check your issue soon.

19

@amjad.sahi

Thanks for your replay.
Please set the text blow and test again for me?

textbox.Text = “こんにちは、今日はいい天気です。\nこんにちは、今日はいい天気です。”;

20

@AT1,

Thanks for providing further details.

I used your new text. It is not an issue with the APIs as the text is wrapped and lines breaks are added OK. Please note, to display the whole text (if the text is long) properly, you need to extend the width/height of the text box a bit accordingly. Alternatively, you should create the text box with proper height and width. See the line of code that you may add to the code segment and it will work fine.

.......
textbox.Width= textbox.Width +20;
workbook.Save("e:\\test2\\out1_new1.xlsx", SaveFormat.Xlsx);
workbook.Save("e:\\test2\\out1_new1.pdf");

Hope, this helps a bit.