| View previous topic :: View next topic |
| Author |
Message |
utm1996 General User

Joined: 25 Jul 2011 Posts: 45
|
Posted: Mon Jul 16, 2012 11:16 am Post subject: [solved] styles & formatting |
|
|
is there a way to copy over styles (F11) from one spreadsheet to the other or do they need to be re-created in the new spreadsheet? _________________ ------------
OOo 3.3
------------
Last edited by utm1996 on Mon Jul 16, 2012 11:54 am; edited 1 time in total |
|
| Back to top |
|
 |
jrkrideau Super User

Joined: 08 Aug 2005 Posts: 6733 Location: Kingston ON Canada
|
|
| Back to top |
|
 |
utm1996 General User

Joined: 25 Jul 2011 Posts: 45
|
Posted: Mon Jul 16, 2012 11:52 am Post subject: |
|
|
Thank You! _________________ ------------
OOo 3.3
------------ |
|
| Back to top |
|
 |
karolus OOo Advocate

Joined: 22 Jun 2011 Posts: 208
|
Posted: Mon Jul 16, 2012 12:04 pm Post subject: |
|
|
Hallo
From out the other Calcfile you can import all Styles from an existing Doc by:
| Code: | Sub import_styles
doc = thisComponent
Styles_source_url = converttourl( "c:/your/path/to/doc_with_Styles.ods" )
styles = doc.getStyleFamilies()
options = styles.getStyleLoaderOptions()
styles.loadStylesFromURL( Styles_source_url , options )
End Sub |
Karo |
|
| Back to top |
|
 |
|