Alright, we will evaluate on comments save manually on server side module and get back to you soon.
1 Like
@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.
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.
@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.
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.
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.
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.
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.
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?
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:
- Enter text in a TextBox → Save → Works correctly.
- 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.
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.
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.
@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.
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.
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.
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.
I am facing an issue where TextBox values are saving correctly, but CheckBox and RadioButton values are not being saved.
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.
Could you please review this behavior and confirm if additional handling is required for form controls like CheckBox and RadioButton, or if this is a possible bug?
Thank you for your support.
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.