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,
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.
Thanks for the sample file.
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.
The issues you have found earlier (filed as CELLSGRIDJS-1944,CELLSGRIDJS-1982) have been fixed in this update.
for CELLSGRIDJS-1944 Support option “Fit all columns on one page” while exporting to PDF in GridJs
now you can set Config.CustomPdfSaveOptions or through GridJsOptions.CustomPdfSaveOptions
below is the example code:
PdfSaveOptions MyCustomPdfSaveOptions=new PdfSaveOptions();
.......
Config.CustomPdfSaveOptions=MyCustomPdfSaveOptions;
PdfSaveOptions MyCustomPdfSaveOptions=new PdfSaveOptions();
.......
services.Configure<GridJsOptions>(options =>
{
options.LazyLoading = true;
options.FileCacheDirectory = TestConfig.TempDir;
options.CustomPdfSaveOptions= MyCustomPdfSaveOptions;
});
@chirags
Now you can update to v25.10
server side:
.net package
Java pom:
<dependency>
<groupId>com.aspose</groupId>
<artifactId>aspose-cells</artifactId>
<version>25.10</version>
</dependency>
<dependency>
<groupId>com.aspose</groupId>
<artifactId>aspose-cells</artifactId>
<version>25.10</version>
<classifier>gridjs</classifier>
</dependency>
client side:
gridjs-spreadsheet.
We are pleased to notify you that your issue (Ticket: “CELLSGRIDJS-1981 - The state of CheckBox and RadioButton controls is not persisting”) has been resolved. The fix will be included in the upcoming release (Aspose.Cells.GridJs v25.11) that we plan to release in the first half of November 2025. You will be notified when the next version is released.