[Solved] How to create new SS with only one sheet

[Herb40]

When I create a new SS with code such as shown below, Calc creates a SS with 3 sheets. Is there some property value or filter I can use to have Calc create only 1 sheet? Thanks for your help.

Code: Select all

	Dim nDoc as Object
	Dim nPV(1) as New com.sun.star.beans.PropertyValue
	nPV(0).Name = "Hidden"
	nPV(0).Value = True
	nPV(1).Name = "ReadOnly"
	nPV(1).Value = False
	sURL = "private:factory/scalc"
	nDoc = StarDesktop.LoadComponentFromUrl(sURL, "_blank", 0, nPV())

Tagged as Solved as per the last post by the OP. floris v, moderator

[Lupp]

The default template should be used here.
Create a spreadsheet document with only one sheet, save it as a template and make it your default template for spreadsheets.
You can also name (give by URL) a template (with only one sheet) explicitly for your LoadComponentFromURL call. (This instead of the as-if URL).

(I did not test this, and I didn't do it for a long time in AOO.)

(Editing: Just tested the second option again. It will create an 'Untitled...' spreadsheet document if called for a .ots file as expected.)

[Herb40]

Thanks for your help, Lupp.

I tried the second option, but had to add the Property "AsTemplate" with a value of True in order to make it work.