Answers

• kolousek Posts: 3Questions: 1Answers: 0

  May 2

  {
          match: /^(19\d\d|[2-9]\d\d\d)\-(0\d|1[012])\-[0123][\d]$/,
          style: 67,
          fmt: function (d) {
              return Math.round(25569 + Date.parse(d) / (86400 * 1000));
          }
      } //Date yyyy-mm-dd
  

  looks like this filter is applied (from buttons.html4.js), but the style is not used?
• allan Posts: 64,335Questions: 1Answers: 10,623 Site admin

  May 2

  OOft. I think it is because the header is ISO8601 formatted in your example there. Compound styles are an absolute pita in XSLX files and I have it set to be bold styling for header cells, which removes the formatting for date cells.

  Thanks for letting me know about that. The would around at the moment would be to use a format that isn't ISO8601 (YYYY/MM/DD for example wouldn't match that regex).

  Allan
• kolousek Posts: 3Questions: 1Answers: 0

  May 4

  The easiest way - using slashes instead of dashes did not cross my mind, thanks a lot!