Messages

1

Help for ParamQuery Grid (free version) / Re: Filter rules to highlight cell(s) text without filtering the data

« on: May 13, 2022, 06:04:04 pm »

I managed to do it with the filter on:false...

Looks like it didn't work before because I had a typo on my code.

2

Help for ParamQuery Grid (free version) / Filter rules to highlight cell(s) text without filtering the data

« on: May 11, 2022, 04:58:41 pm »

Hello,

Is there any already implemented method which allows us to search and highlight texts (just like CTRL+F) but with filter rules?
I have been trying to do this but without success, the only way I managed to do something similar was by filtering the data and applying the highlight style with a custom FilterRender (I found it in a demo).

The issue is that I want to continue to show all data while highlighting the text or rule(s) being searched.

Thank you in advance and sorry for any inconvenience

3

Help for ParamQuery Pro / Number Formating / compacting

« on: May 26, 2020, 09:57:34 pm »

When i try to insert a large number it compacts the number leaving only a "8.40102e+011" for example, is there a way i can display the whole number?

4

Bug Report / Re: Error "AA1 is not defined"

« on: December 02, 2019, 09:05:19 pm »

yes ,

I am sending 2 screenshots with the formula and the result in the DEMO

5

Bug Report / Error "AA1 is not defined"

« on: December 02, 2019, 05:47:12 pm »

Hello,

when I copy de formula "=Z1" in the AA1 Cell to the right , the formula assumes the formula "=AA1" but instead of showing the value , shows the error "AA1 in not defined"

In a function, when we need to use a cell in  of the column AA or AB for  example ,   what syntax should we use?

Thanks

Pedro - Altyra Solutions

6

Help for ParamQuery Pro / Re: Insert date with the format "dd-mm-yyyy"

« on: November 28, 2019, 08:53:06 pm »

When i click to edit the cell it displays the date as "mm-dd-yy" and i want to change it to the format "dd-mm-yy", and when i submit the changes to the cell transform it back in to the format "mm-dd-yy" so that it can be recognized by the grid as a valid date.

I am thinking of using the functions beforeFillHandle (to display) and cellBeforeSave (to save) to achieve these results, but i am having trouble applying them, could you send me an example or should i use other functions?

Thak you for your time once again.

7

Help for ParamQuery Pro / Re: Insert date with the format "dd-mm-yyyy"

« on: November 28, 2019, 03:06:09 pm »

Now my code looks like this and works perfectly

Code: [Select]

beforePaste: function (evt, ui) {
                        //sanitize pasted data.
                        var CM = this.getColModel(),
                            rows = ui.rows,
                            area = ui.areas[0],
                            c1 = area.c1;
                        for (var i = 0; i < rows.length; i++) {
                            var row = rows[i];
                            for (var j = 0; j < row.length; j++) {
                                var column = CM[j + c1],
                                    dt = column.dataType;
                                if (dt == "date") {
                                    var $m = row[j].match(/^(\d+)-(\d+)-(\d+)$/);
                                    var $new = $m[2] + "-" + $m[1] + "-" + $m[3];
                                    row[j] = $new;
                                }
                            }
                        }
                    },
But i have one last question, is there a way to do the same but with the cell click and cell submit?

8

Help for ParamQuery Pro / Re: Export only visible columns

« on: November 26, 2019, 11:30:17 pm »

The copy : false argument is only hiding the header of the column but not the data itself.

Thank you for your time

9

Help for ParamQuery Pro / Re: Insert date with the format "dd-mm-yyyy"

« on: November 26, 2019, 07:44:20 pm »

But the main problem is that i cant even introduce the date with the format "dd-mm-yyyy" it automatically clears out my text, in my context i need to copy/past a larger portion of data into my paramquery.

Thank you for your time

10

Help for ParamQuery Pro / Export only visible columns

« on: November 25, 2019, 09:20:14 pm »

Hi,
How can i export only visible columns?

Thank you for your time

11

Help for ParamQuery Pro / Insert date with the format "dd-mm-yyyy"

« on: November 22, 2019, 10:22:26 pm »

Hi,

I have an issue, i need to introduce the date in my paramquery with the format "dd-mm-yyyy", but the only solutions i am finding are to change the date from "mm-dd-yyyy" to "dd-mm-yyyy" and everytime i try to put "dd-mm-yyyy" it clears my text, is there anyway that i can introduce the format that i want from the start?

Thamk you for your time

12

Help for ParamQuery Pro / Block users from adding new rows by copy and pasting data.

« on: October 25, 2019, 05:36:13 pm »

I am  having  a problem, is there anyway to block the user from adding new rows if they copy and paste a number of rows greater then a i already have in the table itself. For example if i have 8 rows and the user adds 12 from an external excel i want to still only have 8 rows.

Thank you for time