Bug 99792 - Formula objects display eight handles but none of them can be used for anything
Summary: Formula objects display eight handles but none of them can be used for anything
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
: 58731 58757 90947 102903 117359 119946 127948 131074 152377 (view as bug list)
Depends on:
Blocks: Formula-Editor
  Show dependency treegraph
Reported: 2016-05-12 08:19 UTC by How can I remove my account?
Modified: 2023-12-11 17:20 UTC (History)
12 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description How can I remove my account? 2016-05-12 08:19:29 UTC
Insert a formula object in a Writer document. The object displays all of eight small green boxes, that I assume are supposed to be resizing/rotating/etc handles. However, none of them are actually usable for anything. Hovering the mouse pointer over each just displays a "forbidden" sign. This is hardly useful.
Comment 1 raal 2016-05-12 11:17:49 UTC
 dd39926faa8280059bfa6645369260406f0c4847 is the first bad commit
commit dd39926faa8280059bfa6645369260406f0c4847
Author: Norbert Thiebaud <nthiebaud@gmail.com>
Date:   Sun May 3 21:23:59 2015 -0500

    source 51221bbf0c7cca0a329393dac2059818006ab338
author	Caolán McNamara <caolanm@redhat.com>	2014-11-26 15:42:46 (GMT)
committer	Caolán McNamara <caolanm@redhat.com>	2014-11-26 15:43:16 (GMT)
commit 51221bbf0c7cca0a329393dac2059818006ab338 (patch)
tree f43edb6f152c8c5bb1b5b260e5595e394289f874
parent 7716d86f46dea72bd0e99f7074f718d558e88f49 (diff)
Resolves: fdo#75408 go back to the old way of doing things
Comment 2 V Stuart Foote 2016-05-12 13:35:26 UTC
Actually, if you open the OLE object into the formula editor (i.e. double click), the object can not be resized directly there either. 

The formula can only be adjusted using Formula Editor menu Format -> Spacing dialog. Use the Category dropdown and select the Borders attribute.

Suspect the resizing/cropping widgets added that work on other OLE objects (and show up as the green handles/red handles) simply have no linkage to the ODF formula objects.
Comment 3 V Stuart Foote 2016-05-12 15:15:31 UTC
For now in Writer the green handles of Formula OLE objects only allow movement of the object. Also in Writer, the Object dialog's "Type" tab only shows Size settings and they are not editable for formulas.

Adjustments to font size and borders of the these Formula objects must be done in the Math Formula editor Format -> Font Size and Format -> Spacing dialogs.

Some history in these issues:

Bug 48846 [1]- FORMATTING Writer: Formula resizing not working
Bug 75408 [2]- Formula in writer is shrinked instead of keeping same size when changing border space in writer style

the first added global resizing for formulas, the second reverted it due to issues of adding border spacing reducing size of the object.  Resulting in an enhancement for all OLE objects to handle size of frame/object border spacing differently.

Bug 85860 - OLE object frame properties and styles: border lines and spacing should optionally increase frame size rather than reduce content to fit

Also, in Draw/Impress the OLE Formula object *can* be resized from the "Position and Size" dialog by unprotecting the size, checking "Keep ratio", and setting the size spinner boxes. But not so in Writer nor in Math as the dialog is not implemented.

[1] https://cgit.freedesktop.org/libreoffice/core/commit/?id=1b717e5686f34c3ce798310a6216f7ea98fb2cd9

[2] https://cgit.freedesktop.org/libreoffice/core/commit/?id=51221bbf0c7cca0a329393dac2059818006ab338
Comment 4 Regina Henschel 2016-05-12 17:21:42 UTC
It is a controversial subject, and I think, the desired behavior should be discussed on the mailing list, not here in the bugtracker. One of the controversial topic is, whether and how a change in the display should affect internals of the object.

In case of Writer one UI-error is, that in Writer the "Size" checkbox in the "Protect" section in the "Options"-tab of the property dialog shows a wrong state. If the size state is not changeable at all, this property should show state "checked" and be shown as "disabled". On the "Type" tab it is correct.

From a file format view on the problem all transformations are allowed. You can always set a draw:transform attribute on the draw:frame element, which contains the draw:object. And svg:width and svg:height are allowed too. I have not found, that they may be ignored for a text document. Currently you have the problem, that e.g. a svg:width is correctly read on loading, but there is no way in the UI of Writer to change this value other than setting it back to original object size by editing the formula.
Comment 5 Caolán McNamara 2016-07-09 20:34:29 UTC
I'm going to argue that this is not a regression and clear those keywords as the current behaviour is the "traditional" one. And the efforts to change that showed up loads of problems so its now back to the old way of doing things.
Comment 6 V Stuart Foote 2016-10-01 02:43:12 UTC
*** Bug 102903 has been marked as a duplicate of this bug. ***
Comment 7 QA Administrators 2017-10-30 08:29:05 UTC Comment hidden (obsolete)
Comment 8 raal 2018-05-01 06:18:42 UTC
*** Bug 117359 has been marked as a duplicate of this bug. ***
Comment 9 Buovjaga 2018-06-03 19:28:51 UTC
Today I learned the proper way to resize a formula (its font size) is to use the size attribute in the formula editor like so:

size 20 { your formula goes here }
Comment 10 QA Administrators 2019-06-04 02:50:16 UTC Comment hidden (obsolete)
Comment 11 V Stuart Foote 2019-10-04 14:15:56 UTC
(In reply to QA Administrators from comment #10)
Remains an issue. Attempting to resize the OLE with the grips has no function.

But for sm formula OLE, as noted comment 9 wrapping the formula in Size ## {} will correctly resize the OLE object on document canvas with changes to the size entered-- default 12pt would resize to 15 point:

size 15 { a^2 + b^2 = c^2 }

And the object can be repositioned on canvas.  So, is enhancement needed to directly manipulate the sm OLE with the grips? Maybe not and this is => WF
Comment 12 V Stuart Foote 2019-10-04 15:18:25 UTC
*** Bug 127948 has been marked as a duplicate of this bug. ***
Comment 13 V Stuart Foote 2020-03-02 15:37:21 UTC
*** Bug 131074 has been marked as a duplicate of this bug. ***
Comment 14 QA Administrators 2022-03-03 03:40:28 UTC Comment hidden (obsolete)
Comment 15 V Stuart Foote 2022-12-05 15:04:13 UTC
*** Bug 152377 has been marked as a duplicate of this bug. ***
Comment 16 V Stuart Foote 2022-12-05 15:05:32 UTC
*** Bug 58757 has been marked as a duplicate of this bug. ***
Comment 17 V Stuart Foote 2022-12-05 15:05:42 UTC
*** Bug 58731 has been marked as a duplicate of this bug. ***
Comment 18 V Stuart Foote 2022-12-05 15:10:38 UTC
*** Bug 90947 has been marked as a duplicate of this bug. ***
Comment 19 V Stuart Foote 2022-12-05 15:16:27 UTC
*** Bug 119946 has been marked as a duplicate of this bug. ***
Comment 20 Stéphane Guillou (stragu) 2022-12-08 13:16:32 UTC
Repro in master build from today:

Version: (X86_64) / LibreOffice Community
Build ID: ad085990b8073a122ac5222e5220f8f1d6826dcf
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

Pointer changes to double-arrows when hovering over the handles.

Inherited, because also in:

OpenOffice.org 3.3.0