I am new to Blender and would like to get done the following:

How to make an exploding wall so that it leaves hole? I have tried Cell Fracture- addon, but the results are sharp shards.

At the Youtube I have seen animations, where the breaking pieces are like rock, for example Phymec is awesome.

Second, how to prevent whole wall (simple cube) collapsing so that the wall stays on place, but gets a hole exploding?

Might have to model the wall as two pieces. Model both the wall with appropriate kind of hole cut into it, and the piece of the wall that gets blown out. Fit the two togethter seamlessly, and then do the fracture just on the stuff getting blown away.

May also want to use particle emitter to make some extra debris, and hide your various bits and chunks to be emitted off the visible part of the scene. That should give more variety than the shard shapes the voronoi fracture makes.

There might be a better solution, but that's the one I could think of off the top of my head.

Thank you foor the hints. I have to try that way, but also need to explore through related tutorials, for Blender if filled with tons of features and learning even the basics is yet on early beginning. I think that the solution could be achieved in many ways, I think of combiation use of Blender and Wings3D, which was way easier to get in so, that I got something additional to just basic geometries... Phew, I think this may take time when all the tricks of Blender are yet unknown by me...

I know how that goes. :)

There's probably a plugin somewhere that makes it all simple, but unless you know where to look...