How to set dfferent fixed columns datatable





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







0















I would like to set fixed columns on scroll with data tables, say I have a column at index 1,10,15. On horizontal scroll, I need to be able to set those as fixed. At the moment I am only able to set only the first column to be fixed.





  1. Work for the first column



    $('#example').DataTable( {
    fixedColumns: true


    } );




  2. Works for the first two columns



    $('#example').DataTable( {
    fixedColumns: {
    leftColumns: 2
    }
    } );




How do I fix the 1,10,15



I tried



$('#example').DataTable( {
fixedColumns: {
leftColumns: [1,10,15]
}
} );


Example



 table columns = > |1(freeze) | 2 |... |10(freeze)|....|15(freeze)|


Any suggestions










share|improve this question































    0















    I would like to set fixed columns on scroll with data tables, say I have a column at index 1,10,15. On horizontal scroll, I need to be able to set those as fixed. At the moment I am only able to set only the first column to be fixed.





    1. Work for the first column



      $('#example').DataTable( {
      fixedColumns: true


      } );




    2. Works for the first two columns



      $('#example').DataTable( {
      fixedColumns: {
      leftColumns: 2
      }
      } );




    How do I fix the 1,10,15



    I tried



    $('#example').DataTable( {
    fixedColumns: {
    leftColumns: [1,10,15]
    }
    } );


    Example



     table columns = > |1(freeze) | 2 |... |10(freeze)|....|15(freeze)|


    Any suggestions










    share|improve this question



























      0












      0








      0








      I would like to set fixed columns on scroll with data tables, say I have a column at index 1,10,15. On horizontal scroll, I need to be able to set those as fixed. At the moment I am only able to set only the first column to be fixed.





      1. Work for the first column



        $('#example').DataTable( {
        fixedColumns: true


        } );




      2. Works for the first two columns



        $('#example').DataTable( {
        fixedColumns: {
        leftColumns: 2
        }
        } );




      How do I fix the 1,10,15



      I tried



      $('#example').DataTable( {
      fixedColumns: {
      leftColumns: [1,10,15]
      }
      } );


      Example



       table columns = > |1(freeze) | 2 |... |10(freeze)|....|15(freeze)|


      Any suggestions










      share|improve this question
















      I would like to set fixed columns on scroll with data tables, say I have a column at index 1,10,15. On horizontal scroll, I need to be able to set those as fixed. At the moment I am only able to set only the first column to be fixed.





      1. Work for the first column



        $('#example').DataTable( {
        fixedColumns: true


        } );




      2. Works for the first two columns



        $('#example').DataTable( {
        fixedColumns: {
        leftColumns: 2
        }
        } );




      How do I fix the 1,10,15



      I tried



      $('#example').DataTable( {
      fixedColumns: {
      leftColumns: [1,10,15]
      }
      } );


      Example



       table columns = > |1(freeze) | 2 |... |10(freeze)|....|15(freeze)|


      Any suggestions







      jquery datatable datatables datatables-1.10






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 29 '18 at 5:19







      Alphy

















      asked Nov 29 '18 at 5:15









      AlphyAlphy

      1621216




      1621216
























          2 Answers
          2






          active

          oldest

          votes


















          2














          As per Datatable's Doc



          You can add Fixed Columns in both Left and Right and it even allows multiple Columns.



          Catch is all columns have to be continous.



          Unfortunately fixing column in middle is not allowed. Due to its complexity. Read Doc above



          Sample Code



          $(document).ready(function() {
          var table = $('#datatbleId').DataTable( {
          scrollY: "300px",
          scrollX: true,
          scrollCollapse: true,
          paging: false,
          fixedColumns: {
          leftColumns: 2,
          rightColumns: 3
          }
          } );
          } );


          More detail here



          Working Fiddle






          share|improve this answer































            0














            You might try this to fix the column in your js .



            $(document).ready(function() {
            var table = $('#example').DataTable( {
            scrollY: "300px",
            scrollX: true,
            scrollCollapse: true,
            paging: false,
            fixedColumns: {
            leftColumns: 1,
            rightColumns: 1
            }
            } );
            } );





            share|improve this answer


























              Your Answer






              StackExchange.ifUsing("editor", function () {
              StackExchange.using("externalEditor", function () {
              StackExchange.using("snippets", function () {
              StackExchange.snippets.init();
              });
              });
              }, "code-snippets");

              StackExchange.ready(function() {
              var channelOptions = {
              tags: "".split(" "),
              id: "1"
              };
              initTagRenderer("".split(" "), "".split(" "), channelOptions);

              StackExchange.using("externalEditor", function() {
              // Have to fire editor after snippets, if snippets enabled
              if (StackExchange.settings.snippets.snippetsEnabled) {
              StackExchange.using("snippets", function() {
              createEditor();
              });
              }
              else {
              createEditor();
              }
              });

              function createEditor() {
              StackExchange.prepareEditor({
              heartbeatType: 'answer',
              autoActivateHeartbeat: false,
              convertImagesToLinks: true,
              noModals: true,
              showLowRepImageUploadWarning: true,
              reputationToPostImages: 10,
              bindNavPrevention: true,
              postfix: "",
              imageUploader: {
              brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
              contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
              allowUrls: true
              },
              onDemand: true,
              discardSelector: ".discard-answer"
              ,immediatelyShowMarkdownHelp:true
              });


              }
              });














              draft saved

              draft discarded


















              StackExchange.ready(
              function () {
              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53532291%2fhow-to-set-dfferent-fixed-columns-datatable%23new-answer', 'question_page');
              }
              );

              Post as a guest















              Required, but never shown

























              2 Answers
              2






              active

              oldest

              votes








              2 Answers
              2






              active

              oldest

              votes









              active

              oldest

              votes






              active

              oldest

              votes









              2














              As per Datatable's Doc



              You can add Fixed Columns in both Left and Right and it even allows multiple Columns.



              Catch is all columns have to be continous.



              Unfortunately fixing column in middle is not allowed. Due to its complexity. Read Doc above



              Sample Code



              $(document).ready(function() {
              var table = $('#datatbleId').DataTable( {
              scrollY: "300px",
              scrollX: true,
              scrollCollapse: true,
              paging: false,
              fixedColumns: {
              leftColumns: 2,
              rightColumns: 3
              }
              } );
              } );


              More detail here



              Working Fiddle






              share|improve this answer




























                2














                As per Datatable's Doc



                You can add Fixed Columns in both Left and Right and it even allows multiple Columns.



                Catch is all columns have to be continous.



                Unfortunately fixing column in middle is not allowed. Due to its complexity. Read Doc above



                Sample Code



                $(document).ready(function() {
                var table = $('#datatbleId').DataTable( {
                scrollY: "300px",
                scrollX: true,
                scrollCollapse: true,
                paging: false,
                fixedColumns: {
                leftColumns: 2,
                rightColumns: 3
                }
                } );
                } );


                More detail here



                Working Fiddle






                share|improve this answer


























                  2












                  2








                  2







                  As per Datatable's Doc



                  You can add Fixed Columns in both Left and Right and it even allows multiple Columns.



                  Catch is all columns have to be continous.



                  Unfortunately fixing column in middle is not allowed. Due to its complexity. Read Doc above



                  Sample Code



                  $(document).ready(function() {
                  var table = $('#datatbleId').DataTable( {
                  scrollY: "300px",
                  scrollX: true,
                  scrollCollapse: true,
                  paging: false,
                  fixedColumns: {
                  leftColumns: 2,
                  rightColumns: 3
                  }
                  } );
                  } );


                  More detail here



                  Working Fiddle






                  share|improve this answer













                  As per Datatable's Doc



                  You can add Fixed Columns in both Left and Right and it even allows multiple Columns.



                  Catch is all columns have to be continous.



                  Unfortunately fixing column in middle is not allowed. Due to its complexity. Read Doc above



                  Sample Code



                  $(document).ready(function() {
                  var table = $('#datatbleId').DataTable( {
                  scrollY: "300px",
                  scrollX: true,
                  scrollCollapse: true,
                  paging: false,
                  fixedColumns: {
                  leftColumns: 2,
                  rightColumns: 3
                  }
                  } );
                  } );


                  More detail here



                  Working Fiddle







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered Nov 29 '18 at 5:51









                  MyTwoCentsMyTwoCents

                  3,3972930




                  3,3972930

























                      0














                      You might try this to fix the column in your js .



                      $(document).ready(function() {
                      var table = $('#example').DataTable( {
                      scrollY: "300px",
                      scrollX: true,
                      scrollCollapse: true,
                      paging: false,
                      fixedColumns: {
                      leftColumns: 1,
                      rightColumns: 1
                      }
                      } );
                      } );





                      share|improve this answer






























                        0














                        You might try this to fix the column in your js .



                        $(document).ready(function() {
                        var table = $('#example').DataTable( {
                        scrollY: "300px",
                        scrollX: true,
                        scrollCollapse: true,
                        paging: false,
                        fixedColumns: {
                        leftColumns: 1,
                        rightColumns: 1
                        }
                        } );
                        } );





                        share|improve this answer




























                          0












                          0








                          0







                          You might try this to fix the column in your js .



                          $(document).ready(function() {
                          var table = $('#example').DataTable( {
                          scrollY: "300px",
                          scrollX: true,
                          scrollCollapse: true,
                          paging: false,
                          fixedColumns: {
                          leftColumns: 1,
                          rightColumns: 1
                          }
                          } );
                          } );





                          share|improve this answer















                          You might try this to fix the column in your js .



                          $(document).ready(function() {
                          var table = $('#example').DataTable( {
                          scrollY: "300px",
                          scrollX: true,
                          scrollCollapse: true,
                          paging: false,
                          fixedColumns: {
                          leftColumns: 1,
                          rightColumns: 1
                          }
                          } );
                          } );






                          share|improve this answer














                          share|improve this answer



                          share|improve this answer








                          edited Nov 29 '18 at 5:45









                          Shree

                          12.9k2072124




                          12.9k2072124










                          answered Nov 29 '18 at 5:19









                          Fryann MartinezFryann Martinez

                          192




                          192






























                              draft saved

                              draft discarded




















































                              Thanks for contributing an answer to Stack Overflow!


                              • Please be sure to answer the question. Provide details and share your research!

                              But avoid



                              • Asking for help, clarification, or responding to other answers.

                              • Making statements based on opinion; back them up with references or personal experience.


                              To learn more, see our tips on writing great answers.




                              draft saved


                              draft discarded














                              StackExchange.ready(
                              function () {
                              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53532291%2fhow-to-set-dfferent-fixed-columns-datatable%23new-answer', 'question_page');
                              }
                              );

                              Post as a guest















                              Required, but never shown





















































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown

































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown







                              Popular posts from this blog

                              A CLEAN and SIMPLE way to add appendices to Table of Contents and bookmarks

                              Calculate evaluation metrics using cross_val_predict sklearn

                              Insert data from modal to MySQL (multiple modal on website)