2

I would like to prevent libreoffice calc to make autocorrecion in some cases in some cell. For example, sometimes libreoffice decides that some text I enter is a hyperlink and it formats the cell as a hyperlink. How I can undo this autoformatting case? (When I press Ctrl+Z, calc removes my entered text). I do not need completely turn off autocorrection in libreoffice calc.

Improve this question
5
  • Hi Loom, it appears that you have two very similar questions which have slightly different scopes and information. Perhaps you could merge the two and delete one or the other? (cf superuser.com/questions/936904/…)
    – bertieb
    Commented Jul 6, 2015 at 14:49
  • Hi @bertieb. Yes, answers for both questions are for solving one problem. However, answers for both questions are differ, so I couldn't select right answer for the suggested merged question
    – Loom
    Commented Jul 6, 2015 at 16:12
  • Perhaps I'm missing something, neither of these questions have answers at time of writing- is there another set of questions you are referring to?
    – bertieb
    Commented Jul 6, 2015 at 16:13
  • It's looks my English obstructs my attempts to explain) I meant, that if each of my questions would have an answer, then these answers would differ. I would like to know answers for both questions. If I merged my questions I could lose one of the answers.
    – Loom
    Commented Jul 6, 2015 at 16:27
  • I understand now. In my opinion, the questions are similar enough that you could ask both in one post (as two bullet points), but you are entitled to your opinion as well.
    – bertieb
    Commented Jul 6, 2015 at 16:53

1 Answer 1

Reset to default
0

I think there's currently no way of doing this cleanly, here's a workaround:

Assuming you have entered e.g. http://test.com into a cell, and it got auto-formatted as a hyperlink.

  1. Click the cell so that it becomes active (make sure it has indeed become active, because clicking the hyperlink itself will do nothing)
  2. Select the text in the formula bar
  3. Cut it
  4. Press Enter (thus getting empty cell)
  5. Press Up (or click the cell)
  6. Press Ctrl+Shift+V to call Paste Special
  7. In the Paste Special dialog which appears click OK, making sure "Unformatted text" is selected in the list

Now you should have the link pasted without any special formatting.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .