Messages

1

Help for ParamQuery Pro / Re: Excel Export Formatting

« on: May 15, 2018, 06:51:45 pm »

I had to upgrade to v4, as suggested, to get the number formatting to work correctly.

2

Help for ParamQuery Pro / Re: Excel Export Formatting

« on: May 14, 2018, 06:05:10 pm »

I tried the same initially but the data is changed when exported. It removes all leading zeroes and displays in scientific notation.

This is my sample data, logged in the javascript console for verification.

ALL
0004062104611461575
0004062107110507813
0004062109655336315
055007425063700110658115
100890100018982003312100
1044372000749303326
10443720008563710304
Account Group

3

Help for ParamQuery Pro / Re: Excel Export Formatting

« on: May 11, 2018, 11:25:07 pm »

How about exporting numbers as strings? I'm having trouble with exporting numbers like 000111000, 111122222, 11100000, and have them show exactly like they need to be (acct numbers). Only way so far has been adding a "'" to the string but that's not acceptable. It used to work too.

4

Help for ParamQuery Pro / Re: Excel Export Formatting

« on: May 05, 2018, 12:25:11 am »

Looks like triggering the render with the same content works, but why would we have to do this when the same content is already there. This used to work on 3.3.5.
//...looping through colModel...
        colModel.render = function (ui) {
            var rowData = ui.rowData, dataIndx = ui.dataIndx;
            rowData.pq_cellcls = rowData.pq_cellcls || {};
            return rowData[dataIndx];
        }

5

Help for ParamQuery Pro / Re: Excel Export Formatting

« on: May 04, 2018, 11:53:04 pm »

I don't have it with me but I was able to find v4 from our repository. The main breaking change I see is when we have an html table converted into a pq grid using $.paramquery.tableToArray, the html within some cells is being rendered as text and not the html controls (span, checkbox, etc.) that was there before. Is there a new option that I have to use to enable that rendering?

6

Help for ParamQuery Pro / Re: Excel Export Formatting

« on: May 04, 2018, 11:12:32 pm »

So the only option is to upgrade? How's the compatibility, much effort to do so?

I know my company has upgraded to a later version but I am not seeing it on my download page. Can you help with that too?

7

Help for ParamQuery Pro / Excel Export Formatting

« on: May 04, 2018, 10:21:33 pm »

How do you format excel numbers?

I have tried data type float,  replacing commas dollar and dollar signs, etc. On every attempt, the exported file asks to convert text to numbers. I also tried adding colModel.format ='$###,###' and the data does not show with this option.

Using version 3.3.5.

8

Help for ParamQuery Pro / Refresh Row after Changing Data Model

« on: April 06, 2018, 06:12:38 pm »

I am having an issue using the refreshRow method after changing the pq_hidden property for a row. I am getting the error "Uncaught too many iterations" regardless of how I am using the refresh method whether in a loop looking for every qualifying row or with just one row by specifying the index (commented out below). I am trying not to use the refreshDataAndView method since I have checkbox controls in the grid that loose the clicked state when I refresh the whole thing. Please advise. Thanks!

    var detailsGrid = $('div#BudgetDetails').pqGrid()
    var data = detailsGrid.pqGrid("option", "dataModel").data;

    for (var i = 0, len = data.length; i < len; i++) {
        if (data[0].indexOf('rateCell') != -1) {
            data.pq_hidden = !visible;
            $("div#BudgetDetails").pqGrid("refreshRow", { rowIndx: i });
        }
    }
    //detailsGrid.pqGrid("refreshDataAndView");
    //pq.grid("div#BudgetDetails").refreshRow({ rowIndx: 4 });

9

Help for ParamQuery Pro / Re: Inline edititing with height flex

« on: July 31, 2017, 10:52:27 pm »

That corrected the issue. Thanks for your prompt response!

10

Help for ParamQuery Pro / Inline edititing with height flex

« on: July 31, 2017, 10:18:54 pm »

When our users are double clicking on a cell for editing its contents, the grid is removing all the rows above the one that was clicked on. I was able to narrow the the issue to having the height option on the grid set to 'flex'. It only happens when that option is set to that value. Is there another way to use the flex height without having the sort of issue we're having?
Our editable cell is set up like this:
           {dataIndx: 'foo',
            title: 'Foo',
            dataType: 'stringi',
            width: '17%',
            minWidth: 175,
            editable: true}
Our grid has the following options:
{
   bootstrap: { on: true, grid: "pq-small-font-grid" },
   collapsible: { on: false, toggle: false },
   columnTemplate: { halign: 'center', minWidth: 40, resizable: true },
   roundCorners: true,
   showTop: false,
   showTitle: false,
   showBottom: false,
   showToolbar: false,
   numberCell: false,
   minWidth: 200,
   oddRowsHighlight: true,
   columnBorders: false,
   wrap: false,
   hoverMode: 'none',
   virtualX: true,
   virtualY: true,
   editModel: { clicksToEdit: 1 }
   height: 'flex',
   selectionModel: { type: 'row' },
   showTop: true,
   freezeRows: 1,
   showToolbar: true,
   scrollModel: { autoFit: true },
   showBottom: true,
   editable: true,
   editModel: {
      saveKey: $.ui.keyCode.ENTER,
      keyUpDown: false,
      cellBorderWidth: 0
   },
   change: function (evt, ui) {
      if (ui.source == 'edit') {
         //Call API to save values and reload.
      }
   },
   beforeSort: function (evt, ui) {
      var freezeRows = this.option("freezeRows"),
         dataGrid = this.option("dataModel.data");
      frozenRows = dataGrid.splice(0, freezeRows);
   },
   sort: function (evt, ui) {
      var dataGrid = this.option("dataModel.data");
      Array.prototype.unshift.apply(dataGrid, frozenRows);
   }
}

11

Help for ParamQuery Pro / Hidden column based on ui cellData value

« on: March 21, 2017, 11:38:36 pm »

I am trying to hide a column based on the values of its rows. If the value is null for any row, then I need to hide the whole column.

I tried attaching a function to the hidden property of the column in the colModel, but that didn't seem to trigger. Can I hide the column based on a function on the render property?

Something like:

.colModel = [...
{... render: function (ui) { ui.cellData == null ? hidden = true: hidden = false }; }, ...