private bool ExportOOo()
{
try
{
SpreadSheetHelper helper = new SpreadSheetHelper(true);
//Samples for service sheet.SheetCell
unoidl.com.sun.star.sheet.XSpreadsheet xSheet = helper.getSpreadsheet(0);
unoidl.com.sun.star.table.XCell xCell = null;
//xCell = xSheet.getCellByPosition(1, 1);
//// --- Insert two text paragraphs into the cell. ---
//unoidl.com.sun.star.text.XText tText = (unoidl.com.sun.star.text.XText)xCell;
//unoidl.com.sun.star.text.XTextCursor tTextCursor =tText.createTextCursor();
//tText.insertString(tTextCursor, _title + "\r\n", false);
if (_gridType == 0)
{
for (int j = 0; j < _exportGrid.Columns.Count; j++)
{
xCell = xSheet.getCellByPosition(j + 1, 2);
// --- Insert two text paragraphs into the cell. ---
unoidl.com.sun.star.text.XText xText = (unoidl.com.sun.star.text.XText)xCell;
unoidl.com.sun.star.text.XTextCursor xTextCursor = xText.createTextCursor();
xText.insertString(xTextCursor, _exportGrid.Columns[j].HeaderText, false);
}
// --- Get cell B3 by position - (column, row) ---
for (int i = 0; i < _exportGrid.Rows.Count; i++)
{
if (_exportGrid.Rows[i].Visible)
{
for (int j = 0; j < _exportGrid.Columns.Count; j++)
{
xCell = xSheet.getCellByPosition(j + 1, i + 3);
unoidl.com.sun.star.text.XText xText = (unoidl.com.sun.star.text.XText)xCell;
unoidl.com.sun.star.text.XTextCursor xTextCursor = xText.createTextCursor();
xText.insertString(xTextCursor, _exportGrid.Rows[i].Cells[j].Value.ToString(), false);
}
}
}
}
else if (_gridType == 1)
{
for (int i = 0; i < _flexGrid.Rows; i++)
{
for (int j = 0; j < _flexGrid.Cols; j++)
{
xCell = xSheet.getCellByPosition(j + 1, i + 2);
unoidl.com.sun.star.text.XText xText = (unoidl.com.sun.star.text.XText)xCell;
unoidl.com.sun.star.text.XTextCursor xTextCursor = xText.createTextCursor();
xText.insertString(xTextCursor, _flexGrid.get_TextMatrix(i, j), false);
}
}
}
else
{
for (int i = 0; i < _listview.Items.Count; i++)
{
xCell = xSheet.getCellByPosition(1, i + 2);
unoidl.com.sun.star.text.XText xText = (unoidl.com.sun.star.text.XText)xCell;
unoidl.com.sun.star.text.XTextCursor xTextCursor = xText.createTextCursor();
xText.insertString(xTextCursor, _listview.Items[i].Text, false);
for (int j = 1; j < _flexGrid.Cols; j++)
{
xCell = xSheet.getCellByPosition(j + 1, i + 2);
xText = (unoidl.com.sun.star.text.XText)xCell;
xTextCursor = xText.createTextCursor();
xText.insertString(xTextCursor, _listview.Items[i].SubItems[j].Text, false);
}
}
}
helper.storeDocComponent(_filename);
helper.closeDocCompant();
return(true);
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(false);
}
finally
{
//_exportGrid.Dispose();
}
}
