To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107106 Issue #|107106 Summary|ISERROR bug Component|Spreadsheet Version|OOo 3.1.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|fireheaven
------- Additional comments from [email protected] Sun Nov 22 03:56:32 +0000 2009 ------- I used 'conditional formatting' and 'styles and formatting' to hide any error messages on my spreadsheet. This is how I usually go about it. I'll assign a cell that has the same background and font color, label it 'hideme' as a new style, and then change the text back to default. I'll then give it a formula--often the formula will return an error (until the user inputs the correct cell references or some other issue present). These end up being DIV, or in the most recent case 'Err:508/509', or even 0. After, I'll select the cells I want to have the conditional formatting and assign "if the cell value is equal to 'iserror' give it the 'hideme' style. It works FLAWLESSLY until I save and leave the program. Starting back up, the font style seems to revert to black ONLY for the 'Err:508/509', but not for 0 (0's font changes and hides itself). Any attempts to redo conditional formatting doesn't fix the problem. changing styles doesn't fix the problem. Restarting the steps from the start does...but it ends up reverting when the program is closed. I'm a little at a loss...this didn't used to happen in the previous versions. Any help, being knowledge for a fix would be appreciated. --------------------------------------------------------------------- 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]
