OpenOffice Calc - URL in Calc cell makes in nearly inaccessible
When I put some text into a cell that includes a URL, the text in the cell becomes silver-gray, it will not wrap, it becomes very difficult to edit or copy.
It's like the URL just cannot be properly handled.
I would add that I do NOT want it to act as a link. In fact I would normally want to disable hyperlinks entirely. The "feature" of trying to embed a hyperlink is a curse, probably inherited from Excel, where it is also a curse.
It's like the URL just cannot be properly handled.
I would add that I do NOT want it to act as a link. In fact I would normally want to disable hyperlinks entirely. The "feature" of trying to embed a hyperlink is a curse, probably inherited from Excel, where it is also a curse.
Who is Participating?
I have tried your suggestion. I hope it works to disable the URL linking.
However, it has not effect on the issues prompting this ticket--that is the text in the Calc cell is still silver gray, and still very hard to access, and still will not wrap.
Your suggestion did give me hope that there is also a way to turn of spell checking in Calc but not in Writer. I have not found that yet either.
However, it has not effect on the issues prompting this ticket--that is the text in the Calc cell is still silver gray, and still very hard to access, and still will not wrap.
Your suggestion did give me hope that there is also a way to turn of spell checking in Calc but not in Writer. I have not found that yet either.
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
-
Course of the Month6 days, 3 hours left to enrollMonitoring and Operating a Private Cloud with System Center 2012 R2 273 lessons
From OO Help:-
Turn off URL Recognition
1.Load a document of the type for which you want to modify the URL recognition.
If you want to modify the URL recognition for text documents, open a text document.
2.Choose Tools - AutoCorrect.
3.In the AutoCorrect dialog, select the Options tab.
4.If you unmark URL Recognition, words will no longer be automatically replaced with hyperlinks.
In OpenOffice.org Writer there are two check boxes in front of URL Recognition. The box in the first column is for later post-editing and the box in the second column is for AutoCorrect as you type.
It seems that once you do this, the setting is remembered.