Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Stephanie Laurent

Pages: [1]
1
Thanks. I guess we will treat this as a known limitation and just work around it by either making the grid fit all columns or just make it stretch out of the screen in those cases where there are too many columns to display nicely to the user.

Thanks again

2
Hi

Thanks, your sample is 100%. The problem is we don't want the vertical scrollbar. If you now remove the "overflow-x:auto" from the wrapper, the vertical scrollbar disappears. My guess is that because of certain floating or absolute positioned elements within the grid causes this behaviour?

So at the moment we either have to live with the vertical scrollbar if we want to scroll horizontally or without the horizontal scrollbar if we want the text area to expand "above" all elements below it when a cell is selected. Am I right in saying this?

Thanks

3
Hi

I have a similar problem as the following issue:
http://paramquery.com/forum/index.php?topic=1048.msg5100#msg5100
however my div overflow is already set to visible but I still have the issue. See attached image.

Basically my grid is contained within 3 other divs see code below:
Code: [Select]
<div id="divContent" class="paddingtop" style="display:block;">
                    <div id="divExcelAllocationArea">
                        <div id="divExcelInfo" style="display: none;">
                            <span class="spanExcelInfoBold">Quick Guide:</span> [Enter] = New line in a Cell  <span class="spanExcelInfoSplit">|</span>  [Tab] = Save changes to the Cell  <span class="spanExcelInfoSplit">|</span>  [Esc] = Exit the Cell without saving changes
                        </div>
                        <div id="divExcelContentGridWrapper">
                            <div id="divExcelContentGrid" ></div>
                            <div class="clear"></div>
                        </div>
                    </div>
                </div>
                <div class="clear"></div>

my css pertaining to the code above is as follows:

Code: [Select]
#divExcelContentGridWrapper
{
    overflow-x: auto;
    min-width: 835px;
    min-height: 100px;
    background-color: blue;
}

#divExcelContentGrid {
    MARGIN: auto;
    float: left;
    background-color: red;
}

tr.pq-grid-oddRow td{
    background:#fff;
}

div.pq-grid tr td.disabled{   
    text-shadow: 0 1px 0 #fff;
    background:#ddd;
    font-weight: bold;
}

 .ui-autocomplete {
        max-height: 200px;       
        overflow-y: auto;
        /* prevent horizontal scrollbar */
        overflow-x: hidden;
    }   
   
.pq-grid .pq-editor-focus
    {
        outline:none;
        border:1px solid #bbb;   
        border-radius:6px;
        background-image: linear-gradient(#e6e6e6, #fefefe);

        filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#e6e6e6', endColorstr='#fefefe');
        background: -webkit-gradient(linear, left top, left bottom, from(#e6e6e6), to(#fefefe));
        background: -moz-linear-gradient(top,  #e6e6e6,  #fefefe); /* for firefox 3.6+ */        
    }
    div.pq-grid
    {
        overflow:visible;
    }   

.clear { clear:both; height:1; line-height:0.1;}

my Grid js code is follows:

Code: [Select]
$cgrid = $("div#divExcelContentGrid").pqGrid({
                showTop: false,
                flexHeight: true,
                flexWidth:true,
                sortModel: { on: false },
                showBottom: false,
                dataModel: dataModel,
                colModel: header,
                selectionModel: { type: 'cell' },
                scrollModel: { autoFit: true },
                editModel: {
                    saveKey: $.ui.keyCode.ENTER,
                    keyUpDown: false,
                    cellBorderWidth: 0
                },
                numberCell: { show: false },
                resizable: true
            });

            // Refresh for IE11 display issue
            $cgrid.pqGrid("refreshView");

I have  tried various options but I just cannot get the height to adjust to the edit mode of a cell. If I remove the div with ID: divExcelContentGridWrapper then everything is fine but I had to add that div because otherwise when I have too many columns the grid would stretch out of the screen thus overflow-x did not work so I added the wrapper in order to make the div scroll horizontally of there are too many columns. But now this affects the vertical scrolling of the grid.

Can you please suggest a fix for this.

Regards


4
Help for ParamQuery Pro / Re: Cell Merging issue
« on: August 11, 2015, 07:24:54 pm »
Thanks for the help!

5
Help for ParamQuery Pro / Cell Merging issue
« on: August 11, 2015, 03:34:55 pm »
Hi

I am busy working on a cell merging issue we have currently. We have a requirement whereby any valid Excel merged cells should be reflected in the paramQuery grid as well. For most part I could get the merging to work accept for instances where there are multiple merged cells on a particular row. It seems like if you add a colspan on a specific cell in a row and you have more colspans/rowspans on the same row they shift by the value of the colspan. If you look at my attached example the is an object 'cellattr3' which contains to merges. If I make the colspan on 'Quantity' 2 or more then the other merge shifts by that much as well. In this case the second merge should start on 'OrderID' but because the first colspan is 2 the second merge only start on the 'ShipAddress' column.

Is there a workaround for this?

Thanks

6
Thank you

Would it be okay to downgrade to the latest version 2 release?


7
Hi

I've narrowed the issue down to IE8/9 and 10 using paramquerygrid v3.0.0. I tried to put a jsfiddle together but it doesn't run in IE8 so please find attached zip with a sample that you can run in IE8/9 and 10. It works in Firefox and Chrome

Here is the jsFiddle sample (https://jsfiddle.net/jeanproux/yrdxLf1q/4/). You will see that it works fine in IE11.

the issue is if you edit a cell in the "Shipping address" column, adding multiple lines of text, move off it and then try to edit that cell again the cell doesn't go into edit mode again. The editor briefly appears and then cell removes it again. It also seems that the specific html structure plays a role. If you remove the "outerDiv" div then it runs in IE8 but when the grid div is surrounded by another div the editor fails to open. Another way I got it to work in IE8 is to set flexHeight to false, then the cell can be edited again? The problem with the flexheight=false is that the grid doesn't show nicely so we would like it to be true.

Please can you have a look at the sample. Could it be the version of the grid or jquery that is causing it. I used no other stylesheets or js files that could influence the display as you can see in the sample. The only style I use is the one you use on your demo.

Thanks

8
Thanks I will try and get a sample together if it still persist.

9
Hi

We have an issue where we have set up the grid so that each cell is of content type string and make use of the editmodel with a textarea control. We fetch the JSON data using ajax and only then do a instantiate the grid and manipulate and populate the grid data.

The issue is that when I edit the cell changing the content to contain multiple lines of text and save that cell and edit a next cell. When I go back to that cell I cannot enter the edit mode, it shows the textarea briefly and then takes the cell out of edit mode again thus I am not able to edit that cell again. This only happens on the first cell you edit in a row and add multi-line content, all other cells in that row is still editable until you add multiple lines of text, then that cell cannot be edited again as well.

Please find attach files of the code I use to create the grid, snapshot of the data and also a screen shot of the grid

Pages: [1]