為何在 libreoffice calc 加超連結後多行文字格式就不見了

[jsea2000]

Question1.jpg

為何在 libreoffice calc 加超連結後多行文字格式就不見了?

[franklin]

LibreOffice Calc - Generating hyperlinks in cells

I currently have a spreadsheet that I keep gps decimal coordinates in. I wish to be able to enter a set of coordinates (i.e. 39.768417, -86.158029) and have LibreOffice automatically generate a google maps link based on those coordinates. For example, clicking 39.768417, -86.158029 would take you to https://www.google.com/maps/place/39.768417,-86.158029 Is it possible to accomplish this task? I have searched and cannot find anything relative to what I am trying to do.

我想用 HYPERLINK() 函式應該就可以達到目標。

14602328902719766.ods