Bug 147561 - reOpen calc anchor will reset as "to page",before is "to cell"
Summary: reOpen calc anchor will reset as "to page",before is "to cell"
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.0.4 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, regression
Depends on:
Blocks: Anchor-and-Text-Wrap
  Show dependency treegraph
 
Reported: 2022-02-21 07:16 UTC by qidizi
Modified: 2023-04-24 13:00 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
sometime will reset (5.15 MB, video/mp4)
2022-02-21 07:25 UTC, qidizi
Details
Do as you describe, the problem still persists (16.59 MB, video/mp4)
2022-02-23 00:11 UTC, qidizi
Details

Note You need to log in before you can comment on or make changes to this bug.
Description qidizi 2022-02-21 07:16:24 UTC
Description:
design mode -> select button -> property -> general -> anchor -> "to cell" ->save ->quit libreoffice ->reopen -> the button anchor  reset as "to page"

Actual Results:
anchor reset as "to page"

Expected Results:
keep "to cell"


Reproducible: Always


User Profile Reset: Yes



Additional Info:
happen : mac 7.2.5 and 7.3.0 / win 7.3.0
Comment 1 qidizi 2022-02-21 07:25:21 UTC
Created attachment 178421 [details]
sometime will reset
Comment 2 m_a_riosv 2022-02-22 21:59:52 UTC
I think you need to leave the control before saving.
Comment 3 qidizi 2022-02-23 00:11:13 UTC
Created attachment 178465 [details]
Do as you describe, the problem still persists
Comment 4 QA Administrators 2022-02-23 03:46:16 UTC Comment hidden (obsolete)
Comment 5 Kevin Suo 2022-03-01 14:49:44 UTC
I do not reproduce with
Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: 6961f6732954742415413fa53bdeebd1b03d9ec5
CPU threads: 8; OS: Linux 5.16; UI render: default; VCL: gtk3
Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN
Build Platform: Fedora34@X64, Branch:master, bibisect-linux-64-7.4-CN
Calc: threaded

Fedora 34.
Comment 6 raal 2022-07-30 16:24:24 UTC
Confirm with Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: fe2d59a0730e60c0196baa46af12440afd343878
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded

works in Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Comment 7 raal 2022-07-30 16:42:45 UTC
Tried to bibisect with bibisect-41max, but found bad commit. Should be bibisectable with bibisect-41max, I'll try later.
Comment 8 raal 2022-08-03 14:30:33 UTC
 d34912b1eb89f5b0fde219ea57902f3a7d05cb7a is the first bad commit
commit d34912b1eb89f5b0fde219ea57902f3a7d05cb7a
Author: Matthew Francis <mjay.francis@gmail.com>
Date:   Fri Sep 18 10:34:06 2015 +0800

    source-hash-2b1aa949539d2fcbb3d349be3c279996630d83fc
    
    Bibisect: This commit covers the following source commit(s) which failed to build
    43682489c18c707bc0d5701f7f6a2df2511eeb0c
    88ed6d1348b5d3d517afcbe5fa1257d55625f39b
    fe8bcfa422c654e35ec22b5e3b1a512ae438b565
    5de206a7fbe74a7022bb3b20f190e6a3e6f1e3ae
    fb455e5013ab014058ad5f92238ef6fc91b2afcf
    a4c80756ca429ac3654455b5e6a6b6a700361b9a
    3a3254a900a6a8aad8d3321bf8b10d1770555cf5
    cac113602c8f60b7eaea8709f6670b00b0925447
    f8a75e4b225d3a998174f47066b9a72472546767
    1dace0c3e0972c2bde8db177433b7d095025bcca
    742515639168cd35a0c2036a5bf6c46b2a3a554e
    e70defefd80c44646a742ff581bca9b467b8e713
    396eb4f5cf8b37cd2a9f14d85764e03761ade19f
    f37df270f1a984f0a6138f4f22fc79a50e71dcc2
    349e9248f801d23735478abafe5328f79dfe4378
    bf46dfdb45b1d6cd99a5c729ee98df89db363225
    b8da61acb2bb887a7335a5db82b8b5ae1e0fab69
    a062799bd6902061895e19cace0099fadf696bb4
    95e6a0885e65cc57b11719cc0658be9d8b78fba9
    138e5a051805ca8a3b7e9626742cc475e3577cc4
    826cb27cc80ae843927d68e0337ad2caffa9f023
    bee8ed6772f420f9eefc57fee01da29ff466a8e9
    3998d1abb291309ddbbc2c9869736ebb1ea608f0
    a09f11715be53587ee2b0368e19f45cc85fb6cf1
    ef1d096ddc311a2fd821d4076421c4a8f8d63abf
    55dda63b297a287c9abc6ba2f19946817e8744e7
    5bdd1e9ee8f3ca9dc647998a8ec7b9415add01fe
    0db079cd5a09b3f24b0dd3563f100c77561ccfde
    eea3634b2bd85e7f290e0504da1b8906c7d33ca4
    49db90342f193f31500b2717cc27bdf2f25e2d95
    bcaa4cd4f3be07f9211b51da4d258b61423f1e28
    9e7f056bd08b18d084497b0846c7c8f31b82f58a
    f49b4581a0a5056a51712bcabcc66483a87a07c8
    0d05957cf0c38abab45030ba172025e4ef318f43
