search

andrewblake1 / WorksManagement

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

Download excel issue #367

Closed hawea closed 11 years ago

hawea commented 11 years ago

To recreate this issue, please follow the instructions below:

  1. Click on this link: http://dev.melbourne.wcewm.co.nz/DutyStep/admin?action_id=4
  2. Click Download Excel button and open downloaded excel file in Excel 3.The first duty step: "Provide marked-up GIS plan OR worksite location information to Subcontractor Co-ordinator" when downloaded to excel shows as "ordinator/up GIS plan OR worksite location information to Subcontractor Co/Provide marked".

I think there is some issue with using hyphens. Can you please check and see what the issue is.

Thanks Hawea

andrewblake1 commented 11 years ago

I think somebodys code - i.e. i didn't write the export utility, is using a regular expression and manipulating a string with 2 hypens thinking it is a date, re-ordering the components, and putting in forward slashes.

I will need to see how to force to accept my own formatting. Looking into it now

andrewblake1 commented 11 years ago

@hawea check resolved and close.

Have located the issue and fixed for now - the similar issues may come back to haunt us. ExcelView.php line 202 to 207 commented out. Was pretty much exactly as thought in above comment. Unfortunately that extension is sparsely commented and I would guess likely other issues. Their is another extension claiming to auto format columns and headings etc which is what we want to resolve another archived issue. I will give it a go but predict given the feedback on it that it might not be smooth - it is also based on this extension - which seems over complicated but then I havn't really looked into what is going on as we have higher priority things to continue with first.

I can if needed write component based on the phpExcel library like this one if needed but will try to avoid doing so if can.