Description: When I copy a sheet which contains conditional formatting, it seems to be working fine but the conditional formatting is broken on the new sheet. (see attachment) I have found a workaround while browsing issues regarding conditional formatting by copying using the "paste special" directly on the cells after copying the sheet. However, this workaround may be time-consuming if, like in my case, one has to perform this operation multiple times. Additionally, there is also a strange orange color which is automatically added on the nonworking cells. Steps to Reproduce: 1. create a worksheet 2. apply a conditional formating (in my case, it was a custom style with a different background, conditionned on a LOV defined in another sheet) 3. copy the worksheet Actual Results: Conditional formatting broken in the new sheet. Expected Results: Copy the format with the sheet copy. Reproducible: Always User Profile Reset: No Additional Info: I also use a cell range for the broken cells. Both the definition of the cell range, and the conditional formatting are based on a configuration sheet _Status_LOV.
Created attachment 151104 [details] Broken file
Comment on attachment 151104 [details] Broken file The broken file after having copied the tab "Sc_base" to "Sc_base_2"
Created attachment 151105 [details] Workaround file File after workaround with "paste special"
Created attachment 151106 [details] Original file Original file, before the tab copy
Florent, how do you copy a sheet? Say about it more detail
@Roman, I right click on the origin sheet tab, select "move or copy sheet" and select the "copy" radio button.
[Automated Action] NeedInfo-To-Unconfirmed
Thank you for reporting the bug. To be certain the reported issue is not related to corruption in the user profile, could you please reset your Libreoffice profile ( https://wiki.documentfoundation.org/UserProfile ) and re-test? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the issue is still present
(In reply to Xisco Faulí from comment #8) > Thank you for reporting the bug. To be certain the reported issue is not > related to corruption in the user profile, could you please reset your > Libreoffice profile ( https://wiki.documentfoundation.org/UserProfile ) and > re-test? > > I have set the bug's status to 'NEEDINFO'. Please change it back to > 'UNCONFIRMED' if the issue is still present I've restarted in safe mode and the problem still occurs. Just to be sure, I also have renamed my user profile folder in appdata and it also occurs.
Repro. Link to target "equal to" is wrong for all condition. It was (for Condition 1) $_Status_LOV.$A$3 and it became for copied sheet - $Sc_base.$A$3. There is an absolutely addressing but it doesn't work when we copy sheet with CF now Version: 6.3.0.0.alpha0+ (x64) Build ID: 4cd4063f9cf531d1e948f27fcfd2eaed3d4a1a2d CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; TinderBox: Win-x86_64@42, Branch:master, Time: 2019-05-08_23:08:36 Locale: ru-RU (ru_RU); UI-Language: en-US Calc: threaded
don't repro in 4.2.8 but repro in 4.4.7 ->regression
I can't reproduce. Florent, Roman: can you please re-test? Arch Linux 64-bit Version: 7.1.0.0.alpha0+ Build ID: 2bccbd2ba6c90d5e02285629c2b079c35260c08b CPU threads: 8; OS: Linux 5.6; UI render: default; VCL: kf5 Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 3 June 2020
(In reply to Buovjaga from comment #12) > I can't reproduce. Florent, Roman: can you please re-test? > > Arch Linux 64-bit > Version: 7.1.0.0.alpha0+ > Build ID: 2bccbd2ba6c90d5e02285629c2b079c35260c08b > CPU threads: 8; OS: Linux 5.6; UI render: default; VCL: kf5 > Locale: fi-FI (fi_FI.UTF-8); UI: en-US > Calc: threaded > Built on 3 June 2020 not repro in Version: 7.1.0.0.alpha0+ (x64) Build ID: 651844c9b122fd8463ad1dde4f9a0200efc345a3 Потоков ЦП: 4; ОС: Windows 10.0 Build 18363; Отрисовка ИП: Skia/Vulkan; VCL: win Locale: ru-RU (ru_RU); ИП: ru-RU Calc: threaded So let's close it as WFM