I am sending you the attached file in which I am facing the issue.
Steps to reproduce:
Preview the file.
Change the sheet and go to Sheet1.
Open the Review tab and click on Edit Comment → the UI gets spoiled.
Also, try to export this file as PDF → the output is not correct, some columns are cut off and moved to the next page.
chart.zip (37.1 KB)
This issue happens specifically with this file. Could you please check?
Thank you.
@chirags
Using the file you provided.We can reproduce the first 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-1943 Edit comment does not work as expected
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.
Thanks for the sample Excel file.
I tested your scenario using an online editor app and observed the issue. The problem arises due to the large merged cell A1 (spanning the range A1:L1). When selecting the “Edit Comment” option from the Review menu, the UI popup appears at the top-right boundary of the worksheet. However, clicking on any other cell, such as A2 (then using “Edit Comment” option), resolves the issue. We will investigate this further. A ticket with the ID “CELLSGRIDJS-1943” has been logged, and we will address it promptly.
I tested your Excel file and found that this is not an issue with the component. The Aspose.Cells.GridJs tool, which functions similarly to MS Excel, generates PDF files based on the print previews of the worksheet. To verify this, you can manually open the Excel file in MS Excel and navigate to Sheet1. Then, check the Print Preview of the worksheet, and you will notice that the display matches the output PDF generated by Aspose.Cells. Additionally, if you save the file as a PDF directly in MS Excel, you will achieve the same results.
In MS Excel, we have the option “Fit all columns on one page” while exporting to PDF, so we can manage this issue there. Is there something similar available in GridJs to handle this?
image.png (101.1 KB)
Thank you.
Thanks for the screenshot.
We have these options available in Aspose.Cells library. So you may use them when rendering Excel file to PDF via Aspose.Cells. See the documents with examples for your reference.
I know this feature is available in Aspose.Cells where we can set the option to fit all columns on one page while exporting to PDF.
But what about Aspose.Cells.GridJs?
When I click Download As PDF from the File menu in GridJs, how can I change that behavior so it uses the same “Fit All Columns on One Page” option? Can you please guide me on how to configure this?
Thankyou
@chirags
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-1944 Support option "Fit all columns on one page" while exporting to PDF in GridJs
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.
In the earlier version, when I added or edited a comment it was saving automatically on the server side — I didn’t have to do a manual save.
But in the new version, the comment auto-save is not working anymore. Now I have to save it manually for it to persist on the server side. Can you please check this?
thankyou
I tested your scenario using the online editor app (developed by Aspose.Cells.GridJs). I inserted and edited comments in the worksheet and then saved the file in XLSX format. After opening the generated XLSX file in MS Excel, I verified that the comments, along with their contents, were present. Could you kindly provide detailed steps regarding the issue you are experiencing? Specifically, how is the comments’ auto-save feature not functioning as expected? We will review and address this soon.
Currently, for comments we have to save manually on the server side. It is not saving automatically like cell edits.
In the earlier version, comments were saving the same way as cell values (auto-save). Now that behavior has changed — cell values still save automatically, but comments do not. Can you please check why this difference is happening?
Alright, we will evaluate on comments save manually on server side module and get back to you soon.
@chirags
From reviewing the code history, I can confirm that even in earlier versions, comments were not saved in the same manner as cell values (auto-save). Comments are specifically designed to perform a batch merge operation only during the save process and do not update in the same way as cell values.
I am experiencing an issue while working with a column that contains data like 1, 2, 3, A. When I select the rows accordingly and check the count, it shows 3 instead of 5.
image.png (35.0 KB)
I have attached an image for your reference. Could you please check and advise on why this discrepancy is occurring and how to resolve it?
Thank you for your assistance.
@chirags
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-1966
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.
Hello Team,
In the attached file, when the file is loaded for the first time, I noticed an issue in the Formula sheet.
If I enter a value (for example, 50) in cell K3, the Update method is called 9 times, even though the formula cell is not actually updated.
I am attaching the file for your reference. Could you please check why the update method is being triggered multiple times in this scenario?
sample_excel.zip (7.6 KB)
Thank you for your help.
Thanks for the template Excel file and details.
We require thorough evaluation on the reason why the Update method is being called multiple times when a value is entered into a cell. 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-1977
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 found another issue in the attached file. When I cut three cells from a column and paste them into the last row, it does not trigger the UpdateCell method, and the InsertRow method is also not triggered.
Could you please check why these events are not firing during the cut-paste operation?
Thank you for your assistance.
I tested your scenario using the provided Excel template file with the online editor app (developed by Aspose.Cells.GridJs). Using Google chrome browser with Developer tools enabled, I observed that when cutting data cells and pasting them into the last row of the worksheet, the UpdateCell is triggered, but the InsertRow is not. Could you please provide more details, along with a sample demo and screenshots to illustrate the issue? Additionally, please share your browser information. We will investigate this issue soon.