❗ “Add Row” and “Add Column” Actions Insert in Incorrect Location in Aspose GridJS & Unfreeze Cell Not Reflected in Saved Copy After JSON Merge in Aspose GridJS

Aspose.Cells Product Family
73

@amjad.sahi

Can you please check this issue?

When I cut a cell value, the client-side event

}).on('cells-deleted', (range) => {

is triggered correctly.

However, when I paste the value, the Update event is not triggered on the client side.
It seems the paste action does not raise any corresponding update event.

Could you please verify this behavior?

74

I have encountered an issue with formula cells:

When a formula is applied to a cell and I change the cell value, it calculates correctly. However, when I use Ctrl + Z (Undo), the cell value does not update as expected.

GRIDJS.gif (120.1 KB)

Could you please check this behavior?

Thank you

75

@chirags,

We will evaluate the issue thoroughly and get back to you soon.

Thanks for the image file and details.

I reproduced the issue using the online editor app (created by Aspose.Cells.GridJs). I found when a formula is applied to a cell and I change the cell value, it calculates correctly. However, when I use Ctrl + Z (Undo), the formula cell value does not get updated as expected.

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): CELLSGRIDJS-1983

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

76

Thank you for your support so far.

Could you please let me know if there’s any update or findings regarding the issue where Update event is not triggered on the client side ?

Looking forward to your response.

Thank you,

77

Hi @amjad.sahi ,

I noticed an issue when using the search popup:

  • When searching for a term, the result is found, but the screen does not navigate or scroll to the matched value.
  • I tested this on the Aspose.Cells demo site.
  • This issue occurs particularly when the file contains a large amount of data — the match is located, but the view does not scroll to that location.

Could you please check this behavior?

Thank you,

78

@chirags,

We are investigating your issue. We have also 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): CELLSGRIDJS-1984 - The Update event is not triggered on the client side

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

79

@chirags,

I tested your scenario using the online editor app (developed by Aspose.Cells.GridJs) with a relatively large file, but I was unable to reproduce the issue. Could you kindly compress the sample Excel file into a zip and attach it along with some screenshots to illustrate the problem? We will check it soon.

80

@chirags

QQ截图20251009174534.png1722×866 19.3 KB
QQ截图20251009174534.png (19.3 KB)

When the cell K3 value is updated, the related cells are updated, this is the expected behavior. In our calculation engine, we find those other 8 cells values are triggered by the change of cell K3 for the first time. Moreover, for cell K3 itself, there are 9 cells values got updated. But when you do update again, set cell K3 value to be 100, for example, it will not trigger the update of other cells. I think this is an internal behavior. For example, the calculation engine may need to check calculation dependencies or perform some initialization.

81

@chirags
I think your suggestion is fine.
We may improve this behavior.
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 : CELLSGRIDJS-1986 DatePicker default value always shows 7th of the month instead of the selected cell value

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

82

Thank you for your support.

However, in this case, there is no cell update, so I’m not sure why the event is triggering the first time.
This issue seems to occur only with this specific file (or possibly one other similar file), while it works fine with all other files.

Also, you mentioned the status as “Won’t Fix.” CELLSGRIDJS-1977
Could you please clarify — does this mean the issue will not be fixed in any future version, or it might be addressed in an upcoming release?

Thank you,

83

I noticed an issue in read-only mode:

  • The application allows me to insert a comment.
  • It also permits changing the style of cells.

Could you please check this behavior? It seems unexpected that these actions are allowed in read-only mode.

Thank you,

85

@chirags,

I tested your scenario to some extent. I manually created an Excel file with a protected sheet in MS Excel and then opened it in the online editor app (developed by Aspose.Cells.GridJs). It functioned as expected. I was unable to add comments or modify the cell formatting in the worksheet. Could you please provide more details on the issue, along with a sample Excel file and some screenshots, so we can reproduce the issue on our end? We will review it soon.

86

Yes,we don’t think it is an issue.we will not fix it.

87

@chirags
if you mean the client settings : mode:read
you still find the format and comment operation can performed through menus .
you may remove those menu items as in our online viewer demo app:

here is a document guide for you to customize menus

88

Yes, if I open the file in read mode, it still allows me to perform certain actions.

I have already hidden these options from the menu, but when I right-click on a cell, it still shows the Comment and Cell Format options. In this case, I can change the cell formatting or even modify the background color while in read mode.

Additionally, if I perform a server-side save, the file still gets saved with those changes, even though it’s opened in read-only mode.

Could you please check this behavior? It seems that some editing actions are still enabled in read mode.

Thank you,

89

I have found a couple of issues while loading my file into Aspose.GridJS:

  1. Cell Style / Background Color Not Preserved
  • In Excel, some cells have a blue background color.
  • After loading the file into Aspose.GridJS, the background color is not displayed.
  • I have attached the file and a screenshot for reference.
  1. Chart Loading in Wrong Sheet
  • I have a chart located in the Summary sheet in Excel.
  • After loading the same file into Aspose.GridJS, the chart appears in the Sales Data sheet instead of the Summary sheet.

image.png1352×482 87.5 KB
image.png (87.5 KB)
image.png1200×768 35.7 KB
image.png (35.7 KB)
large_sales_dataset.zip (2.3 MB)

Could you please check these issues?

Thank you,

90

@chirags
We can observe this issue.
We may improve this behavior.
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 : CELLSGRIDJS-1987 Comment and Cell Format are still enabled in read mode

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

91

@chirags
by using your sample file,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 : CELLSGRIDJS-1988 Background color is not preserved

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

92

for this issue ,We can not reproduce .

QQ截图20251010150820.png1398×780 48.2 KB
QQ截图20251010150820.png (48.2 KB)
can you show us the detail steps.

however ,we can see the color in the chart is not same as in MS-Excel.

QQ截图20251010151140.png1019×659 24.5 KB
QQ截图20251010151140.png (24.5 KB)
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 : CELLSGRIDJS-1989 Chart bar colors are incorrect

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

93

I am trying to apply the FREQUENCY formula. It works, but the output is not the same as in Excel.

In Excel, the FREQUENCY formula generates multiple values across a range of cells, but in Aspose, it is generating the entire output in a single cell instead.

I have attached a screenshot for your reference.

image.png2136×759 53.6 KB
image.png (53.6 KB)

Could you please check this behavior?

Thank you,