search

zetkin / organize.zetk.in

Organizer front-end of the Zetkin system for organizing activism
21 stars 14 forks source link

Upgrade xlsx package to fix date import bug #1251

Closed niklasva82 closed 3 years ago

niklasva82 commented 3 years ago

This fixes a problem where dates are not properly formatted on import from Excel documents.

To reproduce bug:

  1. Export from dynamics 365 with a date column
  2. Import in Zetkin
  3. Map date column to a custom date field Expected: Properly formatted date Actual: Raw value representing date in Excel of the format "42785.12547"

This seems to be caused by the xlsx package not properly parsing the "z" parameter of cells. This appears to be fixed in a later version of the package. This also specifies the date format to international standard to make sure it's interpreted properly.