Description: Add a Conditional Formatting with Cell Value equals x does not work But changing the formatting to Cell Value Equals Not works as expected Steps to Reproduce: 1. Insert a Conditional Formatting with Cell Value equals x to change the Style 2. Insert x into the cell -> nothing happend 3. Change Conditional Formatting with Cell Value equals not x 4. Insert x into the cell -> style changes Actual Results: the style changes when the cell DOES NOT contain the correct value Expected Results: The style changes when a cell contains the correct value Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: na
Thank you for reporting the bug. Did you enclose "x" with quotation marks? If the problem persists, please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
I've created a template document at https://extensions.libreoffice.org/templates/urlaubsplaner-holiday-vacation-planning-tool/@@download/file/Urlaubsplaner.ots Yes, I used "x". I think the functions Equal and Not Equal are inverted The Equal works like Not Equal and vice versa
Created attachment 160602 [details] Example file from the link in comment 2 (In reply to Alfredo from comment #2) > I've created a template document at > > https://extensions.libreoffice.org/templates/urlaubsplaner-holiday-vacation- > planning-tool/@@download/file/Urlaubsplaner.ots It's easier to just upload the example file as an attachment to Bugzilla. So which conditional style do you think is giving wrong results? I tested with typing "u" (without quotes) in random cells in the J8:N18 range, and they all make the cell background yellow, which seems to be what the conditional style wants.
yes, this works, because I used the wrong rule to fix this issue. As you can see the rule is: Cell Value IS NOT EQUAL "u" -> this is wrong. The rule should be: Cell Value IS EQUAL "u" If you open the document in Excel you can see that there it doesn't work. The cell rage becomes yellow and when you enter "u" the cell get the standard style format
Created attachment 160627 [details] Screenshot of the "Urlaub" condition (In reply to Alfredo from comment #4) > yes, this works, because I used the wrong rule to fix this issue. > > As you can see the rule is: Cell Value IS NOT EQUAL "u" -> this is wrong. > The rule should be: Cell Value IS EQUAL "u" I have no idea what you mean. In your example, the rule shows up as [equal to "u"] on my system, see attached screenshot. > If you open the document in Excel you can see that there it doesn't work. > The cell rage becomes yellow and when you enter "u" the cell get the > standard style format I don't have Excel to test, will have to wait for another tester.
I think you can test it as well with this steps: 1. Open a new empty document 2. select a range of cells 3. create a conditional formatting with Equal To x 4. select a style e.g. "bad" After closing the dialog all the selected cells have "bad" style That is not correct. The style should change when you insert a x
Created attachment 160644 [details] Sample file (In reply to Alfredo from comment #6) >..... > The style should change when you insert a x Works fine for me, look at attached file. I think you are forgotten to put the text in the condition inside quotes "x" not x
yes, you're right. with "x" it works correct
Not fixed it was not a bug.