Thanks for your help , Just FYI this is a high priority for us.
We would really appreciate your guidance on how to achieve this.
Thank you for sharing your requirements and expressing your concerns. We will evaluate your needs in detail and follow up with updates soon.
@pgcentric
A group is essentially a nested data table. So it is recommended to completely nest the data sources if using json. See attached files:
demo.zip (29.9 KB)
Thanks for quick response. We do not have control over JSON structure. other than what I shared previously we can have following two JSON structures. is there some other way to achieve this with smart markers only ?
json_structure.zip (973 Bytes)
@pgcentric
Thanks for your feedback and details. We will investigate your issue further. Once we have an update on it, we will let you know.
- yoga.json:
Since “AllSections” and “Groups” are properties of “QuoteCostScenario,” there is no direct hierarchical/subordinate relationship between them, which prevents us from achieving grouping. - yoga2.json:
We should sort Materials first in the data source , then we can start grouping them. - We are still investigating how to support data grouping across multiple rows. Currently, grouping is only supported for smart markers within a single row.
@pgcentric
Please check group.zip (56.2 KB)
We have supported “range” parameter of smart marker and sorting json data source with designer.SortDataSource = true;
This fix will be included into the next version 25.8 which will be released in the next month.
BTW, we can not support group with yoga.json because we can not find relations between two properties.
@pgcentric
We have supported sorting json data source to fix the issue CELLSJAVA-46414 in the next version 25.8.
See attached template file and codes:
CellsJava46414.zip (19.3 KB)
The issues you have found earlier (filed as CELLSJAVA-46414,CELLSJAVA-46426) have been fixed in Aspose.Cells for Java 25.8.
Thank you,
We are testing the transpose functionality of Excel. Excel provides “=TRANSPOSE(range)” function, so we tried &==TRANSPOSE(A2:A7) this produces"=@TRANSPOSE(@A2:A7)".
When we use the default formula =TRANSPOSE(A2:A7), and in the code setting
designer.setCalculateFormula(true);
This produces the result, but adds 0 to empty fields. As data is always dynamic, for example, “&=node.arrayNumber”, this could have 5 elements, 4 elements, or 10 elements. The above approach is not reliable.
Could you please advise on how we can handle this scenario with TRANSPOSE when working with dynamic arrays and Smart Markers?
transpose.zip (29.9 KB)
I tested your scenario/case using your template Excel file and JSON data file. Could you please also share a sample Excel file having your expected data and formulas into the specified cells. We will look into it soon.
The resultant formula you require for such situation is the new kind of array formula supported by new version of ms excel: dynamic array formulas
Currently such kind of formula has not been supported by smark marker yet. 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): CELLSJAVA-46470
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.
Hi, when testing subtotal, we observed the following
When creating a subtotal with productID, one extra row gets added above the smart marker. Also last column’s cell border-bottom style is different than the previous columns. Could you please check this
Thanks
subtotal_sort.zip (30.7 KB)
@pgcentric
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.
CELLSJAVA-46473: last column’s cell border-bottom style is different than the previous columns
CELLSJAVA-46472: one extra row gets added above the smart marker
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.
@pgcentric
Please check the range "A1:C3“，”A4：C6“ in ”subtotal sort“, there are only top borders on the smart markers. There is a confusion. Should we copy borders to each data row or not ? Some users do not want to copy to each row for they want to make the old borders as a splitter of header and data.
TRANSPOSE.zip (25.5 KB)
Please check the attached file, I changed the smart marker formula to dynamic formula, it worked file.
We will enlarge the range A2:A7 when processing data.
@pgcentric
We have supported setting dynamic array formula for dynamic formula smart marker, please change smart marker as :
&==TRANSPOSE(OFFSET($A$2,0,0,COUNTA($A$2:A{-1}),1))~(formula:dynamicarray)
This feature will be included into next version 25.9.
This is to inform you that the issues (“CELLSJAVA-46472” and “CELLSJAVA-46473”) have been resolved. The fixes/enhancements will be incorporated in the next release (Aspose.Cells v25.9), which is scheduled for the first half of September 2025. You will receive a notification once the new version is released.
Hi, while testing this fix, we observed that if we want to group by “Fabric”.It is not producing expected results. Could you please check this? Also, is there official documentation about the “Range” parameter ?
Expected :
expected.png (19.5 KB)
Template, Data, Output
group_column.zip (36.0 KB)
@pgcentric
We have analyzed your expected result image. We have found that your expected results require grouping “Materials.DSSection.C$Name” and sorting the data in descending order. But there is one issue, the data you need to group is at the next level of “Materials.C$Name”.
Grouping data based on the next level and sorting it in descending order will break the original data structure and fail to obtain the expected data results.
Additionally, there is currently no document available regarding the range parameter. We will add it soon.
We are unable to implement your requirements through the smart marker. Sorry for any inconvenience caused to you.