CALC - Custom page style saved in default template not showing up when existing spreadsheet opened

[badgerbio]

Title pretty says it all.
I have a program which generates XLS (excel) format workbooks on a linux machine. I want to format the worksheets in an automated fashion. I am trying to 1) change style to landscape 2) add header with sheet name 3) fit each sheet to 1 page

I figured the easiest way to do this was to define a custom style that did 1,2, and 3 then write a macro to apply this style to a given file.

I made the custom style then saved it in the default template. When I create a new spreadsheet, the custom style is available in the F11 Styles menu. However, if I open an existing xls file, the only styles that show up are Default and Report.

I’ve searched the forums and can’t get anywhere.

any thoughts? Thanks!

[qubit1]

@badgerbio – Did @w_whalley’s Answer help you out? Are you still looking for some insight into your problem? Please let us know!

[alwayssummer]

@qubit1 I had the same question and the solution below did not work for me. From the link below “Open Styles and Formatting window. Click the New Style from Selection icon and keep the mouse button pressed. Choose Load Styles from the submenu.” Click the New Style from Selection icon and keep the mouse button pressed does nothing. No submenu pops up.

[alia]

Hi
I also can not make it work from that solution.
I have a spreadsheet in LibreOffice Calc 4.3.2.2 I have created my cell and pages styles. Saved the spreadsheet as a template so can open and use for new spreadsheets.
However - I would like to be able to load the style into an existing spreadsheet, like you can in Writer. (New style from selection and Load styles).
This option is not available in Calc, or at least I can not find it.
Any help much appreciated.

[w_whalley]

There is a way to import styles from one document to another. See this link in the LibreOffice help pages. If you want to change an existing style to the imported one, choose the overwrite option in the Load Styles dialog.

Or, perhaps the Template Changer extension will work better for your needs.