User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:44.0) Gecko/20100101 Firefox/44.0 Build Identifier: LibreOffice 5.0.5.2 Conditional Formatting is still broken, and has been since 3.5.7. When bringing up the conditional format window, you cannot change to a different tab to select a cell. For years this has been a problem. Reproducible: Always Steps to Reproduce: 1.Select a cell 2.Click format, click conditional format, click condition. 3.Try to change to another sheet tab in the workbook Actual Results: You cannot go to another sheet tab in the workbook to select a cell Expected Results: Be able to go to another sheet tab in the workbook to select a cell [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Linux (All) OS is 64bit: yes Reset User Profile?No. This bug has been the exact same for years. The last time conditional formatting worked, like it does in all other spread sheet applications, was v3.5.7 Once again, due to this long standing bug, we are unable to use LibreOffice.
Created attachment 123339 [details] conditional formatting dialog Hello, I can click on another sheet and conditional format dialog accept it (see printscreen) - value $Sheet2.$B$14. I cannot select to another sheet "Cell range, Range:" - it's your problem?
I have a workbook open, and it consists of 3 sheets. I am on sheet 1. I want to conditional format cell A1. I open the conditional format dialog box, and I click on the tab to see sheet 2 or sheet 3, it does not allow viewing those sheets. With conditional format dialog box open, I can not view any other sheet.
Created attachment 123348 [details] conditional formatting dialog - focus in the text field Changing sheets works if you have focus in the text field, see prinscreen.
Setting to new, allow change sheets immediatelly after openning dialog.
So focus in the text field, and then click on a sheet tab, which takes focus out of text field. What's the point of the extra step of clicking in the conditional format text field? Will continue to use Microsoft Office in a Virtualbox, or the older LibreOffice v3.5.7, which worked as expected. I have nothing more to add to this report.