calx.js icon indicating copy to clipboard operation
calx.js copied to clipboard

Published 20 hours ago • verified publisher icon xsanisty

Dynamic Range calc from one sheet to another sheet

Open srikanthj09 opened this issue 9 years ago • 4 comments

HI, I am trying to implement.Sum Logic. Eg: 2 Sheets (Sheet1 & Sheet2) Sheet1: Dynamic Table which will have rows inserted. Sheet2: Constant Table Both are working fine. Problem: Sheet2 needs an Sum value from Sheet1 colA.

  1. Sum(#Sheet2:ColA1:ColA10) this is constant
  2. where Sheet1 is Dynamic so every time when i add new row to the sheet1 then i need to change the formula of sheet2.

My request is can we have logic which even excel has like Sum(#Sheet2:ColA:ColA) which will consider entire column and sums. It will helps in lots of workaround externally. Even we can pull data from multiple sheets dynamically.

srikanthj09 avatar Jul 18 '15 15:07 srikanthj09

Hi @srikanthj09

I think this will be great addition, I will try to implement this feature.

regards Ikhsan

ikhsan017 avatar Jul 19 '15 02:07 ikhsan017

I think I will be working on this feature in near future, maybe this weekend, and just noticed there is some problem in multi sheet implementation when the sheet is inter-dependent. will try to fix that too

ikhsan017 avatar Nov 12 '15 03:11 ikhsan017

Any advance on this feature?

persuader avatar Dec 09 '15 10:12 persuader

the formula parser already updated to support dynamic range, need to implement the logic to keep cell that has dynamic range formula keep updated if the range size is modified

ikhsan017 avatar Dec 09 '15 10:12 ikhsan017