FlexSheet - SUM Formula Problems

FlexSheet - SUM Formula Problems

Posted by: jason+wijmo on 2 July 2018, 3:04 pm EST

• 

  jason+wijmo

  • Post Options:
  • Link
    Copy

  Posted 2 July 2018, 3:04 pm EST

  Major Issue #1: Moving Rows Replaces Other Row Formulas

  Issue #1: Using the Shift + Move and Ctrl + Move a row is affecting the forumlas in other rows that are not tied to the affceted row. Please see the attached video for a screencasted example. Other rows that are not related should not be affected.

  Video of issue (I am also attaching video to this support ticket):
  
  https://drive.google.com/file/d/1Ei8BbWJxg7SZxASMnrqeQC1pKZN9FWnc/view

  Major Issue #2: Vertical Totaling/Summing Issue

  Step 1 - Proceed to: http://demos.wijmo.com/5/angular/FlexSheetExplorer/FlexSheetExplorer/#/

  Step 2 - Fill the following values manually: A1: 1, A2: 2, A3: 3, A4: =SUM(A1:A3) or a value of 6

  Step 3 - Insert a new row between A3 and A4. A3 will remain as value 3, A4 will become empty, and A5 will be the formula.

  Step 4 - In cell A4, type in 4.

  Issue #1 - It is expected that cell A5 would be updated automatically from value of 6 to 10. In both Microsoft Excel and Google Sheets, the formula of =SUM(A1:A3) would auto adjust to =SUM(A1:A4) when inserting a new row at the BOTTOM of the formula. Wijmo FlexSheets’s formula remains as =SUM(A1:A3), which is incorrect. Wijmo FlexSheet works fine if the inserted row is inserted in the middle rows.

  Issue #2 - Repeat scenarios above but insert a row above A1 to produce the same issue, but on the TOP of the formula.

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 3 July 2018, 7:28 am EST

  Hi,
  
  Thank you for reporting these issues. We are able to replicate both the issues and these have been forwarded to the concerned team with tracking id 331353 and 331355.
  
  We will update as we get an update on this.

  ~Manish

• 

  jason+wijmo

  • Post Options:
  • Link
    Copy

  Posted 6 July 2018, 9:10 am EST

  Thank you Manish. Any updates on the issues? This is pretty urgent on our side and the broken functionality is holding up our development. We also have Case Tracking ID 331131 open for it.

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 9 July 2018, 6:17 am EST

  Hi Piyush,
  
  We are sorry for the inconvenience.
  
  This issue is with the development team. We can’t share any ETA for this issue fix.

  ~Manish