First time here? Check out the FAQ!
asked 2012-05-17 20:26:36 +0200badgerbio
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!
answered 2012-05-18 15:54:05 +0200w_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.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-05-17 20:26:36 +0200
Seen: 258 times
Last updated: May 18 '12