Summary: | Link.hypertext formula gives me a difference in the information displayed is true and the actual link is false | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Cédric Quay <cedricquay> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | UNCONFIRMED --- | ||
Severity: | normal | CC: | miguelangelrv |
Priority: | medium | ||
Version: | 7.0.4.2 release | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Attachments: | Calc Table |
Description
Cédric Quay
2023-04-21 09:39:30 UTC
Created attachment 186832 [details]
Calc Table
Table with the bug
Please in what cell is the error, and what it should be? In the Tab (Recherche), if I type a texte in A1, I get a failure in link formula in A5 and below. I have a setup with direct link when click. When the document is saved, and you open it, it is correct but when the value in A1 is changed, it goes wrong in A5 and below i.e Pictures. (In reply to Cédric Quay from comment #3) > When the document is saved, and you open it, it is correct but when the > value in A1 is changed, it goes wrong in A5 and below i.e Pictures. No need to modify the text in cell A1. It is enough to do menu Data > Calculate > Recalculate Hard ([CTRL]+[SHIFT]+[F9]). It is indeed strange that the HYPERLINK() function shows one text but somehow points to a different cell (with offset +1 row). The offset (+1 row) seems to start in the third link in LO 7.0, but in 7.6.alpha the offset starts from a lower row (from A7). I can repro, but only based on the resulting behavior I see (which might or might not be about some bug). It is still not clear to me where exactly the problem resides. Perhaps it is about some quirk in the HYPERLINK() function, but I am not at all convinced. (In reply to m.a.riosv from comment #2) > Please in what cell is the error, and what it should be? Worksheet Recherche, recalculate hard: * cell A7 says "...A350" * cell A8 says "...A104" [CTRL]+click on A7 does not jump to data.A350 but to data.A104. It does not happen in upper rows, only from A7 and down. Also, go to A1, type in "a b" (without quotation marks) [ENTER], and repeat the test. |