How to save document in flat ODS (FODS) format?
Mon, 28 Mar 2016 - 8:06 AM
Hello. I’m using this macro function to save document as ODS:
Function SaveDocAsODS(ByVal FilePath As String)Dim SaveParams( 1 ) As New com.sun.star.beans.PropertyValue SaveParams( 0 ).Name = "Overwrite" SaveParams( 0 ).Value = TRUE SaveParams( 1 ).Name = "FilterName" SaveParams( 1 ).Value = "calc8" ThisComponent.storeAsURL(ConvertToURL(FilePath),SaveParams())End Function
How to save document in the FODS format?
Mon, 28 Mar 2016 - 1:26 PM
#2
“calc_ODS_FlatXML” and “Flat
“calc_ODS_FlatXML” and “Flat XML ODF Spreadsheet” gave me an error:
BASIC runtime error.
An exception occurred
Type: com.sun.star.task.ErrorCodeIOException
Message: SfxBaseModel::impl_store <file:///C:/Users/Username/Desktop/filename.fods> failed: 0x81a.
But the node oor:name attribute value “OpenDocument Spreadsheet Flat XML” has worked and the document was saved in FODS format. Thank you for help.
Instead of “calc8” try using “calc_ODS_FlatXML”.