Inconsistency on formatCode per numFmtId

aVadim483 / fast-excel-writer

Lightweight and very fast XLSX Excel Spreadsheet Writer in PHP

MIT License

163 stars 31 forks source link

Closed AzzaAzza69 closed 1 year ago

AzzaAzza69 commented 1 year ago

Hi, Some of the format patterns for 14 - 22 appear to be locale/short date/long date combinations as my Excel show these values:

14=>dd/mm/yyyy  (my windows short date format)
15=>dd-mmm-yy
16=>dd-mmm
17=>mmm-yy
18=>h:mm
19=>h:mm AM/PM
20=>h:mm:ss AM/PM
21=>hh:mm
22=>hh:mm:ss

AzzaAzza69 commented 1 year ago

Wrong library ; I'll repost to the fast-excel-reader!