Topic: Select a range of cells at OpenOffice Calc

[Doctor_Che]

How can I open/show the OpenOffice Calc window and select a range of cells by mouse?

Ihave an example for MS Excel, but it does not work for OO Calc.

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

Code: [Select]

Application aborted: ActiveX Server returned the error: unknown name: VISIBLE
Application aborted: ActiveX Server returned the error: unknown name: SELECTION


[roy_043]

These OO related links may help:
http://www.theswamp.org/index.php?topic=31362.0
http://www.theswamp.org/index.php?topic=35157.0
http://www.theswamp.org/index.php?topic=46634.0