I am writing a C# program to manipulate data from an ODS spreadsheet using the current LibreOffice SDK. I’ve used the various samples to write a test program that will open a spreadsheet file and get a cell, but can’t find anything that shows how to read data from that cell. I’ve spent days searching and reading documentation, but nothing explains how to do this very simple task.
I can get a cell with:
xCell = xSheet.getCellByPosition(1,2);
but I don’t know how to get the contents (value, string, formula). Lots of examples show how to set the cell contents, but nothing shows how to retrieve the cell contents.
Any help would be very greatly appreciated. Thank you!