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.
@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.
Thank you,
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 (35.7 KB)
large_sales_dataset.zip (2.3 MB)
Could you please check these issues?
Thank you,
@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.
for this issue ,We can not reproduce .
can you show us the detail steps.
however ,we can see the color in the chart is not same as in MS-Excel.
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.
I have attached a screenshot for your reference.
Could you please check this behavior?
Thank you,
@chirags
per my test, we can see the calculated value is correct.
I am facing an issue with the FREQUENCY formula.
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.
clideo_editor_06f78ec4bfda41bbb409141ee5ffe017-ezgif.com-video-to-gif-converter.gif (184.8 KB)
image.png (3.9 KB)
Here is the value of cell
499
500
504
506
509
511
Formula
=FREQUENCY(A1:A6,{500,505,510})
I have attached a clip showing the behavior in Excel for your reference.
Could you please check and confirm this issue?
Thankyou,
In Excel, the formula returns four separate results
- Count of values ≤ 500
- Count of values > 500 and ≤ 505
- Count of values > 505 and ≤ 510
- Count of values > 510
However, in Aspose, it only returns a single cell value instead of multiple outputs across cells.
Could you please check this behavior?
Thank you,