No. formatting in CSV
This parameter defines the behavior of Excel exports when CSV files contain chains whose values are composed only of numerical characters. This Excel export is available in the query tool, inquiries, and grids.
For example, if a product code is purely numerical, 004526 code is also 004526 in the CSV file. Excel sees it as a number and transforms this code in 4526. If there are too many characters, Excel can transform it into a notation of 123 e+8 type.
To avoid this Excel behavior, it is possible to transcode character chains which are purely numerical into a formula in the CSV export (syntax="123...").
It is the default behavior of every CSV export. The default value of this parameter, specified at the folder level, is equal to Yes.
Since this behavior can be a problem if the export is used by another program, it is possible to disable this transcoding by setting the parameter value to No.
Level of localization/Global variable
This parameter is defined at the level User. It belongs to Chapter SUP (Supervisor) and the Group FMT (Formats), The following parameters are also associated with this chapter and group :
- CPYMAXLEN (Max size of company codes)
- CPYMINLEN (Min size of company codes)
- DATBO (Date format)
- DECRCU (No. decimals currency rate)
- FCYMAXLEN (Max size of site codes)
- FCYMINLEN (Min size of site codes)
- FMTDAT (Standard date format)
- FMTJOU (Month - day format)
- FMTMOI (Month - year format)
- FMTSTA (Format statistical columns)
- RQTSEP (Export separator)
The global variable GNUMCSV is associated with it.