Some fields, such as AD or others containing commas, are being converted to numbers in Excel. This results in incorrect data representation. The expected behavior is for these fields to be treated as text to preserve their original format.
Steps to Reproduce
Run the script with a VCF file containing fields like AD that have comma-separated values.
Convert the output to Excel format.
Open the Excel file and observe that fields with commas are converted to numbers.
Expected Behavior
Fields with commas should be treated as text in the Excel output to ensure the original format is preserved.
Actual Behavior
Fields with commas are converted to numbers, resulting in incorrect data representation.
Proposed Solution
Fix the type of such fields as text when converting to Excel format.
Impact
Ensuring fields with commas are treated as text will preserve the integrity of the data and avoid misrepresentation in the Excel output.
Additional Notes
Ensure backward compatibility with existing functionality.
Update the documentation to reflect the correct handling of fields with commas.
Description
Some fields, such as AD or others containing commas, are being converted to numbers in Excel. This results in incorrect data representation. The expected behavior is for these fields to be treated as text to preserve their original format.
Steps to Reproduce
Expected Behavior
Fields with commas should be treated as text in the Excel output to ensure the original format is preserved.
Actual Behavior
Fields with commas are converted to numbers, resulting in incorrect data representation.
Proposed Solution
Fix the type of such fields as text when converting to Excel format.
Impact
Ensuring fields with commas are treated as text will preserve the integrity of the data and avoid misrepresentation in the Excel output.
Additional Notes