Hi Team,
Any Update on this?
Thanks,
Krishna
We are sorry but no updates at the moment. However, we will make an effort to give you a rough estimate regarding the resolution of the issue in the coming days. We sincerely regret any inconvenience this may have caused you.
As we have said, even though we spent a lot of time to investigate this issue, we can not find the pattern of ms excel to process such kind of group shapes. Neither can we get sufficient documents or information about ms excel’s logic and behavior. So we have suspended this task. Once we find the possible solution and resume the work on it, we will give feedback here. Before that, we are afraid we cannot provide fix or even estimate timeline for it. We are very sorry for the inconvenience caused, unfortunately we cannot find better solution for you currently.
@rnara
We are sorry but no updates at present . Once we have any new information, we will share it with you. We will get back to you soon.
Hi team,
Any update on the issue, can you please provide ETA?
Thanks,
Krishna
@rnara
Sorry, there is currently no update. However, we will strive to provide you with a rough estimate of the solution to the problem in the coming days. We deeply apologize for any inconvenience caused to you.
@rnara
We found that the cause of the problem is that when we render shapes in a “group” state, the calculated size is different from the expected one. After extensive research on Excel’s group shape behavior, we found that the problem only occurs in some specific cases, and we have not found a suitable pattern to handle such cases. We found that in this particular case, the “group” and child shape data do not seem to comply with the record rules published by Microsoft. This may be a processing rule that Microsoft has not published. Therefore, we cannot provide a fix in a short time or even estimate the timeline for resolving this issue. I am afraid that we have to suspend this task until we can find relevant rules or documents that can help resolve this issue in the future. We deeply apologize for this. We provide three temporary solutions to help you continue to work normally:
“ungroup” the shapes.
- 1 Open file
- 2 Click “Page Layout” in the top options
- 3 Click ‘Selection Pane’ in the expanded options
At this time, the names of all shapes in the workbook are listed in the list on the right. Selecting a name in the list automatically selects the corresponding shape/group in the workbook. - 4 Select Group
you can select a “Group” respectively in the left list - 5 Then find the corresponding selected range in the workbook
- 6 Right-click->Group->Ungroup.
Choose any of the methods below to do this.-
- Right-click the mouse within the selected range. It is more difficult to operate when there are many nearby shapes.
-
- Hover the mouse over the edge of the selected range and right-click when the black cross symbol appears.
-
- The selected range usually has a hollow cross symbol, right click on it.
-
- 7 After 6 operations, the selected “group” is no longer a whole, but all selected.
It should be noted that it is necessary to “ungroup” until the expected shape is no longer surrounded by the “group”.
For your question:- 1)Perform an Ungroup operation on ’Group 7‘ .
- 2)Perform an Ungroup operation on ’Group 35‘.
- 8 Save document
Use VBA macro to cancel all partitions in one click
- 1 Open file
- 2 Open the VBA Editor
Press Alt + F11 to open the VBA Editor. - 3 Insert a module
In the VBA Editor, click Add-ins on the menu bar and select Modules. - 4 Paste the code
Paste the following code into the module window:
Sub UngroupAllShapes()
Dim shp As Shape
For Each shp In ActiveSheet.Shapes
If shp.Type = msoGroup Then
shp.Ungroup
End If
Next shp
End Sub
- 5 Run the macro
Press F5 to run the macro, or return to Excel and choose to run UngroupAllShapes from the macro. - 6 Save document
Replace the problematic part with a picture
The expected graphic combination can be made into a picture and then inserted into the document, which is very helpful for solving some complex graphic requirements.
Hi
Any update on the fix for this issue?
Can you please provide ETA?
Thanks,
Krishna
@rnara
Sorry, there is currently no update. We deeply apologize for any inconvenience caused to you. Please try the temporary solutions provided by @duojie.yang.
Hi @John.He,
Any update for the fix on this issue?
As customer has already mentioned they are not good with temporary solution.
Thanks,
Krishna
@rnara
We deeply apologize for any inconvenience caused to you. We cannot provide a fix in a short time or even estimate the timeline for resolving this issue. I am afraid that we have to suspend this task until we can find relevant rules or documents that can help resolve this issue in the future. Once we have any new information, we will share it with you.
@rnara
Sorry, there are currently no updates. We are unable to provide a fix in a short period of time, and we cannot even estimate a timeline for resolving this issue. I’m afraid we have to pause this task until we find relevant rules or documents that will help solve this problem in the future. Once there are updates, we will notify you promptly.
We apologize for the inconvenience, but we have not yet located the necessary documents, rules or guidelines required to resolve the issue. Until we find these resources, we are unable to provide an estimated time of resolution. Rest assured, we are searching for the relevant materials and will update you as soon as there are any new developments or updates. Thank you for your understanding and patience.
Hi,
Can you please share the progress on this issue?
Thanks,
Krishna
@rnara
We apologize for the inconvenience, there is currently no update. We deeply apologize for any inconvenience caused to you. Please try the temporary solutions provided by @duojie.yang.