Formula not refreshed and collaborative editing

Aspose.Cells Product Family
1
  1. Gridjs inserts a line, but the formula on the page has not been updated,
    For example, the formula SUM (A1: A2) in cell B2, when I insert a line in the first row, the original B2 becomes C2, but the displayed formula is still SUM (A1: A2), and the backend Excel has changed to SUM (B1: B2). Is this a bug or do I need to handle it
  2. How to achieve collaborative editing among multiple people in Gridjs, do you have any solutions or examples
    1.jpg (20.1 KB)
2

@feng.qun.zhu.avaryholding.com

Can you please provide more details about the specific version of Gridjs you are using and the environment in which you are experiencing these issues?

3

@feng.qun.zhu.avaryholding.com

  1. We can reproduce this issue.
    We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

    Issue ID(s): CELLSNET-56467

  2. We will update the java demo to show how to generate the permanent url for editing on a file

    Issue ID(s):CELLSGRIDJS-1328

4

@feng.qun.zhu.avaryholding.com

Please update to the latest demo
after start the application,
open browser and navigate to view view all the files in the directory at http://localhost:8080/gridjsdemo/list
then click one of the file, it will open the file in the new tab,you can see it url ends with uid=xxxxx
thus when another user copy and navigate this url, it just work with the same file.
this way we can achieve collaborative editing among multiple people.