https://bugs.freedesktop.org/show_bug.cgi?id=61137
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW --- Comment #2 from [email protected] --- <grump> Sorry, I presumed it was obvious as to what "select cells U4 .. U12" means, especially as it doesn't matter how they're selected; the entire conditional formatting system is badly broken and pretty much anything you do will fail to do anything reasonable. Nothing here depends on display appearance nor exactly what steps you take -- hardly anything works as anyone would expect, as the formatting isn't applied to selections, isn't copied (bug 61101), and can't be duplicated (bug 61136). As a programmer, I've gotten lots of vague bug reports and mine aren't remotely in that category.</grump> Anyway, let's try again: (1) Open the sample spreadsheet. (2) Use the mouse to select cells U4 through U12. (3) Open the Conditional Formatting Dialog from the menu ("Format"/"Conditional Formatting"/"Conditional Formatting..." (a) Just select OK. Nothing at all happens in this case. Version 3.5 applied the conditional formatting to all of the cells in the selected range (which is what I think should happen - otherwise, the selected cells effectively are ignored). (b) OK, I think, perhaps I have to change something to get it to work. Reopen the Conditional Formatting Dialog with the same range selected. Change the high value in the range of the first item from 780 to 790. Select OK. In this case, only the conditional formatting in cell U4 is changed; the formatting in cell U11 (which started identical) is *not* changed. And again, the cells without any conditional formatting don't get any. (This can be verified with the "Manage" box under "Conditional Formatting"). (c) So I tried removing the formatting. Open the Conditional Formatting Dialog again (again with the same range selected). Use the Remove button to remove both conditional formatting items. Again, this only changes cell U4, the formatting in cell U11 (which was part of the selection) remains unchanged. In all three of these cases, 3.5 modified the entire selected range of cells to have the conditional formatting as specified in the Conditional Formatting Dialog. Hope this is enough to understand the problem. Please forgot screenshots and the like - the entire feature is simply not being applied to cells that it should be, and that is clearly visible in the "Conditional Formatting", "Manage" box as the selected range (U4..U12) never appears there. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
