search

andrewblake1 / WorksManagement

Project/Works management system for Northpower's Westcoast Energy
0 stars 3 forks source link

Exporting dates does not work in Excel; column headings are not correct #329

Closed hawea closed 11 years ago

hawea commented 11 years ago

Hi Andrew,

To recreate bug please go follow these instructions:

  1. Go to this link: http://dev.melbourne.wcewm.co.nz/Duty/admin?action_id=6&task_id=12
  2. Click "Download Excel"
  3. When you open the excel file, the dates are all showing as text, but they need to be in date format. (Bug 1)
  4. Also, the heading of Due and Completed columns is now saying "raw"
andrewblake1 commented 11 years ago

hawea, check resolved and close on next update.

Se my previous comment on related issue re formating of columns and column names. I.e. archive. It is possible that excel was guessing fomatting of csv file column to be date however have not applied any formating yet to columns as this requires code to be written which is of lower priority.

hawea commented 11 years ago

Still not working, will archive