Focal Point
[CLOSED] Bracket symbol for Negative value is not working for SET FORMTYPE=XLS

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7297026326

August 29, 2012, 09:09 AM
PRAKASH N V
[CLOSED] Bracket symbol for Negative value is not working for SET FORMTYPE=XLS
We are setting the format as I11B which is to formating the negative value data with bracket.
This logic works for normal Exl2k format.
If we use the logic by set the output format by
SET FORMTYPE=XLS; then not working. Its give the output with - Symbol instead of bracket.

Any idea on this?

This message has been edited. Last edited by: Kerry,


WF: WebFOCUS 7.6.4/7.6.8/7.6.10/7702/7703
Windows: XP/NT,
Output formats: HTML,PDF,EXCEL,ACTIVE HTML
August 29, 2012, 03:30 PM
Crymsyn
Could you post an example of the problem using the CAR file?

I have tried simple examples but SET FORMTYPE=XLS shows the brackets in EXL2K and HTML formats in 7.7.02


WF: 8201, OS: Windows, Output: HTML, PDF, Excel