« previous next »
Pages: [1]

Author Topic: How to calculate and fill in values in other cells when a cell finished editiong  (Read 3444 times)

lsl

  • Pro Deluxe
  • Jr. Member
  • *
  • Posts: 67
    • View Profile
How to calculate and fill in values in other cells when a cell finished editiong
« on: September 18, 2014, 09:32:50 am »
I want to fill in the column "Each" after users finished editing No. of Packages (pic1)

formula: Each = QTY/Packages

how should i do?
« Last Edit: September 18, 2014, 09:34:42 am by lsl »
Logged

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6298
    • View Profile
Re: How to calculate and fill in values in other cells when a cell finished editiong
« Reply #1 on: September 18, 2014, 01:33:35 pm »
Logged

lsl

  • Pro Deluxe
  • Jr. Member
  • *
  • Posts: 67
    • View Profile
Re: How to calculate and fill in values in other cells when a cell finished editiong
« Reply #2 on: September 18, 2014, 01:45:44 pm »
there are 2 problems using "render"
1. we need the result to be filled in "Each" field before the changes are committed to DB
2. we already have render functions which doing number formatting in that column.

Logged

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6298
    • View Profile
Re: How to calculate and fill in values in other cells when a cell finished editiong
« Reply #3 on: September 18, 2014, 02:07:05 pm »
make changes in the rowData in cellSave event

ui.rowData["Each"] = calculated value;

and

call refreshCell( {dataIndx: 'Each', rowIndx : ui.rowIndx}) after that.
« Last Edit: September 18, 2014, 02:14:45 pm by paramquery »
Logged
Pages: [1]
« previous next »