We will evaluate your questions and get back to you with details.
@gokhanbal
For the serverside, we use the GridJs dll .
For the client side js, we use gridjs-spreadsheet which is based on xspread.js
In the github demo, you can see how to use them together to build an application.
-
We defined some formulas (which are common, and frequently used) tips in the client side js, so the formulas are shown in the insert menu.
However the calculate result process is in serverside(we support for all the formulas, if your spreadsheet file contains the formula we haven’t defined in the ui, the result will still be calculated).
When you enter value for example like “=SUM(A1:C1)” in a cell , it will trigger ajaxcall to get result from serverside.
When you run the demo, open the page in the browser, you can open the network tab in browser to see what happened after you update the cell value with formula. -
We support to display pivot tables. However the operation, such as select filter value in pivot field is yet not implemented. We will plan to finish such feature in future.
If you still find any issue or have other requirements, please go further to tell us. We will improve it.
Thank you for your response.
I am aware of that updatecell api sends the formula to server and calculation is done on the server end as you say. We are on the same page for that.
However, from the user perspective (our clients), they do not need to remember any of these functions. They should be able to select these functions from the menu. That is specifically what I was asking. Looks like I have to modify xspreadsheet.js to include functions that are not on the menu yet, so they appear on the menu.
I know that on the server side, you can use pivot tables programmatically. In your demo, on the UI menu, I did not see anything related to pivot tables. For clarification, a regular user can create a pivot table with your current demo or not?
Many thanks
-
Yes, you are right. Now we only list parts of formulas in the insert menu, which includes very common formula.
q_20240131231826.png (22.6 KB)
When you enter key, it will auto-popup the formulas. If you still want all the functions, can you provide a list of them? We will implement them in the insert menu. -
We cannot create a pivot table in the current ui. We only support to render it.
When you import a spread file with pivot table, we will render the pivot table.
However, the interaction for pivot field, such as, select filter, is not implemented yet. We will improve it in future.
1 Like
Thank you very much
@gokhanbal
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-34,CELLSGRIDJS-1010
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 got a follow up question and and a suggestion.
Follow up question: If you were to add proper, today, value, ifna, and trunc functions to UI menu, how long would it take you?
Suggestion: From a user perspective, when I click Insert - Functions menu item, the list is so long and not user friendly. Is there a way you can categorize these to enhance UX?
Thanks
@gokhanbal
we are sorry for the inconvinent.
We will add those formulas in the insert menu in the next v24.3 version.
We will adjust the menu height and make it suitable to display. 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-1009,CELLSGRIDJS-1013
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.
1 Like
The issues you have found earlier (filed as CELLSGRIDJS-1013,CELLSGRIDJS-1009) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi
1 Like
I am wondering if this change has been released…
We will add those formulas in the insert menu in the next v24.3 version.
We will adjust the menu height and make it suitable to display. 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.
I just updated our Aspose.Cells and Aspose.Cells.GridJS nuget packages to version 24.4.0 and the menu items for functions still appears as a long list in a single column and not as it shows on your example site as shown here:
If this is released in this version, is it possible the CSS elements were not included in the release. Please provide documentation with steps needed to update the UX menu to match what is shown on your example site.
Many thanks!
@bmcculloch
You need to update the client js to the latest v24.4.0 in npmjs also .
you can use the reference like this:
<link rel="stylesheet" href="https://unpkg.com/gridjs-spreadsheet@24.4.0/xspreadsheet.css">
<script src="https://unpkg.com/gridjs-spreadsheet@24.4.0/xspreadsheet.js"></script>
Please let us know if you still meet any issues.
Thank you, these updates have fixed my issue!
@bmcculloch
You are welcome. Thank you for your feedback. If you have any questions, please feel free to contact us.
Hi Aspose Team, I have found a small bug in the JavaScript code provided for the latest Aspose.Cells 24.4.0 release. The bug is that the RANK function tooltip is showing the tooltip from the FREQUENCY funtion…this issue can be replicated on your example site as shown in this screenshot:
image.png (467.8 KB)
The issue is caused by the JavaScript code for Rank using the frequency formula title:
key:“RANK”,title:it(“formula.frequency”)
image.jpg (526.7 KB)
This is a very minor issue showing the wrong tooltip, but just letting you know.
Thanks
Thanks for your findings.
We noticed the issue as per your observation. It seems the RANK formula description is duplicated with the FREQUENCY function as you pointed out.
We will look into it soon. 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-1104
We are pleased to inform you that the issue (logged as “CELLSGRIDJS-1104”) has been resolved now. The fix will be included in an upcoming release (Aspose.Cells.GridJs v24.6) scheduled for release in the second week of June 2024. You will be notified when the next version is released.
AfterTabClick.png (423.8 KB)
Thank you for all of your assistance; however, I am still seeing an issue with the latest version. I have just updated to v24.7.0 and on initial page load of an excel edit page I have, I am seeing JS errors in devtools as shown in screenshot. This issue is causing a problem where the excel content does not load until the sheet tab is clicked on at the bottom. Can you please check this or let me know what needs to be updated?
Error On Load:
After Content Tab Clicked:
AfterTabClick.png (423.8 KB)
Many thanks!
I work closely with @bmcculloch and we were able to resolve the issue posted above by fixing an incorrect value in our setImageInfo call.
We are still encountering an issue with the updating.gif though. We have noticed that if the .gif does not exist in the default path (/content/img/updating.gif), which ours does not, x_xpreadsheet tries to use the gif in the default path (which in our case does not exist and throws a console error) before we can update the path using setImageInfo. We are using a nearly identical setup as the demo uidload.html (link to Aspose github), the difference being that we specify a gif url in xs.setImageInfo