Search

thanks for quick answer allan, but when i export example to excel doesnt show the blue background. Preparing test-case..

I have no idea what your question is! I can see the title of your post, but I don't know what software you are using (i.e. are you using Editor, or something else)? Allan

I see that for the data, you discarded the values of data.options and data.files. Does that mean I can't use the data if I need to keep those values for Editor?

That works! Thanks Allan.

Never mind I got this working by editing my modified version of the ssp.class.php file so that the data_output function now looks like this: static function data_output($columns,$data) { print_r($data); $DateFields = include 'DateFields.php'; $out = array(); for($i=0,$ien=count($data);$i<$ien;$i++) { $row = array(); for($j=0,$jen=count($columns);$j<$jen;$j++) { $column = $columns[$j]; if(isset($column['Formatter'])) { echo "Formatter<br>"; $row[$column['dt']] = $column['Formatter']($data[$i][$column['db']],$data[$i]); } else { //This is were I added the <div> around the values to allow the scrolling to work in all browsers. $row[$column['dt']] = "<div class='Scrollable'>" .$data[$i][$columns[$j]['db']]. "</div>"; if(in_array($column['db'],$DateFields,TRUE) && $row[$column['dt']] != '') { $row[$column['dt']] = substr($data[$i][$columns[$j]['db']],5,2) . "/" . substr($data[$i][$columns[$j]['db']],8,2) . "/" . substr($data[$i][$columns[$j]['db']],2,2); } } } $out[] = $row; } return $out; } I had to add a div inside the individual td so that the scroll would work.

Hi, Not based on screen resolution as such, but rather by browser window height, yes. I wrote a blog post a while ago introducing a plug-in that will do this with scrolling enabled. Since then I've also written one that will work with paging enabled but haven't written it up on the blog yet. There is an example in the repo showing how it works. Regards, Allan

editor.remove(table.row(i), false).submit(); Try using table.row(i).index(). In this example if I run: var rowIdx = $('#example').DataTable().row(':eq(0)').index(); editor.remove(rowIdx, false).submit(); It deletes the first row without confirmation. Allan

It isn't currently possible in the forum to make your own questions as the answer (something I need to correct). I've done it for you. Allan

Aha, even better. Will try that. Thanks!

It seems to work without that for me: http://live.datatables.net/bavafimu/1/edit . It shouldn't really need the square brackets, which would suggest an array. Allan