Created attachment 98640 [details] Validation (using cell range) is corrupted with column insert/remove Cells with Cell range based validation are corrupted (absolutive cell range shifts) by either inserting or removing columns. If used validity cell range is $Sheet1.$J3:$N3 at D3, after removing column F, the validity range is still the same $Sheet1.$J3:$N3, thought valid values are shifted one column. Expected: Validity cell range is modified (if necessary), if columns(or rows) are inserted or removed. Version: Version: 4.2.3.3 Build ID: 420m0(Build:3) For reference: Gnumeric does modify validity cell ranges.
Hi Teraslilja, thanks for reporting. Reproducible with: Win7x64Ultimate Version: 4.2.3.3 Build ID: 882f8a0a489bc99a9e60c7905a60226254cb6ff0 Version: 4.2.5.0.0+ Build ID: bc74773e8c5d62f4fe932366f1fae5bebbd19f65 TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-05-07_03:55:27 Version: 4.3.0.0.alpha1+ Build ID: 081a0854635f4bc9f6f743ef4e2675c208405f74 TinderBox: Win-x86@39, Branch:master, Time: 2014-05-06_23:32:18 Last working: Version: 4.1.6.2 Build ID: 40ff705089295be5be0aae9b15123f687c05b0a
It's weird that when I try to create a test document from scratch it works fine. But I can reproduce it with the submitted test document. What's so special with this test document I wonder...
Doing some test, seems that is a similar problem as it happens with named ranges and absolute references. If the all address is not absolute it is not updated.
I got it. The row addresses in the validity settings are relative.
(In reply to comment #3) > Doing some test, seems that is a similar problem as it happens with named > ranges and absolute references. Yup. The code treats it as if it's a named range, which is the reason for this behavior. Let me think about this.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=49bf3a1f5f38cdf259101b15a19d546b32151463 fdo#78402: Write test for this. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a93bb27aa46c84410c8848a6118d5d63d47be92c fdo#78402: Adjust references of validity entries as appropriate. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
4.2 backport: https://gerrit.libreoffice.org/9345
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=0a47daf3175ec16d48669535a34823be47fbb42a&h=libreoffice-4-2 fdo#78402: Adjust references of validity entries as appropriate. It will be available in LibreOffice 4.2.5. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Thanks Kohei, verified: Win7x64 Version: 4.2.5.1 Build ID: 881bb88abfe2992c6cede97c23e64a9885de87de Version: 4.2.6.0.0+ Win-x86@42, Branch:libreoffice-4-2, Time: 2014-05-28_10:43:01 Version: 4.3.0.0.beta1 Build ID: 2e39c7e59c8fc8b16a54c3d981dceef27fb0c07f Version: 4.4.0.0.alpha0+ Win-x86@39, Branch:master, Time: 2014-05-26_01:36:09