To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96721 Issue #|96721 Summary|Lack of screen refresh with INDIRECT in conditional fo |rmatting Component|Spreadsheet Version|1.0.0 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|squenson
------- Additional comments from [EMAIL PROTECTED] Sun Nov 30 09:45:09 +0000 2008 ------- I have a strange behavior of my screen refresh when I use the function INDIRECT in conditional formatting. Several different users confirmed the lack of refresh on different machines (http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=12660) Scenario 1. Open a blank Calc document 2. Select cell A1 and name it "Rank" (either click on the combo box in the formula bar or use the menu Insert > Name > Define) 3. Write the number 1 in cell A1, the text "Rank" (without quotes) in A2 and the formula =INDIRECT(A2) in cell A3. Cell A3 returns the content of cell A1, which is a normal behavior. 4. In the range D6:D31, fill the cells with random digits, in any order. It is not important to have all the digits as long as most of them are present. 5. Select the range D6:D31 and click on the menu Format > Conditional Formatting. Enter the first condition as: "Cell value is" "greater than" "=INDIRECT($A$2)" cell style "Heading1", then click OK. You should notice that the numbers in the range D6:D31 are changing format, which is the expected behavior. 6. Click on cell A1 and change its content to 7. On my machine, the screen is NOT properly refreshed and the numbers below 7 are not formatted back to the default style. 7. Scroll to the right until column D disappears from the screen, then scroll back left to show column D. The cells D6:D31 are now displayed with the proper style. 8. Repeat steps 6 and 7 with different numbers and different ways to refresh the screen (minimize-maximize, move another application window above column D. 9. Copy the range D15:D25 to E15:E25 10. Select the range E15:E25 and click on the menu Format > Conditional Formatting. Edit the first condition as: "Cell value is" "greater than" "=$A$1" cell style "Heading1" (only the formula has changed) 11. Repeat step 6. Now, the screen is properly refreshed for the cells D15:D25, but not for the other rows! OS: Windows XP, SP3 OOo: 3.0.0. (build m9) Graphic card: nVidia GeForce 8600 GT Result: No screen refresh in step 6, partial screen refresh in step 11 OS: Windows XP, SP3 OOo: 3.0.0. (build m9) graphic card: Radeon IGP 320 M Result: No screen refresh in step 6, partial screen refresh in step 11 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
