We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question
1

[SOLVED (Excel req. Calc non-default cell reference in hyperlink)] - Excel unable to handle LibreCalc created/modified hyperlinks [closed]

asked 2020-12-18 10:22:09 +0200

tmpacc gravatar image

updated 2020-12-21 07:53:08 +0200

When I modify and add hyperlinks in some xlsx sheets with Calc, Excel will be unable to resolve the hyperlink, popping it's error message.

I found this topic on OO https://forum.openoffice.org/en/forum... Unfortunately the solution by Villeroy does not say what magic is applied to make the hyperlink compatible across applications. example: C:\fakepath\CalcHyperlink.xlsx C:\fakepath\ExcelHyperlink.xlsx The hyperlink formatting looks the same to me.

Does anyone know what method to use?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2020-12-25 18:08:09.075797

Comments

Care to provide a working example file created by Excel and the same not working one (i.e. one link added) saved by LibreOffice? Edit your question to attach files with the paperclip.

erAck gravatar imageerAck ( 2020-12-18 11:58:22 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2020-12-18 12:36:05 +0200

erAck gravatar image

The difference is that in CalcHyperlink.xlsx the hyperlink is #Sheet2 stored as

<hyperlink ref="B3" location="Sheet2" display="Sheet2"/>

while in ExcelHyperlink.xlsx it is #Sheet2.A1 stored as

<hyperlink ref="B3" location="Sheet2!A1" display="Sheet2"/>

Apparently Excel can't cope with a sheet-only fragment and needs a cell reference included.

edit flag offensive delete link more

Comments

Thank you, that seems to be the case.

tmpacc gravatar imagetmpacc ( 2020-12-21 07:46:30 +0200 )edit

Please, if the answer solves the question click ✔.

m.a.riosv gravatar imagem.a.riosv ( 2020-12-21 11:53:04 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2020-12-18 10:22:09 +0200

Seen: 61 times

Last updated: Dec 21 '20