Now I want to save this spreadsheet to a name that exists in some cells with the same program.
The path => C3 (c:\temp) the filename => C4 (Test.ods)
I tried with this code
- Code: Select all Expand viewCollapse view
sPath := oDoc.getSheets.getByName(SheetName).getCellRangeByName("C3").getString
sFileName := oDoc.getSheets.getByName(SheetName).getCellRangeByName("C4").getString
- Code: Select all Expand viewCollapse view
sSaveToURL := ConvertToURL(sPath & sFileName)
Error: Call to nonexistent function.
Specifically: ConvertToURL(sPath & sFileName)
Skipped the conversion and did the following steps .:
- Code: Select all Expand viewCollapse view
sSaveToURL := "file:///c:/temp/Test.ods" ; Windows "c:\Temp\Test.ods"
oDoc.storeToUrl(sSaveToURL, Array(MakePropertyValue(oSM, "FilterName", "Calc8")))
- Code: Select all Expand viewCollapse view
oDoc.storeToURL("file:///c:/temp/Test.ods", Array())
Both tests give the same error
I don't know if "FilterName" and "Calc8" are correct (I have no idea what else can be in this fields)Error: 0x80020005 - Typmatchningsfel.
Specifically: storeToURL
How to save the unnamed spreadsheet to the hard drive?