❗ “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

chirags · October 7, 2025, 10:41am

I have one more observation regarding the “Show Formulas” feature.

When I enable the Show Formulas option, the cells that do not contain any formulas are being hidden automatically.
Is this the expected functionality, or could this be a bug?

Ideally, in Microsoft Excel, when we enable “Show Formulas,” it displays all cells — formula cells show the formula text, and non-formula cells continue to show their normal values.
However, in my case, only the formula cells remain visible, and other cells without formulas are hidden.

Could you please confirm whether this behavior is intentional or if it requires a fix?

Thank you for your help.

amjad.sahi · October 7, 2025, 11:14am

@chirags,

chirags:

On the client side, all controls display properly, and the save process is triggered using the functions getUpdateDatas() and mergeJsonData.
However, when the data reaches the server, only the TextBox values are successfully saved — the CheckBox and RadioButton states are not being captured.

Below is the relevant server-side code I am using:
GridJsWorkbook wb = new GridJsWorkbook();
wb.MergeExcelFileFromJson(uid, jsonStream);
wb.SaveToCacheWithFileName(uid, filename, password);
It seems the MergeExcelFileFromJson method is not correctly merging the state of CheckBox and RadioButton controls, even though TextBox values are merged and saved as expected.

We require thorough evaluation of the issue on why the state of CheckBox and RadioButton controls is not persisting. 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-1981

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.

amjad.sahi · October 7, 2025, 11:19am

@chirags,

This is expected behavior. When you use “Show Formulas” icon, it will display the formulas in the worksheet only.

I also confirmed Show Formulas (GridJs) feature is not matched with MS Excel’s feature. To support your needs, 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 support policies.

Issue ID(s): CELLSGRIDJS-1982

We will look into it soon. Once we have an update on it, we will let you know here.

chirags · October 7, 2025, 11:41am

@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?

chirags · October 7, 2025, 11:57am

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

amjad.sahi · October 7, 2025, 5:41pm

@chirags,

chirags:

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.

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.

chirags · October 8, 2025, 7:02am

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,

chirags · October 8, 2025, 7:06am

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,

amjad.sahi · October 8, 2025, 10:27am

@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.

amjad.sahi · October 8, 2025, 10:31am

@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.

peter.zhou · October 9, 2025, 9:31am

@chirags

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.

peter.zhou · October 9, 2025, 9:55am

@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.

chirags · October 9, 2025, 10:35am

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,

chirags · October 9, 2025, 12:24pm

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,

amjad.sahi · October 9, 2025, 12:58pm

@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.

peter.zhou · October 9, 2025, 1:42pm

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

peter.zhou · October 9, 2025, 1:52pm

@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

chirags · October 10, 2025, 3:32am

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,

chirags · October 10, 2025, 6:14am

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

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.

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.png (87.5 KB)
image.png (35.7 KB)
large_sales_dataset.zip (2.3 MB)

Could you please check these issues?

Thank you,

peter.zhou · October 10, 2025, 6:25am

@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.