Err:508
Posted: Sat Oct 24, 2009 3:51 am
I have OpenOffice 3.0.1 OOO300m15 (Build:9379) on Linux kubuntu 9.04. I got an error in Calc when I tried to enter a formula for changing the background color of a cell when it is non-zero. First, I created a style named "ORANGE" and then tried to enter this formula:
=(D4-E4)+(H4+(STYLE(IF(CURRENT()=0; "DEFAULT"; "ORANGE"))))
The error says at the bottom of the window "Error: in bracketing".
I tried editing the formula in a separate editor before I copy-pasted it into the cell. In the editor which automatically checks for paired parenthesis, the editor says that all pairs are matched. In the functions (organized by category) section of the documentation there are a couple of examples showing how to use an "IF" function as an argument to the "STYLE" function as I have done. Also, I have tried taking the "IF" function out and replacing it with simply "ORANGE" as the argument to the STYLE function and that gives me an orange background always with no error.
Has anyone else had a problem with this error? What can I do to change the cell to an orange background only when (D4-E4)+H4 is non-zero?
Thanks,
KHousley
=(D4-E4)+(H4+(STYLE(IF(CURRENT()=0; "DEFAULT"; "ORANGE"))))
The error says at the bottom of the window "Error: in bracketing".
I tried editing the formula in a separate editor before I copy-pasted it into the cell. In the editor which automatically checks for paired parenthesis, the editor says that all pairs are matched. In the functions (organized by category) section of the documentation there are a couple of examples showing how to use an "IF" function as an argument to the "STYLE" function as I have done. Also, I have tried taking the "IF" function out and replacing it with simply "ORANGE" as the argument to the STYLE function and that gives me an orange background always with no error.
Has anyone else had a problem with this error? What can I do to change the cell to an orange background only when (D4-E4)+H4 is non-zero?
Thanks,
KHousley