0 Members and 2 Guests are viewing this topic.
It works if I know the quantity of numbers into a cell but sometimes I use real number to convert to fractional ( inch value ) like: (rtos 123.456 5 4) and that does not come "123 7/16" correctly in its cell and it comes like 1975/16 which is incorrect.
(setq cell (vlax-variant-value (vlax-get-property AppCells "Item" (vlax-make-variant row) (vlax-make-variant col))))(vlax-put-property cell "NumberFormat" (vlax-make-variant "##/##"))(vlax-put cell 'value2 string)
Heh....Lee is speaking VBA while Coder is speaking LISP.
Quote from: Greg B on May 14, 2019, 09:00:29 AMHeh....Lee is speaking VBA while Coder is speaking LISP.<game buzzer> Incorrect. He's using a VBA reference doc to illuminate properties / methods that can be accessed / invoked via any language that does ActiveX, including (ill named) Visual LISP.
I have it working sometimes but sometimes the value is incorrect.Code: [Select](setq cell (vlax-variant-value (vlax-get-property AppCells "Item" (vlax-make-variant row) (vlax-make-variant col))))(vlax-put-property cell "NumberFormat" (vlax-make-variant "##/##"))(vlax-put cell 'value2 string)
Quote from: MP on May 14, 2019, 09:47:14 AMQuote from: Greg B on May 14, 2019, 09:00:29 AMHeh....Lee is speaking VBA while Coder is speaking LISP.<game buzzer> Incorrect. He's using a VBA reference doc to illuminate properties / methods that can be accessed / invoked via any language that does ActiveX, including (ill named) Visual LISP.*cough* COM *cough*