jQWidgets Forums

Forum Replies Created

Viewing 14 posts - 1 through 14 (of 14 total)
  • Author
    Posts
  • August 19, 2013 at 8:22 am in reply to: HTML in Excel export damage it HTML in Excel export damage it #27113

    Robin Kluth
    Member

    Hi Dimitar,

    I’ve used 2.9.0 in my case and did a update to 3.0.0. Now it works as expected!

    So, it seems that you fixed something in that direction – but I did not found any hint in the Release History.

    Thanks anyway!

    July 9, 2013 at 7:49 am in reply to: XLS Export: s is null XLS Export: s is null #24779

    Robin Kluth
    Member

    Sorry for pushing that – Do you have any idea why it is not working anymore?

    Thanks in advance!

    July 3, 2013 at 8:39 am in reply to: XLS Export: s is null XLS Export: s is null #24395

    Robin Kluth
    Member

    Another thing:

    If a datafield (in my case type: string) contains any HTML-character, the created xls is defective:

    If I open it, Excel say that the Sheet 1 is damaged and generate me an error log:

    XML PARSE ERROR: Extraneous end-tag
    Error occurs at or below this element stack:
        <ss:Workbook>
         <ss:Worksheet>
          <ss:Table>
           <ss:Row>
            <ss:Cell>
             <ss:Data>

    As soon as I fill the grid with Text with HTML in it (like: This is a text), the created xls will not work:

    That worked in previous versions of jqwidgets.

    Is that a correct behaviour? I mean: Is HTML not allowed here anymore?

    July 3, 2013 at 6:28 am in reply to: XLS Export: s is null XLS Export: s is null #24383

    Robin Kluth
    Member

    Thanks for that hint!

    Yep, that was the reason – Very weird error on the Grids side.

    Thanks!

    July 3, 2013 at 6:18 am in reply to: XLS Export: s is null XLS Export: s is null #24378

    Robin Kluth
    Member

    Okay, this example does not work (at least for me):

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
       "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
    <!-- mobile viewport optimisation -->
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <!-- stylesheets -->
    <link rel="stylesheet" href="js/jqwidgets/styles/jqx.base.css?2013070308" type="text/css" />
    <link rel="stylesheet" href="js/jqwidgets/styles/jqx.energyblue.css?2013070308" type="text/css" />
    <!-- jQuery -->
    <script type="text/javascript" src="js/jqwidgets/scripts/jquery-1.10.1.min.js?2013070308"></script>
    <!-- jqWidgets -->
    <script type="text/javascript" src="js/jqwidgets/jqxcore.js?2013070308"></script>
    <script type="text/javascript" src="js/jqwidgets/scripts/gettheme.js?2013070308"></script>
    <script type="text/javascript" src="js/jqwidgets/jqxdata.js?2013070308"></script>
    <script type="text/javascript" src="js/jqwidgets/jqxdata.export.js?2013070308"></script> 
    <script type="text/javascript" src="js/jqwidgets/jqxnavigationbar.js?2013070308"></script>
    <script type="text/javascript" src="js/jqwidgets/jqxbuttons.js?2013070308"></script>
    <script type="text/javascript" src="js/jqwidgets/jqxscrollbar.js?2013070308"></script>
    <script type="text/javascript" src="js/jqwidgets/jqxmenu.js?2013070308"></script>
    <script type="text/javascript" src="js/jqwidgets/jqxgrid.js?2013070308"></script>
    <script type="text/javascript" src="js/jqwidgets/jqxgrid.selection.js?2013070308"></script> 
    <script type="text/javascript" src="js/jqwidgets/jqxgrid.columnsresize.js?2013070308"></script>
    <script type="text/javascript" src="js/jqwidgets/jqxgrid.export.js?2013070308"></script> 
    </head><body> <script type="text/javascript">
            $(document).ready(function () {
                var theme = 'energyblue'
                var source =
    				{
    					datatype: "json",
    					id: 'id',
    					localdata: [{"proddb":null,"title":"test","id":"203"}]
    				};
                var dataAdapter = new $.jqx.dataAdapter(source);
                // initialize jqxGrid
                $("#jqxGrid").jqxGrid(
                {
    				width: 800,
    				height: 500,
    				theme: theme,
    				source: dataAdapter,
    				altrows: true,
    				sortable: false,
    				columns: [
    					{ text: 'Titel', datafield: 'title'},
    					{ text: 'Keywords', datafield: 'proddb' }
    					]
                });
    			$("#jqxNavigationBar").jqxNavigationBar({ theme: theme, expandMode: 'multiple', expandedIndexes: [0] });
    			
          		$("#excelExport").jqxButton({ theme: theme, width: '150' });
    			$("#htmlExport").jqxButton({ theme: theme, width: '150' });
    			
    			$("#excelExport").click(function () {
    				$("#jqxGrid").jqxGrid('exportdata', 'xls', 'FATSearch-ExcelExport');          
    			});
    			
    			$("#htmlExport").click(function () {
    				$("#jqxGrid").jqxGrid('exportdata', 'html', 'FATSearch-HTMLExport');          
    			});
    		});
    		
    </script>
    <input type="button" value="Excel Export" id="excelExport" />
    <input type="button" value="HTML Export" id="htmlExport" />
    	 <div id='jqxNavigationBar'>
                <div style="width: 80%">
                    Early History of the Internet</div>
                <div>
                     <div id="jqxGrid">
            </div>
                </div>
    	 </div>
    </body></html>

    I hope you can reproduce it or/and give me a hint 😉

    July 2, 2013 at 11:20 am in reply to: rows not in correct order rows not in correct order #24319

    Robin Kluth
    Member

    Hi,

    I’ve loaded the jqx.base.css as last stylesheet, but it does not work either.

    I’ve fixed it by put the following after all other stylesheets:

    .jqx-grid-cell {
        position: absolute !important; 
     }
    /*applied to a grid cell that is part of a rows group.*/
     .jqx-grid-group-cell{ 
        position: absolute !important; 
    }

    The !important was the magic key – But I dont understand it: The stylesheet option, coming from YAML, cannot be overwritten – but it should..? There is no other !important and I have to set it for .jqx-grid-cell to get it back working.

    Weird.

    July 2, 2013 at 10:23 am in reply to: rows not in correct order rows not in correct order #24316

    Robin Kluth
    Member

    Thanks for your answer.

    I’ve figured it out:

    As I said before: I use YAML. I use the grid inside a .ym-form:

    <form class="ym-form ym-columnar" onsubmit="return false;" id="result">

    .ym-form has the following position style: 

    .ym-form div { position:relative; }

    This is the issue – if I remove that css-style over Firebug it looks ok. I did not update YAML, I simply updated jQWidgets.

    It does not matter which position is set: the grid always gets crashed – I have to remove the whole css entry for now. Do you changed something that could explain that behaviour?

    Thanks in advance!

    February 12, 2013 at 10:26 am in reply to: NS_ERROR if Chart shall initialize in closed NavigationBar NS_ERROR if Chart shall initialize in closed NavigationBar #15049

    Robin Kluth
    Member

    Thanks for your answer. I cant use it, because the navigationbar is already initialized if I want to initialize the Chart. The Chart gets generated after a few user’s input.

    Another way could be the creation of a empty chart while initialize the NavigationBar and only update the Chart after user input.

    Whatever, thanks for your hint.

    January 23, 2013 at 1:34 pm in reply to: Error in sample Code: Cannot read property ‘msie’ of undefined Error in sample Code: Cannot read property ‘msie’ of undefined #14102

    Robin Kluth
    Member

    Okay, I thought you wanted to ship jQuery 1.9 with the jQX 2.6.1-package (because you linked to it on the download-page:

    <!-- add the jQuery script -->
        <script type="text/javascript" src="scripts/jquery-1.9.0.min.js"></script>
    January 23, 2013 at 1:21 pm in reply to: Error in sample Code: Cannot read property ‘msie’ of undefined Error in sample Code: Cannot read property ‘msie’ of undefined #14100

    Robin Kluth
    Member

    @Peter Stoev: The latest package misses jquery-1.9.min.js (latest jQuery version shipped with that package was 1.8.2). You linked to 1.9 in the Main-Page example, so it seems that you’ve forgot it, right? 🙂

    September 18, 2012 at 12:04 pm in reply to: Nested Grid manipulation Nested Grid manipulation #8100

    Robin Kluth
    Member

    Hi Dimitar!

    The demo seems to be buggy, btw:

    for (var m = 0; m < orders.length; m++) {
        var result = filter.evaluate(orders[m]["EmployeeID"]);
        if (result)
        ordersbyid.push(orders[i]);
    }

    You use ‘i’ for ordersbyid.push(orders[i]); but i is not defined. It should be m, shouldnt it?

    September 12, 2012 at 8:40 am in reply to: SaveAs… Question SaveAs… Question #7762

    Robin Kluth
    Member

    Hi,

    is it possible to get the source code of http://www.jqwidgets.com/export_server/save-file.php ?

    I want to host the exporter locally.

    Thanks!

    September 11, 2012 at 8:05 am in reply to: Tooltip appears under mouse and closes immediately Tooltip appears under mouse and closes immediately #7671

    Robin Kluth
    Member

    Thanks for your reply.

    Ive figured it out:

    I using the YAML Framework 4.x and its typography.css defines the following rule:

    table {
    width:100%;
    border-collapse:collapse;
    margin: 1.3571em 0 0 0;
    color:#333;
    border-top: 1px #ccc solid;
    border-bottom: 1px #ccc solid;
    }

    The margin was the source of this issue 🙂

    To workaround, simply edit the central.css like this (after all the @import’s):

    #jqxChart table {
    margin: 0;
    }

    September 11, 2012 at 6:49 am in reply to: Show sum in Chart with multiple series Show sum in Chart with multiple series #7655

    Robin Kluth
    Member

    Thanks for your reply.

    But this could be a nice feature for future versions 🙂

    Thanks for your help!

  • Author
    Posts
Viewing 14 posts - 1 through 14 (of 14 total)