Ask Your Question

[Calc] links saving improperly

asked 2018-08-14 22:24:16 +0200

bengineer gravatar image

I've added links to URLs in several cells. When saving in .xls format (this sheet has to be .xls; I can't do .ods), some of the links seem to lose their status as links, instead formatting themselves as blue plain text. See image below.

image description

Note that the top cell text has retained its link,

This was fine earlier, with multiple links working fine in one cell. However, recently, I started getting a general I/O error when trying to save the document, with LibO telling me that the document was locked for editing by another user. That's weird because the file is stored on my local drive. I saved it with a different name, popped it back open, and it was fine. Shut the computer down, booted it back up today, and the links are gone.

Running LibO on Windows 10. Any ideas?

edit retag flag offensive close merge delete


First thing would be test a newer version (current still branch is 6.0) to see if it has been fixed there. Otherwise, a bug report is expected, with e.g. an ODS with links which convert to simple colored text upon saving to XLS.

Mike Kaganski gravatar imageMike Kaganski ( 2018-08-14 22:33:55 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-08-15 09:37:29 +0200

JBF gravatar image

If LO don't know that it is you who is editing a file, that is because you did not set your name in Tools > Options > LibreOffice > User Data

For hyperlink, you should use HYPERLINK() function:

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-08-14 22:24:16 +0200

Seen: 27 times

Last updated: Aug 15 '18