Long time ago, I create a command-line tool to convert Excel files to JSON files and vice versa. A few days ago, one of my colleagues reported a strange bug to me: some date values in sheets was wrong after converting to JSON.

At first, I didn’t pay much attention to it. A few days later, he continued to follow up this issue, and spotted the clue: copying values from the .xlsx file with problem, into another new Excel file, the date value was different; but if copying into another sheet in the same file, the date value was still the same… 😐

Read More