Author Topic: Deleting column causes formulas to stop working  (Read 811 times)

wd_perf

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 26
    • View Profile
Deleting column causes formulas to stop working
« on: August 27, 2022, 12:21:31 am »
ParamQuery Pro 8.5.0 and earlier versions, at least since 8.3.0.

Steps to replicate:
1) Go to https://paramquery.com/pro/demos/context_menu
2) Enter a formula in a cell [like "=1+1" in cell A1]
3) Delete the column where the formula was entered [use context menu on cell A1 to delete column]
4) Enter a formula that references another cell [like in cell A1 enter "=D4" and press Enter]

Note, formula does not work and error in console. Cannot get any new formula to work.

Thank you.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Deleting column causes formulas to stop working
« Reply #1 on: August 29, 2022, 05:26:57 am »
Thanks, this has been fixed in upcoming v8.6.0

wd_perf

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 26
    • View Profile
Re: Deleting column causes formulas to stop working
« Reply #2 on: September 02, 2022, 05:12:37 am »
Thank you! In the mean time, is there any chance you could provide a patch to fix the issue? I've been trying to fix it myself, but no luck so far.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Deleting column causes formulas to stop working
« Reply #3 on: September 05, 2022, 09:08:22 pm »
v8.6.0 has been released.