Panel "Manage Conditional Formatting" Now Calc decided to automatically join ranges with the same formulas. Please don't do that, because if I'll later decide to alter the formula of only one of them, I'll have to manually split them. It's just cumbersome for no real advantage. Simplified example: A1:A100 Cell=0 B2:C300 Cell=0 E6:E200 Cell=0 Z9:Z900 Cell=0 becomes A1:A100;B2:C300;E6:E200;Z9:Z900 Cell=0
Hello Paul, Thank you for reporting the bug. Unfortunately without clear steps to reproduce it, we cannot track down the origin of the problem. Please provide a clearer set of step-by-step instructions on how to reproduce the problem. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the steps are provided
Created attachment 204148 [details] Example file Paul: please see the spreadsheet I created. I don't see any problem. We indeed need clear steps. Arch Linux 64-bit Version: 25.8.3.2 (X86_64) / LibreOffice Community Build ID: 580(Build:2) CPU threads: 8; OS: Linux 6.17; UI render: default; VCL: kf6 (cairo+wayland) Locale: fi-FI (fi_FI.UTF-8); UI: en-US 25.8.3-1 Calc: CL threaded
I wonder, if bug 87274 is relevant?
(In reply to Buovjaga from comment #2) > Created attachment 204148 [details] > Example file > > Paul: please see the spreadsheet I created. I don't see any problem. We > indeed need clear steps. > > Arch Linux 64-bit > Version: 25.8.3.2 (X86_64) / LibreOffice Community > Build ID: 580(Build:2) > CPU threads: 8; OS: Linux 6.17; UI render: default; VCL: kf6 (cairo+wayland) > Locale: fi-FI (fi_FI.UTF-8); UI: en-US > 25.8.3-1 > Calc: CL threaded On your spreadsheet i see all the ranges joined together A1:A100;B2:C300;E6:E200;Z9:Z900 for Cell value = 0 You see them separated instead?
(In reply to Buovjaga from comment #3) > I wonder, if bug 87274 is relevant? So the joining solution feels like a workaround for the problem I reported also here: https://bugs.documentfoundation.org/show_bug.cgi?id=169201 IMO they shouldn't be joined and they shouldn't change when people copy cells. Existing CF should take the precedence. Maybe allow to copy CF only with special copy-paste option?
(In reply to Paul from comment #4) > (In reply to Buovjaga from comment #2) > > Created attachment 204148 [details] > > Example file > > > > Paul: please see the spreadsheet I created. I don't see any problem. We > > indeed need clear steps. > > > > Arch Linux 64-bit > > Version: 25.8.3.2 (X86_64) / LibreOffice Community > > Build ID: 580(Build:2) > > CPU threads: 8; OS: Linux 6.17; UI render: default; VCL: kf6 (cairo+wayland) > > Locale: fi-FI (fi_FI.UTF-8); UI: en-US > > 25.8.3-1 > > Calc: CL threaded > > On your spreadsheet i see all the ranges joined together > A1:A100;B2:C300;E6:E200;Z9:Z900 for Cell value = 0 > > You see them separated instead? Ah, sorry, they indeed become joined after saving and reloading. I think I'll ask developers about this tomorrow.
(In reply to Buovjaga from comment #6) > (In reply to Paul from comment #4) > > (In reply to Buovjaga from comment #2) > > > Created attachment 204148 [details] > > > Example file > > > > > > Paul: please see the spreadsheet I created. I don't see any problem. We > > > indeed need clear steps. > > > > > > Arch Linux 64-bit > > > Version: 25.8.3.2 (X86_64) / LibreOffice Community > > > Build ID: 580(Build:2) > > > CPU threads: 8; OS: Linux 6.17; UI render: default; VCL: kf6 (cairo+wayland) > > > Locale: fi-FI (fi_FI.UTF-8); UI: en-US > > > 25.8.3-1 > > > Calc: CL threaded > > > > On your spreadsheet i see all the ranges joined together > > A1:A100;B2:C300;E6:E200;Z9:Z900 for Cell value = 0 > > > > You see them separated instead? > > Ah, sorry, they indeed become joined after saving and reloading. I think > I'll ask developers about this tomorrow. Thank you. But please also check my second reply above