OpenOffice Calc

Hello, I simply can't afford Microsoft Office. Is there any documentation on OpenOffice.org Calc? For starters I just want to open an OpenOffice.org Calc new file write in a cell and close it. Obviously,I'd like to do more, but I could not find ANY documentation. So for starters, it's enough. Hopefully I can take it from there.

Thank you

Tuli

[Walter Roberson]

Please clarify the connection between your question and Matlab ?

[Naftali Herscovici]

what is the variation of the code below for OpenOffice Calc?

% 20110223 Tuli make excel INVISIBLE
% OPEN EXCEL APPLICATION
h = actxserver('Excel.Application');

% Show the Excel window
% set(h, 'Visible', 1); Tuli
set(h, 'Visible', 0);
% INSERT NEW WORKBOOK
W = h.Workbooks.Add;

% WORKBOOKS CONTAIN WORKSHEETS
Sheets = h.ActiveWorkBook.Sheets;

% Add a fourth sheet (by default, a workbook contains
% three worksheets - add a new one before [], after #3)
Sheets.Add( [], Sheets.Item(3) )

% Rename
Sheets.Item(1).Name = 'History Long';
Sheets.Item(2).Name = 'History Short';

% Set active sheet #1
Sheets.Item(1).Activate;
ActiveSheet = h.Activesheet

Answer 1

[Kaustubha Govind]

If you are asking about interfacing MATLAB with OpenOffice, you can use the OpenOffice API. There is documentation on interfacing MATLAB with both C++ and Java applications (both languages are supported in the OpenOffice API).