1

I'm populating a Word document using DocumentFormat.OpenXml in .Net Core 5.0, the text is coming from a database, sometime the text includes Arabic text with few English words, the words do not appear in the right order, for example if this is a an Arabic text and the 2nd work is English "one TWO three" it will appear in Word document like this "three TWO one", if I copy the same text from database and paste it in Word it will appear in the correct order.

I think Word is dividing the text I'm pasting to different runs and put them in the right order but in my code I'm placing the complete text in one run, is there a way to process this automatically by OpenXML or I have to do it manually?

here is my code:

int rowNo = 2;
  foreach (DataLine line in data.Lines)
  {
    TableRow row = table.Elements<TableRow>().ElementAt(rowNo++);
    Paragraph p1 = row.Elements<TableCell>().ElementAt(0).Elements<Paragraph>().First();
    Run r1 = new();
    Text t1 = new(line.AmountString);
    r1.AddChild(t1);
    p1.AddChild(r1);
    
    Paragraph p2 = row.Elements<TableCell>().ElementAt(1).Elements<Paragraph>().First();
    Run r2 = new();
    Text t2 = new(line.Description);
    r2.AddChild(t2);
    p2.AddChild(r2);
    
    ParagraphProperties pp = p2.ChildElements.First<ParagraphProperties>();
    BiDi bidi = new BiDi();
    pp.TextDirection = new TextDirection() { Val = TextDirectionValues.TopToBottomRightToLeft };
    pp.Append(bidi);
}

The last 4 lines make no difference.

Note that the Work document is well formatted with correct text direction and fonts.

Regards

Ameen

Ameen Nihad
  • 21
  • 2
  • The following may be helpful: https://social.msdn.microsoft.com/Forums/office/en-US/22e59387-8b00-4436-aa70-8372b3fc560a/how-to-change-openxml-word-document-language-culture-info?forum=oxmlsdk – Tu deschizi eu inchid Jul 16 '21 at 15:11
  • Unfortunately, the link is not relevant, if a paragraph contains RTL and LTR text, you can't put that text in a single Run, you have to separate them in separate Runs and set the right RunProperties for each, I was wondering if there is a built-in feature in DocumentFormat.OpenXml to do that!, because doing this manually is a lot of work and it's likely there will be some exception that I might miss. – Ameen Nihad Jul 17 '21 at 17:35
  • I think that it's uncommon to mix text from multiple languages in the same document-even more uncommon to mix them in the same paragraph. – Tu deschizi eu inchid Jul 17 '21 at 17:47
  • It is very common in middle east to put English words in paragraphs of local languages at least in (Arabic & Persian), for instance if I want to write "I work for Microsoft partner in Iraq" in Arabic I would leave Microsoft as is in English. Anyway, I found the solution to this issue it's in the RunPropoerties. – Ameen Nihad Jul 17 '21 at 18:12

1 Answers1

0

It turned out that it's possible to put RTL and LTR text in single Run, the following RunPropoetries worked for me:

run.RunProperties = new RunProperties
  {
    RunFonts = new RunFonts { ComplexScript = "Calibri" },
    RightToLeftText = new RightToLeftText(),
    Languages = new Languages() { 
      Bidi = new StringValue("ar-IQ"), 
      Val = new StringValue("en-US") 
    }
  };

I extracted the values from a Word document created in MS Word, but there the paragraph was separated to 3 Runs.

Credit goes to (amiry jd) who had the same issue 5 years ago check this post

Ameen Nihad
  • 21
  • 2