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

@chirags,

I tested your scenario using the online editor app (developed by Aspose.Cells.GridJs). I inserted and edited comments in the worksheet and then saved the file in XLSX format. After opening the generated XLSX file in MS Excel, I verified that the comments, along with their contents, were present. Could you kindly provide detailed steps regarding the issue you are experiencing? Specifically, how is the comments’ auto-save feature not functioning as expected? We will review and address this soon.

50

Currently, for comments we have to save manually on the server side. It is not saving automatically like cell edits.

In the earlier version, comments were saving the same way as cell values (auto-save). Now that behavior has changed — cell values still save automatically, but comments do not. Can you please check why this difference is happening?

51

@chirags,

Alright, we will evaluate on comments save manually on server side module and get back to you soon.

1 Like
52

@chirags
From reviewing the code history, I can confirm that even in earlier versions, comments were not saved in the same manner as cell values (auto-save). Comments are specifically designed to perform a batch merge operation only during the save process and do not update in the same way as cell values.

53

I am experiencing an issue while working with a column that contains data like 1, 2, 3, A. When I select the rows accordingly and check the count, it shows 3 instead of 5.

image.png (35.0 KB)

I have attached an image for your reference. Could you please check and advise on why this discrepancy is occurring and how to resolve it?

Thank you for your assistance.

54

@chirags
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-1966

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.

55

Hello Team,

In the attached file, when the file is loaded for the first time, I noticed an issue in the Formula sheet.

If I enter a value (for example, 50) in cell K3, the Update method is called 9 times, even though the formula cell is not actually updated.

I am attaching the file for your reference. Could you please check why the update method is being triggered multiple times in this scenario?

sample_excel.zip (7.6 KB)

Thank you for your help.

56

@chirags,

Thanks for the template Excel file and details.

We require thorough evaluation on the reason why the Update method is being called multiple times when a value is entered into a cell. 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-1977

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.

57

I found another issue in the attached file. When I cut three cells from a column and paste them into the last row, it does not trigger the UpdateCell method, and the InsertRow method is also not triggered.

Could you please check why these events are not firing during the cut-paste operation?

Thank you for your assistance.

58

@chirags
Ok,we will check it.

59

@chirags,

I tested your scenario using the provided Excel template file with the online editor app (developed by Aspose.Cells.GridJs). Using Google chrome browser with Developer tools enabled, I observed that when cutting data cells and pasting them into the last row of the worksheet, the UpdateCell is triggered, but the InsertRow is not. Could you please provide more details, along with a sample demo and screenshots to illustrate the issue? Additionally, please share your browser information. We will investigate this issue soon.

60

Sure, in the cut and paste event, in my case, only the Delete event is being triggered — the Update event is not generated for the pasted cells.

Also, I tried using the Search options. It works fine when searching by value and formula, but it’s not working when searching inside comments.

Could you please check this issue as well?

61

I have tested the current implementation and noticed the following behavior:

  • TextBox controls: Saving works correctly on the server side.
  • CheckBox and RadioButton controls: Although the server-side save logic executes, the values are not being saved.

Could you please check why the state of CheckBox and RadioButton controls is not persisting? It seems the issue might be related to how their values are being posted back or bound.

Attached are the steps to reproduce:

  1. Enter text in a TextBox → Save → Works correctly.
  2. Select a CheckBox or RadioButton → Save → Value does not persist.

Please advise on a fix or guidance on how to handle these controls correctly.

Thank you.

62

I have observed the following behavior in the grid:

  • When I enter a date in a cell and click on it, the date picker opens correctly.
  • However, no date is selected by default in the picker.
  • The picker always defaults to the 7th of the month instead of the cell’s current value.(Current Date)

image.png (13.8 KB)

I am attaching a screenshot for reference. Could you please check why the date picker is not reflecting the cell’s existing value by default?

Thank you for your support.

63

I have found another issue related to cell formulas in the grid:

  • When I copy a cell with a range, the Count/Average is displayed correctly for that range.
  • However, if I paste it into another cell, the Count/Average does not update automatically.
  • Currently, I have to manually reselect the range to get the correct Count/Average.

This behavior is inconsistent with Microsoft Excel, where such calculations automatically update upon pasting into a new location.

image.png (16.9 KB)
image.png (6.7 KB)

I am attaching a screenshot for reference. Could you please investigate why the Count/Average is not recalculating automatically when pasting copied cells?

Thank you for your support.

64

@chirags
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-1979 Count/Average does not work as expected

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.

65

@peter.zhou
Can you Please check Other Issue As Well ?

Thankyou

66

@chirags,

Yes, this is by design and current date would be always selected. You have to pick your desired date to re-set to cell value.

67

@chirags,

I did test using the online editor app and it works fine. See the screenshot of the saved/downloaded Excel file for your reference.
sc_shot1.png (42.1 KB)

Could you please share more details on the issue with sample Excel file, scripts, steps involved and output Excel file for reference. We will check your issue soon.

68

@chirags,

I tested your scenario/case using the online editor app and noticed this issue. I found Search options are not working when searching inside comments in Aspose.Cells.GridJs.

We require thorough evaluation of the 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): CELLSGRIDJS-1980

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.