You are here

Calc

Removing hyperlinks from Open Office Calc

Submitted by Druss on Sat, 2011-11-26 20:46

If you have ever pasted data into Calc in Open Office, you'll notice that any hyperlinks in the input data will be retained as hyperlinks rather than reduced to plain text. While this might be beneficial behaviour to some, it wasn't for me this afternoon. After a little digging around, I found that an easy way of removing the hyperlinks is by highlighting all the affected cells, right-clicking and choosing the Default Formatting option.

The associated CTRL + M shortcut (as seen in the Format menu) did not work for me.

Converting Roman numerals into Decimal/Arabic/Indian equivalents

Submitted by Druss on Sun, 2011-09-18 22:41

While importing some data today, I found myself having to convert the Roman numerals in the source to decimal. While there are scripts and tools available on the Internet to do so, a quicker way exists (or, at least, it did for my case). This solution is to simply import the data into Open Office Calc and use one of its native functions to do the conversion.

Subscribe to RSS - Calc