Answers

• kthorngren Posts: 21,352Questions: 26Answers: 4,955

  March 4

  The issue was posted in this thread. You should find the fix in the datatables and buttons nightly downloads. I think the fixes will find their way into the next releases of datatables and buttons.

  Kevin
• pat.thizy Posts: 7Questions: 2Answers: 0

  March 4 edited March 4

  I actually noticed the same problems as those reported in the commits. I applied all these fixes because my library is installed locally (I downloaded the files from the DataTables.net site)

  The problem I see is the following:
  In cell th of my header or footer I have for example the value 1234.
  In export options I return "TEST" + data
  Unfortunately in the CSV I find 1234 and not TEST 1234

  exportOptions: {
      format: {
        body: function (data, row, column, node) {
              return "TEST" + data;
  },
  

  To temporarily fix this problem I modified the header and footer code locally here :
  In datatables.js line 102745

  if (config.footer && data.footer) {
          footer = data.footer.join(separator);
  and comment this
  /*data.footerStructure
                  .map(function (row) {
                      return join(
                          row.map(function (cell) {
                              return cell ? cell.title : '';
                          })
                      );
                  })
                  .join(newLine) + newLine;*/
  

  for my use case it's enough

  Edited by Kevin: Syntax highlighting. Details on how to highlight code using markdown can be found in this guide
• pat.thizy Posts: 7Questions: 2Answers: 0

  March 4

  Small clarification, if I use version 1.5.1 of datatables I do not notice this problem
  When the same code in exportOptions I see TEST 1234 in the CSV without modifcation in the library
• kthorngren Posts: 21,352Questions: 26Answers: 4,955

  March 4

  I built a test case for you using all nightly code:
  https://live.datatables.net/fuyiyaxu/1/edit

  The header nor the footer are modified with the exportOptions format function. @allan will need to take a look.

  Kevin
• pat.thizy Posts: 7Questions: 2Answers: 0

  March 4

  Your example reflects exactly the problem I see
  Thanks a lot
• allan Posts: 63,542Questions: 1Answers: 10,476 Site admin

  March 4

  Could you post a link to your page showing the issue so I can trace it through please?

  The version numbers mentioned are a bit mixed up - there is no DataTables 3 for example, and 1.5.1 is ancient (2009), so I'd like to check what it is that you are actually using.

  Many thanks,
  Allan
• kthorngren Posts: 21,352Questions: 26Answers: 4,955

  March 4

  You may have missed it but I posted a test case showing the issue.

  Kevin
• kthorngren Posts: 21,352Questions: 26Answers: 4,955

  March 4

  Also this thread is reporting the same issue.

  Kevin
• allan Posts: 63,542Questions: 1Answers: 10,476 Site admin

  March 4

  Yup - bit of post overlap there, sorry about that. Thanks for the test case Kevin - I can indeed see the issue there. Wonder how I've broken it this time...

  Will be back shortly once I've fixed it.

  Allan
• allan Posts: 63,542Questions: 1Answers: 10,476 Site admin

  March 4

  Fixed here and the example with the nightly is now working as expected.

  I wasn't passing the header and footer titles from the new multi-row header and footer functions through the formatters. It happens now though.

  Thanks for the test case Kevin - is makes this so much easier. Thank you!

  Allan
• chbocca Posts: 90Questions: 14Answers: 1

  March 4

  But this update is not yet released, correct?
• allan Posts: 63,542Questions: 1Answers: 10,476 Site admin

  March 4

  That is correct. I've not yet tagged a release version with the fix.

  Allan
• chbocca Posts: 90Questions: 14Answers: 1

  March 8

  See latest release is out and this issue seems resolved.

  Thank you!
• lange Posts: 9Questions: 3Answers: 0

  March 8

  It works with me now. Thank you again!