Export Issue - Data Exported is exponential from csv viewed in Excel

P3-Core-Dev-Team / P3-Q-A

This repo is for tracking features

Other

1 stars 0 forks source link

Export Issue - Data Exported is exponential from csv viewed in Excel #6

Closed harsha-kotha closed 8 months ago

harsha-kotha commented 1 year ago

Environment - Pulte New Dev ADS 3.1.7

https://archon-datastore.platform3solutions.com/pulte/dev/login

App : Recruiting Management Search : Test_Assign

Selected record export in csv format shows exponential from csv viewed in Excel, should maintain as number/id from source.

Value in Export: COL1

5.01047E+12

kilam005 commented 1 year ago

CSV file is properly generated. While opening in excel, the data is displayed in exponential. but data is exported as number only.

harsha-kotha commented 1 year ago

what is default fix? i saw the value in txt file. By default many will use Excel, apparently it looks as if it is data issue in first sight when looked.

harsha-kotha commented 1 year ago

i have nothing to re-test, i want a way for excel to work

kilam005 commented 1 year ago

Excel auto converts when loading data.

kilam005 commented 1 year ago

There is no fix, except load in EXCEL using Data import wizard. This is outside scope of the tool. As indicated, the data is loading in CSV format properly.

If there is any other workaround, do let us know.

kilam005 commented 9 months ago

@harsha-kotha You need to see the comments above and give a conclusion to this.

kilam005 commented 8 months ago

details There is no fix, except load in EXCEL using Data import wizard. This is outside scope of the tool. As indicated, the data is loading in CSV format properly.

@harsha-kotha Please check and give a conclusion

harsha-kotha commented 8 months ago

Closing for now, if there is a client requirement this needs to be revisited.