lilah Posted March 29, 2022 Share Posted March 29, 2022 How can I change the text settings on the worksheets so that the writing direction is not reversed? In the languages written from right to left. Quote Link to comment
0 Pat Stanford Posted March 29, 2022 Share Posted March 29, 2022 On the Mac you should get proper right to left entry in a worksheet by changing the Keyboard in the OS to Hebrew. See the following Apple support link. https://discussions.apple.com/thread/7365604 Quote Link to comment
0 lilah Posted March 30, 2022 Author Share Posted March 30, 2022 Pat, thanks for the quick response. Unfortunately the problem is more complex, there is no difficulty in switching to Hebrew or Arabic by changing the keyboard. The problem occurs when importing the worksheet into the file, whether from an internal source or from an external Excel program. Moreover when finding a file for Excel the text is obtained properly. Quote Link to comment
0 lilah Posted March 30, 2022 Author Share Posted March 30, 2022 ODBC driver information ?? Can an ODBC driver provide a language conversion solution? Quote Link to comment
0 Pat Stanford Posted March 30, 2022 Share Posted March 30, 2022 Can you tell us what you are actually trying to do and provide a sample of the Excel file in question or a mockup of it? Quote Link to comment
0 lilah Posted March 31, 2022 Author Share Posted March 31, 2022 Proper writing in Hebrew In the source file Reverse the letter orientation after inserting the file into the sheet Note, where the resource the software displays correctly. Quote Link to comment
0 lilah Posted March 31, 2022 Author Share Posted March 31, 2022 תקציב חודשי אישי1.xlsx Untitled 1.pdf Quote Link to comment
0 Pat Stanford Posted March 31, 2022 Share Posted March 31, 2022 My Hebrew is non-existent, so I am just working with shapes. The character order does not seem to reverse when I copy and paste from Excel to a VW Worksheet, but the column order does. 😞 I am running Mac OS11.6.2 and Excel 16.59 from the Microsoft 365 subscription. The blue highlights in the worksheet is the range I pasted from the green dashed area of the Excel sheet. I believe the double quotes at the end/beginning of the cells are stray markers that there was cells merges in Excel. The second image is an Excel worksheet that was Imported into VW. Again, to my eye, the character order does not look reversed, by the column order does. Are you on Mac or Windows? Quote Link to comment
0 taliho Posted March 31, 2022 Share Posted March 31, 2022 Lilah- I have seen excel spreadsheets invert text when using an older 32 bit Microsoft Office on the new 64bit Macs, Catalina and newer . The problem may be there, and not in Vectorworks specifically.... Tali 1 Quote Link to comment
0 lilah Posted April 5, 2022 Author Share Posted April 5, 2022 In addition to the Windows issues (which are more severe)... We did a test on a new MacBook pro with OS Moneterey 12.3.1 - we imported a Numbers worksheet with Hebrew. As you can see, the Hebrew letter order became mangled when we zoom in. I attach 3 images - from low to high resolution, and you can see that the text gets broken when it is long. We tested different cell widths, and it seems unrelated. It seems as if the only predictive is the ratio of zoom to text length. Quote Link to comment
0 lilah Posted April 5, 2022 Author Share Posted April 5, 2022 On 4/1/2022 at 2:03 AM, taliho said: Lilah- I have seen excel spreadsheets invert text when using an older 32 bit Microsoft Office on the new 64bit Macs, Catalina and newer . The problem may be there, and not in Vectorworks specifically.... Tali Hi Tali, The main problem is the use of worksheets within vectorworks software. The ability to export the files to external software is an important addition but not the main one. What is amazing is that there is no problem with exporting the text content, the problem appears in the editing stage within this part of the software. (In windows) Thank you, Lilah Quote Link to comment
Question
lilah
How can I change the text settings on the worksheets so that the writing direction is not reversed? In the languages written from right to left.
Link to comment
12 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.