[Libreoffice-bugs] [Bug 125764] New: hyperlink active region inaccurate in scaled sheet (truncated fractions?)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125764

            Bug ID: 125764
           Summary: hyperlink active region inaccurate in scaled sheet
                    (truncated fractions?)
           Product: LibreOffice
           Version: 6.2.3.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: gekacheka at yahoo.com

Description:
The location of the active region of a hyperlink is inaccurate when
- a spreadsheet is scaled, and
- a cell contains long text (such as a dozen words) before a hyperlink.
- the cell is not being edited.

(I'm using 'active region' to name the region where the cursor turns into a
hand and where control-click will follow the hyperlink.)

There is no error if the cell is scaled to 100%. 
There is error when the spreadsheet is zoomed out to 65% or zoomed in to 200%.
The direction of the error is the same for both shrinking to 65% and expanding
to 200%: both shift the region to the left.
If the cell is not wrapped, then the active region will be a bit to the left.
If the cell is wrapped, then the active region may be at the end of the
previous line.

(Guess: Maybe the scaled region location calculation is truncating fraction
bits, so the sum of scaled letter widths may become too small both when scaling
up and when scaling down.)

There is no error while the cell is being edited, so a correct algorithm is
known.

Steps to Reproduce:
1. Open attached spreadsheet "HyperlinkRegionInaccurateInScaledSheet.ods"
(The initial scale should be 65%.  If not, change the scale to 65% with the
slider at the lower right.)
2. Hover the mouse near the hyperlink of the word "end" in cell A1.


Actual Results:
Cell A1:
At 65% magnfication, cursor turns to hand over 'RY' of 'VERY'.
At 200% magnification, cursor turns to hand over 'Y e'.
At 100% magnification, cursor turns to hand over 'end', correctly.
F2 in A1 to edit cell, then 'end' is highlighted correctly at all
magnifications.
Cell B1:
At 65% magnification, if the cell is wrapped, then cursor may turn to hand at
the end of the previous line, not near the word 'end'.


Expected Results:
In each scale, the cursor should turn to a hand when it hovers over the word
'end'.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.2.3.2 (x64)
Build ID: aecc05fe267cc68dde00352a451aa867b3b546ac
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded

Also reproduced in 

Version: 6.3.0.0.beta1 (x64)
Build ID: a187af327633f5f00363be5131bd21a13e0f1a7b
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190607/813cb92d/attachment.html>