Messages

1

Bug Report / Re: Several bugs in one example (validations, formulas and updateList)

« on: June 07, 2022, 03:50:06 pm »

Hello Team,

Would you be so kind to treat this bugs request?

It is over one month with no response.
You have all details and JSFiddle available.

Thank you.

2

Bug Report / Several bugs in one example (validations, formulas and updateList)

« on: May 05, 2022, 08:22:34 pm »

Hello,

Please find here a link to jsFiddle and description of several bugs in one example which is a very simplified one (in our case we have dozens of columns with formulas).

https://jsfiddle.net/0gyj8qns/10/

FYI: As in a screenshot, only values of columns B and C in rows 3 and 4 were changed manually

Critical bugs:

   In validation:
      Cell B1: has a formula, but shows validation error after entering and exiting edit mode even if there is NO ERROR (value is less than or equal 31)
      Cell B2 contains a formula with result that is not valid and was warned in a normal way
      Cell C2: no validation error is shown after initializing the grid (value should be less or equal 12) and will show error ONLY AFTER entering and exiting edit mode or executing a isValid() method on a row or a grid
      No validation errors are detected on a whole grid with isValidChange and isValid methods

   Why this is considered as bug: it is expected that there is a possibility to identify validation errors and (in our case) we have a special field that should be filled upon validation error in any cell in a row.

   Get Validation result in console:

Code: [Select]

"isValidChange", true
"isValid", {
  valid: true
}
   In getChanges:
      Cell B1 has a value that was changed by formula (from 1 to actual day index) after loading, but getChanges does not have any modified values from this row.
      All values in cells in column E were changed by formula, but do not appear in getChanges


   Why this is considered as bug: values calculated by formula are expected to be saved in DB.

   Get Changes result in console:

Code: [Select]

"getChanges", [{
  col2: 3,
  col3: 3,
  id: 3
}, {
  col2: 50,
  col3: 50,
  id: 4
}]
Non critical:
   "DATEVALUE" formula accepts impossible dates

Thank you in andvance.

Sincerely,

3

Bug Report / CONCATENATE formula bug: String evaluated as a number

« on: December 13, 2021, 07:27:34 pm »

Hello,

Here is a jsfiddle link : https://jsfiddle.net/f61kphrs/

All fields have type string, but as you see in a screenshot, there are cases when argument is evaluated as number.

In Excel such case will work correctly.

Thank you in advance!
Sincerely

PS: looks like, but not similar as and old corrected bug: https://paramquery.com/forum/index.php?topic=3821

4

Bug Report / Concatenation instead of a sum in Excel Formula

« on: November 25, 2021, 07:31:52 pm »

Hello,

Here is an important bug returning false (erroneous) values (screenshot 1):

https://jsfiddle.net/navswmr9/

All data types are float.

Code: [Select]

    $(function () {
        var data = [
            { col1: 11, col3: 44,       
              pq_fn: {                     
                    col4: 'A1+B1+C1'
            }
            },
            { col1: 11, col2: 22, col3: 44,         
              pq_fn: {                     
                    col4: 'A2+B2+C2'
            }
            }
];

        var obj = {
            height: 'flex',
            maxHeight: 600,
            scrollModel: { autoFit: true },
            showTitle: false,
            colModel: [
                { title: "col1", width: 40, dataType: "float", dataIndx: "col1"},
                { title: "col2", width: 40, dataType: "float", dataIndx: "col2" },
                { title: "col3", width: 100, dataType: "float", dataIndx: "col3"},
                { title: "=col1+col2+col3<br>(excel formula)", width: 100,
                dataType: "float", dataIndx: "col4"},
            ],
            dataModel: {
                data: data
            }
        };
        $("#grid_json").pqGrid(obj);
    });   

That happens when one of columns is empty.


In case of MS Excel (screenshot 2) there will be a correct sum of existing values in columns.

Thank you in advance.

Sincerely

5

Bug Report / Error in formula parsing

« on: October 22, 2021, 03:35:38 pm »

Hello,

