We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

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

asked 2012-05-17 20:26:36 +0200

badgerbio gravatar image

updated 2020-07-29 11:52:44 +0200

Alex Kemp gravatar image

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!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-16 03:56:23.477745


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

qubit gravatar imagequbit ( 2013-01-25 23:11:58 +0200 )edit

@qubit 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.

alwayssummer gravatar imagealwayssummer ( 2015-05-29 12:21:05 +0200 )edit

Hi I also can not make it work from that solution. I have a spreadsheet in LibreOffice Calc 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.

alia gravatar imagealia ( 2015-06-02 05:26:12 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2012-05-18 15:54:05 +0200

w_whalley gravatar image

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.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2012-05-17 20:26:36 +0200

Seen: 1,232 times

Last updated: May 18 '12