Windows 11 Lisp Function vl-GetCellValue does not read formatted Foreign Characters

[vince_aman]

AutoCAD in Windows 11 the Lisp Function vl-GetCellValue does not retrieve Foreign Characters when a font style is applied within the cell contents. In Windows 10 the Lisp Function works properly. This happens in any version of AutoCAD, from 2022 - 2025. 

Any Table created without cell formatting can be read in Win 10 or Win 11.

This is an example of cell contents from Win 10:

"SEE DETAIL\\P{\\fMS PGothic|b0|i0|c128|p34;詳細を参照}"

I'm unable to read the Foreign Characters in Windows 11 to remove/change the formatting.

Manually attempting to remove the formatting from the entire table or individual cell does not work in Win 11...

(vla-setcelltextstyle tbl 2 5 "Japanese")  This will show the Cell's Text Style to be "Japanese" in the properties, but will not override the cell's text formatting...

Any Thoughts? 

[Sea-Haven]

is the problem the PGothic you have Bold and Italic color 128. What happens if you leave that part out ?

TextString = "sms\\Pabc\\P\\fSimSun|b1|i1|c128;詳細を参照"

Done manually maybe a lisp change PGothic to PSimSun via lisp

[vince_aman]

In Windows 10, the text string shows the Foreign Characters... In Windows 11, the Characters are all Question Marks "????"

The challenge is the table looks correct in Windows 11 AutoCAD, but I cannot retrieve the data with (vl-GetCellValue.... )

The data is inside the ACAD_Table Cell... I Cannot modify/remove formatting from the cell without getting the contents first... thus the problem. 

[vince_aman]

Here is what is happening in Windows 11:

[paullimapa]

What AutoCAD version are you running?

Enter About command, do a screenshot and share that here

[Sea-Haven]

What does this reveal you will have to select table object etc and use correct row column.

(setq tableobj (vlax-ename->vla-object (car (entsel "\nPick table object "))))
(vla-gettext tableobj row column)

[vince_aman]

Any version of AutoCAD from 2022 (1.5) - 2025....  Again, not an issue in Windows 10

[vince_aman]

Thanks for your reply... Same result

Windows 11:

Windows 10:

[Moshe-A]

@vince_aman ,

The fact you say in window 10 it is working brings me think your local setting is not well set?

load "Japanese" language check country and current language.

Moshe

[vince_aman]

Hi Moshe,

Thanks for the suggestion... something to look into (language packs?), although I don't want to change the language/local settings as we have multiple languages and multiple countries to support. 

The interesting part is the error does not happen if there is no formatting in the cell... 

This is a non-formatted cell in Windows 11:

A few months back, I changed all the workflows for the tables to remove the formatting, as it was creating issues with exporting and transferring schedules to different files within the project. The problem is the thousands of legacy Dwgs which will need to be used/converted...