Messages

1

Help for ParamQuery Pro / Re: Dynamically change the dataType of the column after adding new column???

« on: May 11, 2020, 01:09:58 pm »

i got it, this code can be done from backend but in spreadsheet/worksheet how can i select the column and have options to change the datatypes?

2

Help for ParamQuery Pro / Dynamically change the dataType of the column after adding new column???

« on: May 11, 2020, 09:47:56 am »

I added a new column which is on string by default, so I need to change one of the columns to date format and other to the integer format from the front-end view, is there any functions on toolbar which can be used to dynamically change the data type of the column after its been created?

3

Bug Report / Re: Help on Changing Data type

« on: May 08, 2020, 04:24:52 pm »

A  B     total
5  100   5100
for eg:
=sum(A1+B1) formula on total column shows 5100 instead of 105(which concats the value instead of adding)

(here my dataType is string)

4

Help for ParamQuery Pro / How can we define the dataType for specific rows in a column????

« on: May 08, 2020, 01:58:53 pm »

The code i have posted here gives the whole column datatype float but i need the dataType for specific rows(for eg: i want string datatype upto row[7] and float datatype for rows greater than 7)

for (var i = 0; i < cols; i++) {
   colModel = { title: toLetter(i), width: 150, minWidth: 50, dataType: 'float' };
}

Any suggestions?
Thanks in advance

5

Bug Report / Help on Changing Data type

« on: May 08, 2020, 01:25:10 pm »

is it possible to add the right click option to change the specific column data type or each cell data type??? for eg: dataType:"string" to dataType: "integer"
Because i am not getting =SUM(A1+B1) in column with dataType equals to "string"

6

Help for ParamQuery Pro / Re: Help!!! For right click on mac

« on: May 07, 2020, 02:22:02 pm »

Hi there,

Further to this, it seems that this is the current behaviour on a MAC

CTRL + tap trackpad inside a cell: activates chrome right click but not the param query context menu
Command + tap trackpad inside a cell: allows the user to select multiple cells
Secondary right click on a cell: activates the context menu in param query.

Is it possible to have the keybinding CTRL + tap trackpad inside a cell to activate the context menu for Mac?

7

Help for ParamQuery Pro / Prevent double click

« on: May 07, 2020, 01:15:14 pm »

How to prevent double click on the black piointer right down of the cell? ref attached image below

8

Help for ParamQuery Pro / Help!!! For right click on mac

« on: May 07, 2020, 12:58:17 pm »

 when i tried to do right click on mac its not working, i need to show add column on right click but it is showing back, ref attached photos
(I pressed ctrl+trackpad click to do right click on mac)
Any solutions?

9

Help for ParamQuery Pro / Incorrect Column formula update while adding the new column

« on: May 04, 2020, 03:07:18 pm »

Case 1:
I have a excel grid A to E, i added formula on column D as =SUM(A3+C3), now when i add new column in between A and B , the formula cell D is shifted to E and formula on it is changed to =SUM(B3+D3), which should have been =sum(A3+D3), can anyone suggest the solution,
Case 2:: i have A to E excel grid and formula cell is on E as =sum(A1+C1), now when i add column after C, then again the formula cell(E) shifted to F and formula changes to =sum(B1+D1) which should not have been changed as new column was added after the cells used on formula
(Seems like its same on demo examples as well, isnt that wrong?)