Comment 9 Julien Nabet 2022-09-10 19:35:48 UTC
On pc Debian x86-64 with master sources updated today (+gtk3), I could reproduce this.
I noticed I could reproduce this if I use:
- right click
- Control properties...

BUT weirdly I don't reproduce this if I use:
- right click
- Anchor then To cell
Comment 10 Julien Nabet 2022-09-10 19:39:34 UTC
(In reply to Julien Nabet from comment #9)

BTW, with right click there's a third option for anchor that we don't see in Control Properties "To Cell (resize with cell)"
Comment 11 Julien Nabet 2022-09-10 20:03:36 UTC
By using keyId, I found that there really 2 ways:
1) right click use:
..CalcCommands.UserInterface.Commands..uno:SetAnchorToCell
..CalcCommands.UserInterface.Commands..uno:SetAnchorToCellResize
..CalcCommands.UserInterface.Commands..uno:SetAnchorToPage

2) control properties use:
extensions/inc/stringarrays.hrc:252:
NC_("RID_RSC_ENUM_SHEET_ANCHOR_TYPE", "To Page"),

extensions/inc/stringarrays.hrc:253:
NC_("RID_RSC_ENUM_SHEET_ANCHOR_TYPE", "To Cell")

git grep -n PROPERTY_ID_TEXT_ANCHOR_TYPE
extensions/source/propctrlr/formgeometryhandler.cxx:361:            case PROPERTY_ID_TEXT_ANCHOR_TYPE:
extensions/source/propctrlr/formgeometryhandler.cxx:427:            case PROPERTY_ID_TEXT_ANCHOR_TYPE:
extensions/source/propctrlr/formgeometryhandler.cxx:481:            case PROPERTY_ID_TEXT_ANCHOR_TYPE:
extensions/source/propctrlr/formgeometryhandler.cxx:534:        case PROPERTY_ID_TEXT_ANCHOR_TYPE:
extensions/source/propctrlr/formmetadata.cxx:532:            case PROPERTY_ID_TEXT_ANCHOR_TYPE:
extensions/source/propctrlr/formmetadata.hxx:320:    #define PROPERTY_ID_TEXT_ANCHOR_TYPE            201

Eike: any thoughts here? Do we talk of the same anchor type in both cases, should one of them (I think about extensions one) should be replaced by the other?
Comment 12 Regina Henschel 2023-04-24 13:00:28 UTC
The error seems to be, that the choice made in the control properties is not written to file.

As the anchor can be set outside the control properties, I suggest to remove the field in the control properties.

[A shape anchored to "page" appears in element <table:shapes> in the file.
A shape anchored to "cell" or to "cell (resize with cell)" appears in element <table:table-cell>. Shapes with "resize with cell" have an additional attribute table:end-cell-address.]