pasterflex.blogg.se

Working with Word 365 here, I haven't investigated as thoroughly as before, because my latest experiments suggest thatĪ. This suggests to me that the problem is actually at the Excel end, but it really is quite difficult to be sure! it might have to have all the cells formatted as LTR as well)ħ. I haven't yet found out exactly what that column has to contain (e.g. That seemed to fix the problem here, butī. Put the letter "a" in every cell in the column. So I added a column to Excel immediately before the Comments column, and just However, I then realised that Word got it wrong when the cell in the previous column contained only Hebrew text, and got it right when the text was "English only" or mixed. This all suggested that the problem was at the Word end.Ħ. XML, I could see that the first and third runs were marked as RTL. When I saved the Word document and looked at the underlying

When I first looked at the Edit Recipients dialog box in Word and examined the text in VBA using ("TheFieldName").Value there was no sign of any LTR/RTL markup. "(" made some difference, but again, did not fix the final ")"ĥ. Putting a Left-to-Right override character at the beginning of the cell, or even immediately before the In Excel, when I first looked at the Comment texts, the Cell/Paragraph direction was set to "Context", but setting them to LTR made no difference. The main thing I haven't really tried is to modify the SQL that gets the data fromĤ. Nothing else I have tried so far in Word has improved on that (although I can think of a few things that might make a difference, but I've run out of time for now. In Word, if I use Insert->Symbol->More Symbols.->Special characters to insert a Left-toRight Override charater immediately before the Mailmerge field that inserts this field, the first "run" is reversed, but the third run is not. 123 opening brace, which displayed in RTL isĢ. I believe that the "English" text is being treated as RTL text and that the algorothm that processes mixed RTL/LTR text is in effect deciding that the text is in three "runs":Ī. I was able to reproduce this behaviour (or something very similar) here.Ģ.