Posted 4 March 2025, 12:37 pm EST
Issue Summary:
When importing a CSV file into spread designer, the time format from the source document is not maintained. The time format in the original file is hh:mm:ss, but upon import, the format is automatically changed to “General,” which causes the time data to alter (e.g., 100:39:41 becomes 4:39:41 after import).
Steps to Reproduce:
visit https://developer.mescius.com/spreadjs/demos/features/spreadjs-file-format/overview/purejs
import csv containing data in the above format.
Observe that the time data in the imported file (originally in hh:mm:ss format) changes to the “General” format.
Expected Behavior:
The time data in the imported CSV file should retain its original format (hh:mm:ss) without automatically switching to “General” format.
Actual Behavior:
Upon import, the format changes to “General,” which alters the time data. For example, 100:39:41 becomes 4:39:41.
CSV attached for reference
