Download it now!
Bug 98252 - [UI] Conditional Formatting - allow change sheets immediatelly after openning dialog
Summary: [UI] Conditional Formatting - allow change sheets immediatelly after openning...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: lowest enhancement
Assignee: Not Assigned
Depends on:
Blocks: Conditional-Formatting-Editing
  Show dependency treegraph
Reported: 2016-02-28 15:38 UTC by dave
Modified: 2018-03-08 22:10 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

conditional formatting dialog (34.02 KB, image/png)
2016-03-06 09:46 UTC, raal
conditional formatting dialog - focus in the text field (75.24 KB, image/png)
2016-03-06 15:20 UTC, raal

Note You need to log in before you can comment on or make changes to this bug.
Description dave 2016-02-28 15:38:21 UTC
User-Agent:       Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:44.0) Gecko/20100101 Firefox/44.0
Build Identifier: LibreOffice

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.
Comment 1 raal 2016-03-06 09:46:44 UTC
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?
Comment 2 dave 2016-03-06 14:47:12 UTC
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.
Comment 3 raal 2016-03-06 15:20:40 UTC
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.
Comment 4 raal 2016-03-06 15:23:36 UTC
Setting to new, allow change sheets immediatelly after openning dialog.
Comment 5 dave 2016-03-06 17:31:19 UTC
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.