I have so far found a couple of sources that discuss creation of ODS files: How to create ODS documents in .Net and
How to create .odt files with C#.NET?
And most interestingly an explanation for opening calc files. However this opens OpenOffice in fullscreen, what im looking for is some way to write to a Calc file (.ods) without actually opening Openoffice. So that I can write a function that just opens a savefiledialog, gets the filename and then creates and saves the .ods file.
Are there is any C# code examples available to do such a thing?
Best Answer
So I have finally resolved this issue and want to save others the hazel of going through this again. Basic points of HEADACE for me were:
C:/
notC:\
)Filtername
used should be set to the engine used to save the document. Possible values includewriter8
,calc8
,MS Excel 97
, so for spreadsheets you obviously need to use calc8PropertyValue
and setHidden
totrue
.Happy coding and dont forget to install the OpenOffice SDK to be able to add the unoidl references: