[Libreoffice-bugs] [Bug 144168] New: Inconsistent ratio between Dialog.Model.Height and the height on the screen

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 144168
           Summary: Inconsistent ratio between Dialog.Model.Height and the
                    height on the screen
           Product: LibreOffice
           Version: 6.3.5.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mapurves at hotmail.com

Created attachment 174619
  --> https://bugs.documentfoundation.org/attachment.cgi?id=174619&action=edit
This spreadsheet will allow you to test the ratios of the measured and model
heights of three different dialogs.

I wanted to dynamically place a dialog above the active cell. This requires the
position of the top left corner of the cell, and the height of the dialog. The
origin for the cells is the top left corner of cell A1. The origin of the
dialog is the top left corner of the Calc sheet. The units for heights for the
position of the cell and dialog are different. I measure the height of the
dialog by aligning the top of the dialog with the top of the active cell, and
then doing the same with the bottom of the dialog with the top of the cell. I
then get the ratio of this height with the dialog.model.height.

Measured        Model   Ratio
200             78      2.57
258             106     2.44
564             247     2.29

The ratios are not consistent, and vary with the height of the dialog. Also,
the ratios change depending on how close, vertically, the active cell is to the
Row 0. One of our users tried this one a system running Ubuntu, and he had
ratios varying depending on the dialog etc. His ratios were quite different
from mine (windows vs Ubuntu)

It also seems that if I dynamically place the dialog so the top of the box
aligns with the top of the active cell that, if it aligns for a row near the
top of the spreadsheet, it drifts off the top of the row as the active row is
farther down. I suspect an error in a decimal place in the conversion
com.sun.star.util.MeasureUnit.MM_100TH or in Widows. It isn't a big thing, it
may be in the fourth decimal.

Finally, things don't align properly if Calc is not maximized and it moves to a
different place on the screen.

I am using 
Edition Windows 10 Home
Version 21H1
Installed on    ‎2020-‎11-‎26
OS build        19043.1165
Experience      Windows Feature Experience Pack 120.2212.3530.0

I have 8 GB RAM.
Processor: Intel(R) Pentium(R) CPU 2127U @ 1.90GHz   1.90 GHz

I have attached a very stripped down version of our spreadsheet. You can run
various tests with three different dialogs. To run a test, right click on a
cell and choose Event Input Wizard.

It is not imperative that we place the dialog exactly, but this could be an
issue for some of our users. At the moment, two of our users have requested
this feature. Consequently, I have chosen "minor" for severity.

-- 
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/20210829/4d2de6ea/attachment-0001.htm>