I need to apply following formatting option to EXCEL Output. I have a numeric Column which when negative should be displayed in brackets.
I am able to do it in HTML output. The same, when i apply to EXCEL, it is not working.
I would appreciate if, some one replies with an example.
Thanks Viswakanth
May 17, 2004, 10:23 AM
<Grzegorz>
5.2.3 on Windows:
TABLE FILE CAR SUM COMPUTE MINSALE/D12.2B = -SALES; BY COUNTRY ON TABLE PCHOLD FORMAT excel_option END
Works well for the excel_option: EXL2K, but does not work for: EXL97, and EXCEL. You can also compute the alpha field for report, adding braces if the numeric value is negative.This message has been edited. Last edited by: <Mabel>,
May 17, 2004, 10:40 AM
<Viswa>
I am working on 436 developer studio. Following is the code, which i have written. TABLE FILE CAR PRINT CAR MODEL DEALER_COST SEATS COMPUTE FINAL_CT/P10.2B = -100000+ DEALER_COST; BY COUNTRY ON COUNTRY SUBFOOT "Total <+0> <+0> <+0> " ON TABLE SET ONLINE-FMT EXL2K END
But i am not able to get the bracket for the negative terms. Please help me to cross this hurdle.
Thanks Viswakanth
May 17, 2004, 11:07 AM
<Grzegorz>
Viswakanth,
Your code works on my computer as expected (negative numbers are in brackets). On the IBI TechSupport site it is stated that it is known problem solved with Release 4.3.6 Service Pack 9.
Regards Grzegorz
May 17, 2004, 11:21 AM
<Viswa>
Hai grzegorz
Can you point me to the link, which states that, it is a known BUG.