Ask Your Question
0

How to turn off direct formatting in Calc

asked 2012-10-30 17:02:18 +0200

TimG gravatar image TimG
1 1

updated 2013-02-01 10:15:06 +0200

qubit gravatar image qubit flag of United States
5709 3 48 41

Hi Guys:

Everytime I paste in some new string of text in a .csv file, Calc changes the font size to something really small. Then I have to go in andy clear direct formatting.

Is there a way to stop this from happening in the first place.

Thanks.

delete close flag offensive retag edit

1 Answer

Sort by » oldest newest most voted
1

answered 2012-10-31 06:22:45 +0200

UbuntuBrisbane gravatar image UbuntuBrisbane flag of Australia
121 2 3 13
http://ubuntubrisbane.wor...

Hi TimG!

You could use Right Click -> Paste Special... -> Unformatted text every time you want to paste something in your spreadsheet.

If you want to set up a keyboard shortcut to make it easier, you can create a macro and assign a shortcut to it as described in this answer.

Keep in mind you will need to activate the Macro functionnality first, by going into Tools -> Options -> LibreOffice -> General -> Enable Macro Recordings (or Experimental features if not present)

link delete flag offensive edit

Login/Signup to Answer

Donate

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!

Question tools

Follow

subscribe to rss feed

Stats

Asked: 2012-10-30 17:02:18 +0200

Seen: 194 times

Last updated: Oct 31 '12