The TestSmartMarkers file is template file,I merge A3 and B3 and want to get a result like ExpectedResult, the A3 B3 A6 B6 A10 B10 can automatically be merged when expanded by subtotal9 formula. SubTotalMerge.zip (126.0 KB)
Above SubTotalMerge is a simple sample code, the ExpectedResult file is what I want to implement
the OutPut file is result now.
@kevinzhang,
We have logged the issue as “CELLSJAVA-43250” in our database for investigations. Once we will have some news for you, we will update you in this topic.
We are pleased to notify you that your issue has been fixed. We will soon share the fixed version in the next few days after we have done QA and included other enhancements and fixes.
We have apply the latest version you provided v20.7.7, after our QA testing, we found it doesn’t work well when we use conditional formatting.
Below is a demo code that records problems we found.The output file is actual result and expectedresult file is what we want, TestSmartMarkers is template file. I set conditional formatting at C2 and C3 respectively but found wrong results in this tow conditions. SubTotalMerge 2.zip (150.1 KB)
Except conditional formatting setting, now everything looks fine and the subtotal label cell merging problems have been solved. Hope for your reply!! thank you
I have logged a separate ticket with an id “CELLSNET-47543” for your issue. We need to evaluate thoroughly if this is an issue or other limitation where it does not update settings of conditional formatting when processing smart markers.
Once we have an update on it, we will let you know.
@kevinzhang,
,
This is to notify you that we have fixed your issue now. You will be provided the fix in the next few days after we have performed QA and incorporated other enhancements and fixes.
After our QA testing, we found a bug caused by the latest jar aspose-cells-20.8.3 I got , this makes the hidden columns displayed abnormal and I took a long time to find the root cause and build the demo project. This new jar conflict with the “setHiddenColDisplayType(HtmlHiddenRowDisplayType.REMOVE)” setting. Below is the demo project.
To manage issues accurately, we have added a new ticket with an id “CELLSJAVA-43286” for this issue. We have closed the existing ticket “CELLSNET-47543” now. The new ticket is logged as following:
CELLSJAVA-43286 - Aspose.Cells conflicts with the “setHiddenColDisplayType(HtmlHiddenRowDisplayType.REMOVE)” settings