Get the explanation at :
\\ibmx3100m4\DFS_Support\Tips\Why Cannot Autosum the amount after export to excel
- On the previous version, the report builder application was not locked which means, the Number Format is Currency ( following your control panel currency)
- For this case, let say your computer control panel suddenly change to Malaysia currency and the decimal point and digit grouping will automatically change also. It will makes the amount totally different.- The excel will automatically followed control panel option. This happen when the report builder unlocked their system when export to excel. It might be a problem to the user who did not recognize this.
- That’s why for the new version , this Report Builder where we used this component to customize report & doing import/export ,change their features which is to LOCKED the document by replace from using the ‘Currency’ in Number Format to ‘General’.
- This is to ensure that, whatever the amount that we see in the QnE inquiry/preview screen must be the same amount after we export to excel without changing the decimal point or adding some currency in front of the figure.
Since we used others component to build the report, it is out of system limitation to return as the previous version back.