[sc-issues] [Issue 96721] Lack of screen refresh wit h INDIRECT in conditional formatting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96721 User regina changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from reg...@openoffice.org Fri Jan 1 19:08:07 + 2010 --- closing duplicate - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 96721] Lack of screen refresh wit h INDIRECT in conditional formatting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96721 User regina changed the following: What|Old value |New value CC|''|'regina' Status|UNCONFIRMED |RESOLVED Keywords| |oooqa Resolution| |DUPLICATE --- Additional comments from reg...@openoffice.org Fri Jan 1 19:07:36 + 2010 --- Other functions are affected too. I close this one as duplicate, because issue 108013 has got documents to show the effect. *** This issue has been marked as a duplicate of 108013 *** - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 96721] Lack of screen refresh wit h INDIRECT in conditional formatting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96721 --- Additional comments from squen...@openoffice.org Sat Jun 20 16:34:36 + 2009 --- Additional tests: OS: Windows XP, SP3 OOo: 3.1.0. (build:9399) Graphic card: nVidia GeForce 8600 GT Result: No screen refresh in step 6, partial screen refresh (D6:D25) in step 11 OS: Windows XP, SP3 OOo: 3.1.0. (build:9399) graphic card: Radeon IGP 320 M Result: No screen refresh in step 6, partial screen refresh (D6:D25) in step 11 OS: Ubuntu 9.04 OOo: 3.1.0. (build:9399) graphic card: Radeon IGP 320 M Result: No screen refresh in step 6, partial screen refresh (D6:D25) in step 11 OS: Ubuntu 9.04 as a Virtual Machine OOo: 3.1.0. (build:9399) Graphic card: nVidia GeForce 8600 GT Result: No screen refresh in step 6, partial screen refresh (D6:D25) in step 11 So, all my tests confirm that the problem occurs independently of the OS and graphic card. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 96721] Lack of screen refresh wit h INDIRECT in conditional formatting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96721 User squenson changed the following: What|Old value |New value Version|1.0.0 |OOO300m9 - 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]
[sc-issues] [Issue 96721] Lack of screen refresh wit h INDIRECT in conditional formatting
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 + 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]