<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Inconsistent ratio between Dialog.Model.Height and the height on the screen"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144168">144168</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Inconsistent ratio between Dialog.Model.Height and the height on the screen
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.5.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>minor
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>mapurves@hotmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=174619" name="attach_174619" title="This spreadsheet will allow you to test the ratios of the measured and model heights of three different dialogs.">attachment 174619</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=174619&action=edit" title="This spreadsheet will allow you to test the ratios of the measured and model heights of three different dialogs.">[details]</a></span>
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>