[Libreoffice-bugs] [Bug 132887] Conditional Formatting equal works wrong
https://bugs.documentfoundation.org/show_bug.cgi?id=132887 m.a.riosv changed: What|Removed |Added Resolution|FIXED |NOTABUG --- Comment #9 from m.a.riosv --- Not fixed it was not a bug. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132887] Conditional Formatting equal works wrong
https://bugs.documentfoundation.org/show_bug.cgi?id=132887 Alfredo changed: What|Removed |Added Resolution|--- |FIXED Status|NEEDINFO|RESOLVED --- Comment #8 from Alfredo --- yes, you're right. with "x" it works correct -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132887] Conditional Formatting equal works wrong
https://bugs.documentfoundation.org/show_bug.cgi?id=132887 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #7 from m.a.riosv --- Created attachment 160644 --> https://bugs.documentfoundation.org/attachment.cgi?id=160644=edit 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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132887] Conditional Formatting equal works wrong
https://bugs.documentfoundation.org/show_bug.cgi?id=132887 --- Comment #6 from Alfredo --- 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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132887] Conditional Formatting equal works wrong
https://bugs.documentfoundation.org/show_bug.cgi?id=132887 --- Comment #5 from Ming Hua --- Created attachment 160627 --> https://bugs.documentfoundation.org/attachment.cgi?id=160627=edit 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132887] Conditional Formatting equal works wrong
https://bugs.documentfoundation.org/show_bug.cgi?id=132887 --- Comment #4 from Alfredo --- 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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132887] Conditional Formatting equal works wrong
https://bugs.documentfoundation.org/show_bug.cgi?id=132887 Ming Hua changed: What|Removed |Added CC||ming.v@qq.com --- Comment #3 from Ming Hua --- Created attachment 160602 --> https://bugs.documentfoundation.org/attachment.cgi?id=160602=edit 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132887] Conditional Formatting equal works wrong
https://bugs.documentfoundation.org/show_bug.cgi?id=132887 --- Comment #2 from Alfredo --- 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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132887] Conditional Formatting equal works wrong
https://bugs.documentfoundation.org/show_bug.cgi?id=132887 Oliver Brinzing changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO CC||oliver.brinz...@gmx.de --- Comment #1 from Oliver Brinzing --- 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs