Author Topic: Formula in writable columns  (Read 413 times)

satyaprakashsp

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 2
    • View Profile
Formula in writable columns
« on: December 05, 2022, 01:12:15 pm »
Hi

I have 2 columns in my grid, in which 1st column is a read-only numeric column, while the 2nd column is an input column where the user has to provide their input based upon the 1st column data within the same row.

My question is, is there any way to enter the cell value with a simple formula like (the previous cell value * 0.3) and then drag the cell to the below cells to copy the same calculations in the below cells.

I am using ParamQuery Pro v8.6.0

Thanks in advance for your quick response.

Best regards
Satya

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Formula in writable columns
« Reply #1 on: December 05, 2022, 03:17:48 pm »
Enter the formula =A1*0.3 in second column of 1st row and drag it down.

satyaprakashsp

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 2
    • View Profile
Re: Formula in writable columns
« Reply #2 on: December 15, 2022, 12:08:24 pm »
Thank you, that solves the formula issue.

However, there are 2 more issues with the drag of the selected cells.

Extending on the old structure, I have put 5 columns, the 3rd and 5th columns are set as noneditable by setting "paste: false"
the first column has a drop-down list, the second column has a text input 3rd is a not editable column and 4th one is one with a formula based on 5th column value, In this setup, I face 2 issues

1) In the case of; after filling the 1st row and then selecting the 1st four columns; when I drag the selection to the next row, the fourth column value(that has formula) is pasted as null in the 2nd row

2) In case I move the 3rd column to the end(aligning the editable columns to be 1st 3 columns) and then select the first 3 editable columns the formula is not copied in the 3rd column, instead it copies the value of the previous row's 3rd column in the 2nd row

Is there any way to control these behaviours when selecting multiple columns and dragging them to the next row?

I have attached an image to make it more descriptive.

Best regards
Satya

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Formula in writable columns
« Reply #3 on: December 16, 2022, 06:07:39 am »
Please share a jsfiddle to fully understand the issue and find a solution.