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.
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.
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.
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?
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
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.
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,
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,
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.
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.
@chirags
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.
@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.
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,
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,
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.
Yes,we don’t think it is an issue.we will not fix it.