Created attachment 173962 [details] Example file from Calc Attached example file contains a few validated cells with invalid values circled. When a row or column is deleted from the sheet the validation circles move one column to the left and one row up. Steps to reproduce: 1. Open attached document 2. Delete row 1 or Column A Actual results: All validation circles move one column to the left and one row up. Expected results: Validation circles stay with their cells. LibreOffice details: Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: ac80ec817eb07c77a51bc0729985a473c734182e CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win Locale: en-US (hu_HU); UI: en-US Calc: CL Not yet in 7.0 Additional Information: Bibisected using bibisect-win64-7.1 to: URL: https://cgit.freedesktop.org/libreoffice/core/commit/?id=2383bb3dfe489309b1b57b95bfec56b4967610fb author Regina Henschel <rb.henschel@t-online.de> 2021-01-15 17:40:10 +0100 committer Xisco Fauli <xiscofauli@libreoffice.org> 2021-01-19 11:45:18 +0100 tdf#139583 fix case rot 180deg for cell anchored shapes (double verified with git checkout HEAD~1) Adding CC to: Regina Henschel
Created attachment 173963 [details] The file before any changes
Created attachment 173964 [details] Screenshot of the problem in Calc after deleting a column
Created attachment 173965 [details] Screenshot of the problem in Calc after deleting a row
The problem exists as described.
Same for insert row/col. Proposed patch is in https://gerrit.libreoffice.org/c/core/+/119715
Regina Henschel committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/0cff1aa48453ee0c05bafcac5360329fb6bf9557 tdf#143619 validation circle anchor is special It will be available in 7.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in: Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: ad1b12686da88bea57582df10fa85268ada209b8 CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: default; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: threaded
Regina Henschel committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/a1791f7e2503ca1d0868a0a607ff4717cd1fddeb tdf#143619 validation circle anchor is special It will be available in 7.2.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Regina Henschel committed a patch related to this issue. It has been pushed to "libreoffice-7-1": https://git.libreoffice.org/core/commit/ee749af6d3c742efdfc28d245db6422d461ed51b tdf#143619 validation circle anchor is special It will be available in 7.1.6. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.