There is an important and quite weird bug giving an error if there is a specific string ("F" and probably others?):

Code: [Select]

var data = [
    { col1: "S", col2: null, col3: null, col4: null,           
        pq_fn: {                     
                col2: 'IF(A1="S", 1, 0)',// OK
                col3: 'IF(A1="F", 2, 0)',// NOT OK . Returns: Unexpected token ')'
                col4: 'IF(A1="f", 3, 0)',// OK
        }
    }
];

Here is a link to jsFiddle:
https://jsfiddle.net/93pe4n7v/

Thank you in advance.

Sincerely

6

Bug Report / Re: Excel Formula with JSFormula combining returns a wrong result

« on: June 16, 2021, 12:45:08 pm »

Thank you. However, if such a combination is not possible, this should be clearly stated in the documentation. Otherwise it's a bug

7

Bug Report / Excel Formula with JSFormula combining returns a wrong result

« on: June 16, 2021, 11:54:38 am »

Hello,

Here is an example: https://jsfiddle.net/obpLsg81/8/

Last version is used for this example, however problem is present in previous versions, also.

Column 4 is calculated with JS Formula has to take a calculated value from column 3, but does not see it
Column 5 is same, but is calculated with Excel Formula and works fine.

That seems to be a problem of the fixed order/priority of calculation.

We are not confusing but combining both types of formulas, so this is an important bug in calculation.

Thank you in advance

8

Bug Report / Re: Select editor does not update mapped field when drag or paste

« on: January 22, 2021, 03:17:48 pm »

Neither it's a feature Using formulas looks like workaround while having such a good idea to use mapIndices.

Thanks a lot for reply! Please add information about this limitation to documentation, because that was not obvious and could lead to invisible errors (like in example with a hidden field).

9

Bug Report / Paramquery breaks JQueryUI Dialog functionality

« on: January 19, 2021, 10:22:34 pm »

Hello,

Here are two jsfiddle links that show that jQuery UI Dialog buttons are not shown if pqgrid.min.js is included.
Please, click on "showInterfaceSettings" to see dialog.

https://jsfiddle.net/bs9n2qgL/


https://jsfiddle.net/gfpvz1tL/


Thank you in advance

10

Bug Report / Select editor does not update mapped field when drag or paste

« on: January 19, 2021, 09:52:29 pm »

Hello,

You can see in the animated GIF behavior of the editor and its mapped field:

Code: [Select]

mapIndices: { "text": "ShipVia", "value": "ShipViaId" },


This is easily reproductible on the original page: https://paramquery.com/pro/demos/editing_custom
Please make mapped field visible:

Code: [Select]

{ dataIndx: 'ShipViaId', hidden: false} , //hidden column to store ShipVia Id.
Thank you in advance

11

Bug Report / Re: CONCATENATE formula bug

« on: September 07, 2020, 09:32:52 pm »

In previous version 7.2 this bug does not exist

Live test for 7.3: https://jsfiddle.net/sm34nk5r/1/

You can change version in script link to 7.2 and you will see that in 7.2 it works correctly.

12

Bug Report / CONCATENATE formula bug

« on: September 03, 2020, 04:18:33 pm »

Hello,

Formula has invalid result for a "string" dataType columns with a zero-filled 'number' value.

Example code:

Code: [Select]

   
$(function () {
        var data = [
            {column1: '001', column2: 'AAA', column3: '', pq_fn: { column3: 'CONCATENATE(A1,B1)'} }
];

        var obj = {
            scrollModel: {autoFit: true},           
            colModel: [
                { title: "column1", width: 100, dataType: "string", dataIndx: "column1" },
                { title: "column2", width: 100, dataType: "string", dataIndx: "column2" },
                { title: "column3", width: 100, dataType: "string", dataIndx: "column3" }
            ],
            dataModel: {
                data: data
            }
        };
        $("#grid_row_styles").pqGrid(obj);
    });   

Both source columns are "string" type.
Result is "1AAA" instead of "001AAA".

Thank you in advance.