How to Configure FilterOptions in saveAsURL and Its Effects

[kabi5n]

Hello,

I am automating Excel file manipulation using LibreOffice’s COM services.

My goal is to open a template Excel file, edit it, and save it as a new file with the “Read-Only Recommended” option enabled. I assume this can be achieved by setting the appropriate PropertyValue for FilterOptions in the saveAsURL method, but I am not sure what keys and values to use.

Additionally, when I open an Excel file that already has the “Read-Only Recommended” option set and save it under a new name, the file ends up marked as “Final” instead.

I believe mastering the use of FilterOptions might resolve this behavior. Could anyone provide guidance or examples on how to adjust it properly?

Thank you for your help!

[Villeroy]

This is difficult to find out:

	ds = doc.createInstance("com.sun.star.document.Settings")
	ds.LoadReadOnly = True

[fpy]

@Villeroy

LoadReadOnly

"Open file read-only" by default

Both can be done. For question 1, start with an empty Writer document and check “Open file read-only.” Then save this as the default template: File → Templates → Save as Template; check “Set as default template”. For question 2, add this macro to Module1 via Tools → Macros → Organize Macros → LibreOffice Basic. Sub SetReadOnly oDoc = ThisComponent oSettings = oDoc.createInstance("com.sun.star.document.Settings") oSettings.LoadReadOnly = True oDoc.Store oDoc.Close(True) E…