Select a range of cells at OpenOffice Calc

Started by Doctor_Che, November 19, 2015, 04:15:46 AM

Previous topic - Next topic

Doctor_Che

How can I open/show the OpenOffice Calc window and select a range of cells by mouse?
I have an example for MS Excel, but it does not work for OO Calc.
Code (autolisp) Select
(princ "\nDictionary is not found. Please type data area manualy")
            (vlax-put-property ExcelApp 'Visible :vlax-true) ;open Excel
            (getstring "\nselect data area in Excel and then press enter")
            (setq used_range (vlax-get-property ExcelApp 'Selection))
            (setq lst (vlax-safearray->list (vlax-variant-value (vlax-get-property used_range 'Value))))
            (setq WorkBook (vlax-get-property ExcelApp "ActiveWorkBook"))

I just try it.
QuoteApplication aborted: ActiveX Server returned the error: unknown name: VISIBLE
Application aborted: ActiveX Server returned the error: unknown name: SELECTION