Lock font in spreadsheet

Discuss the spreadsheet application
Post Reply
manoman
Posts: 62
Joined: Sat Aug 25, 2018 7:17 pm

Lock font in spreadsheet

Post by manoman »

I have poor vision and the only font I can easily read is Verdana. I have set it as my default. I use Open office spreadsheet to sort small text segments that I copy and paste from many sources. This results in a crazy quilt of fonts and font sizes that drives me nuts. Is there a setting that will paste in Verdana regardless of the font copied? If not, after entering all my various pasted text, is there a way to select all cells and change them all to Verdana 10? (Tools/Options/Fonts/Verdana/Ok does not work.)

Thanks
Libre Office 7.0.4.2 on Windows 10 Home 64 bit
User avatar
Zizi64
Volunteer
Posts: 11352
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: lock font in spreadsheet

Post by Zizi64 »

- Paste the contents from the foreign sources as Unformatted text.
- Use the styles instead of the direct formatting method.
- Ctrl-A, Ctrl-M resets the direct formatting properties to the default properties of the applied styles.
- Create templates with predefined styles, and use it (you can set one of your templates as the default template of the application).
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Post Reply