Bug 107698 - EDITING: vertical position of controls anchored to cell incorrectly updated when non-default height rows are inserted/deleted above
Summary: EDITING: vertical position of controls anchored to cell incorrectly updated w...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.1.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Images
  Show dependency treegraph
 
Reported: 2017-05-08 07:51 UTC by gisel.avaleazar
Modified: 2023-07-18 01:57 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
simple test document with 1 control (11.10 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-05-08 07:53 UTC, gisel.avaleazar
Details

Note You need to log in before you can comment on or make changes to this bug.
Description gisel.avaleazar 2017-05-08 07:51:56 UTC
Description:
In my spreadsheet I have buttons and images anchored to Cell. I also use rows of various heights.
When I insert rows or remove rows then the controls are not displayed correctly anymore at the right position relative to their anchored cell.

I've created a simple test spreadsheet d/l here: https://www.dropbox.com/s/u5zbrgb6u5vzt1m/33test.ods?dl=0

Inserting rows with the smaller 0.11 inch height creates a shift down
Inserting rows with default height keeps the control on the right spot.

Steps to Reproduce:
1. select row 8
2. l-shift click row 17 (so select rows 8 to 17)
3. right click (context menu): Insert Rows Above
4. repeat 3 for increased effect

Actual Results:  
the control has shifted relatively to it's anchor cell

Expected Results:
maintain the same relative position to it's anchor cell


Reproducible: Always

User Profile Reset: No

Additional Info:
office version: Version: 5.3.1.2 (x64)
Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2

testfile: https://www.dropbox.com/s/u5zbrgb6u5vzt1m/33test.ods?dl=0


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:53.0) Gecko/20100101 Firefox/53.0
Comment 1 gisel.avaleazar 2017-05-08 07:53:59 UTC
Created attachment 133156 [details]
simple test document with 1 control
Comment 2 m_a_riosv 2017-05-09 00:30:24 UTC
Reproducible.
Version: 5.3.3.2 (x64)
Build ID: 3d9a8b4b4e538a85e0782bd6c2d430bafe583448
CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Layout Engine: new; 
Locale: es-ES (es_ES); Calc: group
Comment 3 QA Administrators 2018-05-10 02:31:59 UTC Comment hidden (obsolete)
Comment 4 gisel.avaleazar 2018-05-15 10:47:31 UTC
This bug is still present in:

Version: 6.0.4.2 (x64)
Build ID: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: en-US (nl_NL); Calc:
Comment 5 gisel.avaleazar 2018-06-15 10:05:45 UTC
Still present in:

Version: 6.1.0.0.beta2+ (x64)
Build ID: 9bec4997fe6bceabf381e07793d2c8ba38ee19da
CPU threads: 4; OS: Windows 10.0; UI render: default; 
TinderBox: Win-x86_64@42, Branch:libreoffice-6-1, Time: 2018-06-15_04:56:29
Locale: nl-NL (nl_NL); Calc: group threaded
Comment 6 gisel.avaleazar 2018-06-27 09:29:14 UTC
Already present in:

Version: 4.4.7.2
Build ID: f3153a8b245191196a4b6b9abd1d0da16eead600
Locale: nl_NL
Comment 7 QA Administrators 2019-06-28 02:59:09 UTC Comment hidden (obsolete)
Comment 8 gisel.avaleazar 2019-07-02 07:59:23 UTC
Still present in:

Version: 6.2.4.2 (x64)
Build ID: 2412653d852ce75f65fbfa83fb7e7b669a126d64
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: en-US (nl_NL); UI-Language: en-US
Calc: threaded
Comment 9 gisel.avaleazar 2019-07-02 08:26:34 UTC
Still present in:

Version: 6.3.0.0.beta2 (x64)
Build ID: 6c6edded7133daf2d8d0b2ea7ae25b8109c5c064
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: nl-NL (nl_NL); UI-Language: en-US
Calc: threaded
Comment 10 gisel.avaleazar 2019-07-16 08:06:23 UTC
What changed in my current version:

Version: 6.2.4.2 (x64)
Build ID: 2412653d852ce75f65fbfa83fb7e7b669a126d64
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: en-US (nl_NL); UI-Language: en-US
Calc: threaded

is that after saving and reloading the document, the image in the test document (after test) is now exactly right again.

So I think that the new row height adapting parse at load time has something to do with it?
If you adapt the controls to row height right away after row insert (or something similar) then this bug would be resolved.
Comment 11 QA Administrators 2021-07-16 03:48:17 UTC Comment hidden (obsolete)
Comment 12 QA Administrators 2023-07-17 03:13:24 UTC Comment hidden (obsolete)
Comment 13 gisel.avaleazar 2023-07-17 22:19:15 UTC
Resolved in

Version: 7.5.4.2 (X86_64) / LibreOffice Community
Build ID: 36ccfdc35048b057fd9854c757a8b67ec53977b6
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (nl_NL); UI: en-US
Calc: threaded
Comment 14 m_a_riosv 2023-07-18 01:57:41 UTC
Fixed is marked when there is an explicit patch to resolve the issue.