Messages

1

Help for ParamQuery Pro / Vertical align the index column.

« on: September 25, 2020, 01:51:48 pm »

Hi,

I was wondering if there is a way of vertical align the number of index column(first column).
The row height might change.

https://stackblitz.com/edit/paramquery-demo-numbercol

In the demo, you can see the numbers of first column is aligned to top.

2

Help for ParamQuery Pro / Export to excel with no frozen rows.

« on: September 22, 2020, 09:21:37 am »

Hi,

  I want to export data to excel sheet with no frozen rows.
  https://stackblitz.com/edit/paramquery-demo-ndv8i4?file=index.js

  I have put an example in the above link.
  I tried to change the frozenRows to 0 when "workbookReady" event is triggered, and as I open the excel file, I get the error message of wrong format.
  I think there should an exception for 0 frozenRow.

Or is there a way to use frozenRows=0 when exporting to excel?

3

Help for ParamQuery Pro / Re: Horizontal scroll shows differently when using frozen column

« on: August 26, 2020, 07:19:36 am »

I tested on Windows 10, Chrome browser 85.0.4183.83, maximized the chrome browser.

Only occurs at the first time.

4

Help for ParamQuery Pro / Horizontal scroll shows differently when using frozen column

« on: August 25, 2020, 08:34:58 am »

Hi,
I think I posted the same topic falsely before, so I post this topic again.

Please refer to this example.
https://stackblitz.com/edit/paramquery-demo-ds4bmk?file=index.js

And then open a new web site for this url.
https://paramquery-demo-ds4bmk.stackblitz.io

I'm testing with 24inch dell monitor, with a resolution of 1920x1080.
Please see the attached image, and you can see that the scroll bar is hidden behind the frozen columns. This happens only when seeing in full screen, and using toolbars.
When I click 'Default layout', the scroll bar is shown normally again. So I assume that this happens only when the grid is initialized. Could you please check this?

5

Help for ParamQuery Pro / Give style when exporting to excel file.

« on: August 12, 2020, 05:24:20 pm »

Hi,

I want to give border styles to excel cells when exporting.

https://stackblitz.com/edit/paramquery-demo-6cvpfg?file=index.js
This is my example. I want to give styles when "worksheetReady()" is triggered, while not giving styles to the colModel, as in line 77.
I want to give border-bottom style to workbook.sheets[0].columns but it won't work. It only works when I give styles in colModel.
Is there a way to use worksheetReady to give specific cell styles?

6

Help for ParamQuery Pro / Export to one excel file from multi grids.

« on: July 16, 2020, 05:44:25 am »

Is there a way to export data from two grids to one excel sheet?

In the excel sheet, first grid's header and data are shown at top, and the second grid's header and data are shown right below them separated by one or two rows. Is this possible?

7

Help for ParamQuery Pro / Hide column that is used for group title when using groupModel

« on: July 01, 2020, 01:25:12 pm »

Hi,

Is there a way to not show the title column when using groupModel, but only show as the group title?

For example, there are column A, B, C, D, and I grouped with A. And I don't want to show the A column, but the title row that can be collapsed should be shown with A title.

8

Help for ParamQuery Pro / Move focus to a certain row's dataIndx by a method.

« on: February 18, 2020, 02:51:57 pm »

Hello param,

I want to activate an editable cell by giving focus through a method.
The column is already editable, and the cell is editable by clicking it, but is there a way to do it by a certain method?

Thank you.

9

Help for ParamQuery Pro / Independant style when export to excel.

« on: January 31, 2020, 04:42:26 pm »

Hello param,

I am working on exporting data to Excel 2010.
I am looking for a way to apply different style to the excel that is different from the grid.
For example, my font size is 12px in the actual grid, but I want to change it to 9px in the excel.  I tried giving font size before exporting, and it works fine in the excel, but I found out that my original grid's font size is also changed to 9px when row is refreshed by scrolling.

1. So, I want to ask if there is a way only affecting style for the excel, and not affect the original grid style.

2. Another questions is, when I apply border to cell when exporting to the excel, it seems it is not compatible with Excel 2010 version. Is there a version limit to use border option?

I'm testing with version 7.1.0. Thank you.

10

Help for ParamQuery Pro / Only make checkbox header editable.

« on: January 29, 2020, 01:23:01 pm »

Hello param,

I have a column of checkbox. And the checkbox is shown in header.
The entire column is not editable by default. But I only want the header checkbox to be able to check.
And when header is checked, I want to get callback by an event, so I could update certain data.

Thank you.

11

Help for ParamQuery Pro / Freeze the entire grid option.

« on: January 29, 2020, 12:05:53 pm »

Hello param,

I wonder if there is a method for freezing the entire grid?
When this method is called, the grid is shown as disabled, and user won't be able to move the scrolls or select element in the grid.

If there is such a method or an option, please let me know.

12

Help for ParamQuery Pro / Not using title in group model

« on: January 13, 2020, 08:26:55 pm »

Is there a way to not use title in group summary?

I want only to show sum data in the bottom of each group, and not use or show title & collapse.

Is there an option or method for it?

13

Help for ParamQuery Pro / Horizontal scroll position

« on: December 18, 2019, 02:15:37 pm »

Hello param,

When I use row grouping to display sum data at the bottom, the horizontal scroll is located between the body part and sum data part.
Is there a way to make the horizontal scroll displayed at the bottom of the sum data area?

I've used the demo "Row Grouping" -> "Excel formulas" and added width 400 in the option.

14

Help for ParamQuery Pro / Display icon or image of calendar and combo

« on: November 29, 2019, 01:46:19 pm »

Hello param,

Is there a way to display icons or images of calendar and combo cells?
Currently, user can only notice the calendar or combo by double clicking the cell.
I want to display icon on the right side the data, like yyyy-mm-dd (icon) so the user can notice the cell will show calendar when clicking on it.

Thank you

15

Help for ParamQuery Pro / Column resize when width % is designated.

« on: October 18, 2019, 11:14:20 am »

Hello,

https://paramquery.com/pro/demos/fluid_window
In this demo, I am not able to resize the column by mouse moving when each column's width is set width %.

I need to set the column with %, and also need to resize the column.
Is there any way to do so?