Thursday 13 March 2014

Rounding Off Decimal Issue - While exporting data from siebel to Excel

You all may be aware of the vanilla export functionality in siebel. Using this functionality users can export siebel data to CSV or TXT file. I encountered an issue while exporting data from siebel. In siebel applet we had a field which displayed decimal data upto 5 decimal values. But on the exporting the data the field was rounded off to 2 decimal places and in the CSV file I had rounded off values for the field.

For eg in siebel the field showed value 3.06789 and after export the values was rounded off to 3.07.

After analysis the issue was identified. Export showed this behavior because of the configuration made in Administration-Data->Locale. Here we have a field Number Fractional Digits which was pre-configured to 2. It was changed to 5 which helped me resolved the issue. The change was made for ENU only .If you are using a multi lingual application then you should make the changes accordingly to reflect the desired behavior.



1 comment:

  1. it did't work for me, i made the change and restarted the server

    ReplyDelete