Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.
COURSE of the MONTH
9 days, 19 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
OpenOffice Calc - URL in Calc cell makes in nearly inaccessible
Posted on 2006-07-03
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
4 Comments
I have already turned off Hyperlinks - I agree that they are a pain.
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.
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.
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.
Featured Post
![[Webinar] Lessons on Recovering from Petya](https://filedb.experts-exchange.com/files/public/2017/7/11/dcb3272a-62a8-4274-a34e-d1771610ec3b.png)
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
As the Marketing Director for the company I work for, time is a commodity that I have relatively little of. My time is divided between coaching my team, creating a direction for our company's future AND actually getting stuff done. As a result, I …
The advancement in technology has been a great source of betterment and empowerment for the human race, Nevertheless, this is not to say that technology doesn’t have any problems. We are bombarded with constant distractions, whether as an overload o…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month9 days, 19 hours left to enroll
762 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.