search

chuahjiajie / pe

0 stars 0 forks source link

Incorrect Parsing of Information into CSV #15

Open chuahjiajie opened 2 months ago

chuahjiajie commented 2 months ago

image.png

As seen from the image above this is the output of the CSV with the phone number field for the first person being just 0.

However, in the actual app, this is the phone number:

image.png

soc-se-bot commented 2 months ago

Team's Response

Thank you for your feedback. This is not part of app problem, it comes from your own excel setting.

image.png When you open the file with excel, this message pops up. And you can decide it not to remove leading zeros. Also, based on your screenshot, excel is indicating that there is possible data loss. If you set it to correct setting, there will be no data loss. If you dont want to change the setting, you can consider alternative(e.g. notepad) to open the csv file without losing leading zeros. There are many good softwares for opening csv file without data loss! The Excel with correct setting now displays correct phone numbers with only zeros just like your example in excel: image.png

Items for the Tester to Verify

:question: Issue response

Team chose [response.Rejected]

Reason for disagreement: [replace this with your explanation]

## :question: Issue type Team chose [`type.FeatureFlaw`] Originally [`type.FunctionalityBug`] - [ ] I disagree **Reason for disagreement:** [replace this with your explanation]