@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.
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?
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.
@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
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.
@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.
@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.
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.
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.
In Excel, the same formula returns 4 values across multiple cells.
However, when I load or calculate it using Aspose, it only generates a single cell output instead of multiple values.
I tested in MS Excel and your formula returns single value based on your input data. Could you please zip and attach the template Excel file containing the FREQUENCY formula returning multiple values. We will look into it soon.
By checking the file you provided, I think you are talking about setting and calculating array formulas which is MS Excel’s feature. I tested and found I cannot set and calculate array formulas in Aspose.Cells.GridJs. When I input some values into the (A1:A6) cells as suggested by you, then select multiple cells (e.g., 4 cells (A8:A11) and add a formula, e.g., “=FREQUENCY(A1:A6,{500,505,510})”, then press CTRL+SHIFT+Enter keys, but it generates single cell output (result) only. I tested the same scenario/case using MS Excel manually, which works well and all four cells (A8:A11) have formulas results.
We require to evaluate on set and calculate array formulas feature. 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-1996
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.
We are pleased to inform you that your issue (Ticket ID: “CELLSGRIDJS-1984”) has been resolved. The fix or enhancement will be included in the upcoming release (Aspose.Cells.GridJs v25.10), which we plan to release in the next week of October 2025. Rest assured, we will notify you in this thread as soon as the new version becomes available.
We are pleased to inform you that your issue (Ticket ID: “CELLSGRIDJS-1980”) has been resolved. The fix/enhancement will be incorporated in the forthcoming release (Aspose.Cells.GridJs v25.10), which is scheduled to be launched within the next couple of days. We request you to stay tuned for updates.
