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

Aspose.Cells Product Family
27

@AT1
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-55715

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.

28

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

29

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

30

I have just found out that it does not work with some characters, e.g. “」” “ー”. They don’t come at the beginning of the line when creating PDF from Excel.

Also, IsHangingPunctuation = false; does not work at all.

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

Thank you.

31

@AT1
We can reproduce the issue by testing it on the latest version v24.6 using the following sample code. Found that TextParagraph.IsHangingPunctuation Attribute does not work when converting files to PDF. Please refer to the attachment. out_net.zip (43.6 KB)

The sample code as follows:

Workbook workbook = new Workbook();
workbook.Settings.Region = CountryCode.Japan;
Worksheet worksheet = workbook.Worksheets.First();

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

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

workbook.Save(filePath + "out_net2.pdf");

foreach (TextParagraph p in textbox.TextBody.TextParagraphs)
{
    p.Font.Name = "MS Gothic";
    p.TextOptions.LanguageCode = CountryCode.Japan;
    p.IsEastAsianLineBreak = true;
    p.IsHangingPunctuation = false;
}
workbook.Save(filePath + "out_net1.pdf");

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-56104

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.

32

@John.He

Thank you for your reply.
The text is better as below so that you can see these characters appear on wrong positions.

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

There must be some more characters which are not supposed to be at the 1st or the last of each line. Please check the specifications of Excel.

Thank you.

33

@AT1,

Thank you for your feedback and the suggested text to demonstrate the incorrect characters positions. We have logged it with your existing ticket (“CELLSNET-56104”) in our database. We will evaluate your issue soon. Once we have an update or figure it out, we will let you know here.

34

@AT1
After carefully studying the way Excel handles punctuation, we optimized the handling of punctuation to make it more suitable for Excel’s processing mode.
The fixed functionality will be released with version 24.7.

35

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

36

Hi,

I have tested version 24.7. I still find some characters in wrong positions.
Would you please list up here all the characters that are handled in version 24.7?
The following is MS Word Asian Typography options. I would like to see the difference compared with them.

Cannot start line
!%),.:;?]}¢°’”‰′″℃、。々〉》」』】〕゛゜ゝゞ・ヽヾ！％），．：；？］｝｡｣､･ﾞﾟ￠

Cannot end line
$([{£¥‘“〈《「『【〔＄（［｛｢￡￥

Thank you.

37

@AT1,

We apologize that the fixed version does not meet all of your character requirements. We will investigate this matter promptly.

We would also appreciate it if you could provide some example strings that we could try for evaluation to cover all these characters.

38

@amjad.sahi

Thanks for your reply.
I have just created a text that contains some characters that our clients use quite often. Apparently it does not cover all the characters but this is the best I can do for you now.
Also an outcome of Excel is attached so that you can see the differences.

Test_Excel.pdf (28.2 KB)
Test_Aspose_24.7.pdf.pdf (10.4 KB)

    int textboxIndex = worksheet.TextBoxes.Add(0, 1, 800, 235);
    Aspose.Cells.Drawing.TextBox textbox = worksheet.TextBoxes[textboxIndex];
    textbox.IsTextWrapped = true;
    var text = new StringBuilder();
    text.AppendLine("こんにちは、今日はいい天気です。");
    text.AppendLine();
    text.AppendLine("こんにちは、今日はいい天気です、と思う。");
    text.AppendLine();
    text.AppendLine("こんにちは、今日はいい天気です？");
    text.AppendLine();
    text.AppendLine("こんにちは、今日はいい天気です！");
    text.AppendLine();
    text.AppendLine("今日の夕飯は、特別に大きいステーキです。");
    text.AppendLine();
    text.AppendLine("今日は、皆で「ディズニーランド」に行きます。");
    text.AppendLine();
    text.AppendLine("今日は、皆で『ディズニーランド』に行きます。");
    text.AppendLine();
    text.AppendLine("今日は、皆で【ディズニーランド】に行きます。");
    text.AppendLine();
    text.AppendLine("今日は、皆で（ディズニーランド）に行きます。");
    text.AppendLine();
    text.AppendLine("今日夕方、会社が終わってから「ディズニーランド」に行きます。");
    text.AppendLine();
    text.AppendLine("今日夕方、会社が終わってから『ディズニーランド』に行きます。");
    text.AppendLine();
    text.AppendLine("今日夕方、会社が終わってから【ディズニーランド】に行きます。");
    text.AppendLine();
    text.AppendLine("今日夕方、会社が終わってから（ディズニーランド）に行きます。");
    textbox.Text = text.ToString();

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

@AT1,

Thanks for the sample files and text strings.

We have tested and found that the issue still persists with certain characters in the text strings you provided. Some characters are being rendered in the wrong positions within the text box during the Excel to PDF conversion.

We will thoroughly evaluate the issue from all aspects. 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-56207

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.

40

@AT1
Your issue(CELLSNET-56207) has been resolved and the fixed functionality will be released with version 24.8.
The following is the result file generated using the sample code:
CELLSNET-56207.pdf (28.7 KB)

41

@duojie.yang

Thank you very much for the fix. I had a look at the result file and found that the following line is the same as before. Have you decided not to handle this for some reasons?

今日の夕飯は、特別に大きいステ
ーキです。

42

@AT1
Thank you for your feedback. We will further investigate your issue. Once there is an update, we will notify you immediately.

43

@AT1
The “ー” in this line was missed in a previous fix. This has been fixed. While we have fixed most common punctuation, we may not be able to cover all punctuation. If you find punctuation that needs to be fixed, please contact us.
CELLSNET-56207-fix.pdf (28.7 KB)

44

@duojie.yang
Thank you so much for your support. I really appreciate that.

45

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

46

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