javascript 很多列的数据表宽度溢出
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/8655001/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Datatables Width Overflow For A Lot Of Columns
提问by deerawan
Woah, I have this serious problem with jquery datatables plugin. I have a table with a lot of columns (over 35 columns) and this table is overflow my div content.
哇，我对 jquery 数据表插件有这个严重的问题。我有一个包含很多列（超过 35 列）的表，这个表溢出了我的 div 内容。
I have tried many ways (including solution at same problems in stack overflow) but still couldn't solve this problem. So, I really need your help here, please. :)
我尝试了很多方法（包括解决堆栈溢出中的相同问题），但仍然无法解决这个问题。所以，我真的需要你的帮助，拜托。:)
Thank you thank you so much
谢谢 非常感谢
You can see the screenshot here.
您可以在此处查看屏幕截图。
Here is the javascript code
这是javascript代码
var list_table = $("#list_table").dataTable({
"sScrollX": "100%",
"sScrollXInner": "110%",
"bScrollCollapse": true
});
Here is the html table
这是html表
<table class="display" id="list_table">
<thead>
<tr>
<th rowspan="2">Account Code</th>
<th rowspan="2">Account Name</th>
<th colspan="3">January</th><th colspan="3">February</th><th colspan="3">March</th><th colspan="3">April</th><th colspan="3">May</th><th colspan="3">June</th><th colspan="3">July</th><th colspan="3">August</th><th colspan="3">September</th><th colspan="3">October</th><th colspan="3">November</th><th colspan="3">December
</th><th colspan="3">January s/d December
<!-- <th rowspan="2" class="link"></th>-->
</th></tr>
<tr>
<th>Budget</th>
<th>Actual</th>
<th>Variance</th>
<th>Budget</th>
<th>Actual</th>
<th>Variance</th>
<th>Budget</th>
<th>Actual</th>
<th>Variance</th>
<th>Budget</th>
<th>Actual</th>
<th>Variance</th>
<th>Budget</th>
<th>Actual</th>
<th>Variance</th>
<th>Budget</th>
<th>Actual</th>
<th>Variance</th>
<th>Budget</th>
<th>Actual</th>
<th>Variance</th>
<th>Budget</th>
<th>Actual</th>
<th>Variance</th>
<th>Budget</th>
<th>Actual</th>
<th>Variance</th>
<th>Budget</th>
<th>Actual</th>
<th>Variance</th>
<th>Budget</th>
<th>Actual</th>
<th>Variance</th>
<th>Budget</th>
<th>Actual</th>
<th>Variance</th>
<th>Budget</th>
<th>Actual</th>
<th>Variance</th>
</tr>
</thead>
<tbody>
<tr>
<td>5201010013</td>
<td><span class="coa-text">INSENTIVE/SHIFT ALLOWANCE</span><br> <span style="background: #778A52" class="attr-text">Divisi Anggaran dan Pajak</span> <span class="loc-text">InChina</span> <span class="asset-text">FA-GENSET</span> <span class="tenant-text">PT. Angin Rupiah</span> </td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">2,500,000.00</td>
<td class="align-right">30,000,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">30,000,000.00</td>
</tr>
<tr>
<td>5203010001</td>
<td><span class="coa-text">MAKAN BERSAMA TAMU DAN REKANAN</span><br> <span style="background: #778A52" class="attr-text">Divisi Anggaran dan Pajak</span> <span class="loc-text">Satu Dua</span> </td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">7,000,000.00</td>
<td class="align-right">-5,500,000.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">0.00</td>
<td class="align-right">1,500,000.00</td>
<td class="align-right">18,000,000.00</td>
<td class="align-right">7,000,000.00</td>
<td class="align-right">11,000,000.00</td>
</tr>
</tbody>
回答by Allan Jardine
I'd suggest removing the sScrollXInner firstly (it shouldn't really be needed... :-) ). Then have a look at what the width of the wrapper element is. It should end up looking like this example: http://datatables.net/release-datatables/examples/basic_init/scroll_x.html
我建议首先删除 sScrollXInner （它不应该真的被需要...... :-) ）。然后看看包装元素的宽度是多少。它应该最终看起来像这个例子：http: //datatables.net/release-datatables/examples/basic_init/scroll_x.html
回答by Rajiv Sharma
scrollX: true
滚动X：真
This will automatically add a scroll bar when any overflow of column width.
当任何列宽溢出时，这将自动添加滚动条。
Make sure responsive: falseother wise you will see a (+) icon in the starting of row
确保在responsive: false其他方面你会在行的开头看到一个 (+) 图标
