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
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.
The issues you have found earlier (filed as CELLSGRIDJS-1981,CELLSGRIDJS-1986,CELLSGRIDJS-1989) have been fixed in this update. This message was posted using Bugs notification tool by leoluo
Could you please confirm the status of the following bugs?
Are all of these issues resolved in the latest version, or will they be included in the next release?
These issue are resolved in Aspose.Cells.GridJs 25.11, so you may try the latest version.
This issue is also resolved and the fix will be included in the upcoming release Aspose.Cells.GridJs 25.12 (which is scheduled to be published in the first half of December 2025).
The issues you have found earlier (filed as CELLSGRIDJS-1966) have been fixed in this update. This message was posted using Bugs notification tool by leoluo
Please check the bug CELLSGRIDJS-1944. It appears that the issue is still not fixed.
I am currently using the latest version 25.12, and the problem continues.
I also tried verifying it using the online demo URL, but there seems to be an issue there as well — the downloaded file does not open.
Request you to please look into this.
Thank you.
@chirags
please try set
Config.CustomPdfSaveOptions = new PdfSaveOptions();
Config.CustomPdfSaveOptions.AllColumnsInOnePagePerSheet = true;
or via:
services.Configure<GridJsOptions>(options =>
{
// ....... other options
options.CustomPdfSaveOptions = new PdfSaveOptions();
options.CustomPdfSaveOptions.AllColumnsInOnePagePerSheet = true;
// ....... other options
});
I am referring to CellsGridJs.
Can you please guide me on where exactly I need to set or configure it?
I want to make sure I am applying the correct settings and using the proper files for the latest version.