Messages

1

ParamQuery Pro Evaluation Support / excel import with formula

« on: August 12, 2024, 01:31:15 pm »

Hello,

I want to import excel with formula, how to import the sheet with formula, right now when i try to import excel with formula its cell data changes.

2

ParamQuery Pro Evaluation Support / Re: How to select multiple cell value in excel grid

« on: July 19, 2024, 05:13:57 pm »

i want this selected cell values on double click event in cellDblClick function, with given method when in double click after selecting multiple cell it gets unselected.

3

ParamQuery Pro Evaluation Support / How to select multiple cell value in excel grid

« on: July 12, 2024, 05:58:37 pm »

Hello,
I want to get multiple cell value from an excel as shown in the picture, I can currently get only single cell value.

4

ParamQuery Pro Evaluation Support / Get cell data form dynamic table

« on: May 16, 2024, 01:48:24 pm »

i want to get selected call data and pqgrid's  method ( pq.grid("#tree_grid").Selection().address()) only gives cell number c1:2 c2:2 cc:1 firstC:2 firstR:10 r1:10 r2:10 rc:1 type:"cell"    and my table has dynamic column and  it not possible to get data by this method

5

Help for ParamQuery Pro / Re: Reactjs server side pagination issue

« on: February 01, 2023, 04:47:52 pm »

Hello,

Thanks for reply,

I try to pass reactive: false to the grid options and try other options  but server-side pagination not working in reactjs

Please provide any stackblitz link  to reactjs with pqgrid server-side pagination example 

6

Help for ParamQuery Pro / Reactjs server side pagination issue

« on: January 31, 2023, 05:47:21 pm »

Hello Team,

I am using server-side pagination in the PQ grid with reactjs. when i click next button (pagination) getting error 
Uncaught TypeError: Cannot read properties of undefined (reading 'bind')


refer this link : https://paramquery.com/pro/api#method-refreshCM

please let as know how to solve issue in reactjs

 

7

Help for ParamQuery Pro / PQGrid implement reactjs

« on: January 30, 2023, 04:47:43 pm »

Hello,

we are implement PQGrid in reactjs, data get properly in pqgrid but top view in message showing paramquery pro eval

we have already licence Pro Ultimate

Reactjs in following steps -
1.  install pqgrid
2.  download the commercial copy in npm modules then clear cache
     but not remove  paramquery pro eval

Please let us know, how to resolve issue

8

Help for ParamQuery Pro / Excel Values Display Wrong

« on: September 14, 2022, 05:13:08 pm »

Dear Team,
we bind our excel sheet using pqgrid but Some of the values display wrong. Please find the excel file from the URL.

Steps to Reproduce Issue
1.  Click On Balance Sheet Tab
2. Search (ii) Other Financial Assets.
3. In the original file you can see 1313.40 on the right side table and on the web wrong values display 0.00

URL: http://powergst.microvistatech.com/BalanceSheet.xlsx

9

Help for ParamQuery Pro / Get Selected Value

« on: July 15, 2022, 12:38:16 pm »

Dear Team,
How to get the selected value from pqgrid

10

Help for ParamQuery Pro / Excel Sheet Tab Automatically closed if too many Tabs In Excel

« on: July 09, 2022, 03:44:12 pm »

Dear Team,
If we use Excel Sheet with Multiple tabs it then all tabs hide automatically after some activity in pqgrid excel sheet.

11

Help for ParamQuery Pro / Unload Excel File

« on: July 07, 2022, 06:18:28 pm »

Dear Team,
Is there any way to unload the excel file from importWb?

12

Help for ParamQuery Pro / Copy From Excel On Sheet2 not working

« on: July 07, 2022, 12:53:00 pm »

Dear Team,
We try to copy from sheet 2 but we always get the value of sheet 1. We write the below code to copy from 1 grid and paste it to another grid. Is there any alternate way to achieve this? Also if we copy a value from sheet 2 and copy this value to the clipboard then it works fine in local but not in production.


var $grid = $('#spreadsheet').closest(".pq-grid");
 $grid.pqGrid("copy");

var $grid1 = $('#tree_grid').closest(".pq-grid");
$grid1.pqGrid("paste");

13

Help for ParamQuery Pro / Add Loader While Loading FIle

« on: July 06, 2022, 11:40:49 am »

Dear Team,
Is there any way to add a loader while loading the excel file? if we upload a large file then it takes some time so we want to add a loader while uploading an excel file.

14

Help for ParamQuery Pro / Remove Delete Excel sheet Tab Option

« on: July 06, 2022, 10:47:55 am »

Dear Team,
How to remove or hide the Excel sheet Delete Tab (X) Icon?

15

Help for ParamQuery Pro / Get Excel Sheet Tab Number

« on: July 05, 2022, 12:36:10 pm »

Dear Team,
How to Get Excel Sheet Tab Number On CellDBClick Event or any event.