worksheets, Inverted text

[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.

[Pat Stanford]

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

[lilah]

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.

[lilah]

ODBC driver information ??

Can an ODBC driver provide a language conversion solution?

[Pat Stanford]

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?

[lilah]

[lilah]

 

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.

 

[lilah]

תקציב חודשי אישי1.xlsx Untitled 1.pdf

[Pat Stanford]

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?

[taliho]

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

[lilah]

Windows

[lilah]

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.

 

 

[lilah]

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