Description: changes parameters of conditional formatting "Formula is" if copy range from Calc and paste it to Writer as OLE changes link to cell into field with formula Steps to Reproduce: 1. create conditional formatting for range A3:E11 with Condition 1: Formula is - $E3="нет" 2. select range A2:E7 and copy it 3. open Writer document 4. paste (just use icon Paste or Ctrl+V) range in to document (it will be paste as OLE) -> color in range applies don't right 5. double click on pasted OLE object -> enter to edit mode 6. check condition -> it has become Condition 1: Formula is - $E5="нет" (there was 3 in Calc) Actual Results: changes parameters of conditional formatting "Formula is" if copy range from Calc and paste it to Writer as OLE Expected Results: parameters of conditional formatting "Formula is" if copy range from Calc and paste it to Writer as OLE remain unchanged Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36
Created attachment 142405 [details] Example of CF with formula (Calc)
Created attachment 142406 [details] example of result (Writer)
(In reply to kompilainenn from comment #0) > 6. check condition -> it has become Condition 1: Formula is - $E5="нет" > (there was 3 in Calc) For me, editing the condition shows only the default (empty) Arch Linux 64-bit Version: 6.2.0.0.alpha0+ Build ID: 0929a98acca8ec4d86caa97d3090a39f89f35f90 CPU threads: 8; OS: Linux 4.17; UI render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group threaded Built on June 20th 2018
Dear kompilainenn, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
still repro in Version: 6.4.0.0.alpha0+ (x64) Build ID: c0d1bdbb8a9aca2ef2e475268a953da995567700 CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; TinderBox: Win-x86_64@42, Branch:master, Time: 2019-06-22_23:10:51 Locale: ru-RU (ru_RU); UI-Language: en-US Calc: threaded
it repro in 5.3.7 but not in 5.2.7 -> regression
I bisected it $ git bisect bad 3734574fb33840ef0d831c9b2d467fba4edaab2f is the first bad commit commit 3734574fb33840ef0d831c9b2d467fba4edaab2f Author: Norbert Thiebaud <nthiebaud@gmail.com> Date: Thu Mar 16 16:20:50 2017 -0700 source ea8a1bda453ed63d9b26b01f29b0701828dde77c https://cgit.freedesktop.org/libreoffice/core/commit/?id=ea8a1bda453ed63d9b26b01f29b0701828dde77c Added: to CC Caolan McNamara Caolan, can you look at this?
I suspect you bisected to a band of commits and picked my one off the top of the band, my bisect shows its between 4f786274be8f9b01b34ad0772bcf718d5259bdc0..1bffa5e110772a7d6183ac64e56c23f2c3019f93 which includes a batch of calc conditional formatting commits which would seem more likely related to this
the problem began with commit... commit 3f0f35c89f3f64fcb110483fd562a59f729dc344 Date: Thu Mar 16 20:08:30 2017 +0100 the range should be updated after the references, tdf#104026 Change-Id: I2cb674b8b3bc64df031b473b337d266a2eaab43d Reviewed-on: https://gerrit.libreoffice.org/35289 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
Investigating.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/50cd4c73eba1ae2802a4897410bd3f75516d0dcb%5E%21 Resolves: tdf#117899 update condition entries' source position on inter-copy It will be available in 6.4.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.
Pending https://gerrit.libreoffice.org/74764 for 6-3 https://gerrit.libreoffice.org/74766 for 6-2
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/+/7b0f65cbfa3ef0b3cb698247429f445574ba3a64%5E%21 Resolves: tdf#117899 update condition entries' source position on inter-copy It will be available in 6.3.0.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.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-2": https://git.libreoffice.org/core/+/364effd7143c31a6c0c49d08c81a08293a94667d%5E%21 Resolves: tdf#117899 update condition entries' source position on inter-copy It will be available in 6.2.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.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/79797620e4010453fc6ef0da73d9dc154ee3e015 tdf#117899: sc: Add UItest It will be available in 7.2.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.