The only thing I did consciously was to freeze the leftmost column.įreezing Panes1 - When I pulled on the top left gray line by accident, I discovered it created some sort of frozen pane. Can someone tell me what happened?įreezing Panes0 - Seems to be my original sheet.
And now I have three different sheets and don't even know how I got there.
I am not experienced, so I was experimenting on different sheets. Basing the solution on a source cell range makes things more cpmplicated.I am building an appointment book. My example using a shape demonstrates some of the needed steps. If you can reduce your requirements to "get a copy of a given cell range with contents, formats, anchored shapes, formulas and all" and accept that this copy is delivered in an actually visible range, and accept that contained references with relative parts are adapted the usual way. AOO doesn't develop any longer, and LibreOffoce also won't jettison basic concepts just to satisfy you. I probably misunderstood your "close this topic and contact the creator", but if this is meant to mean "I will post a feature request", there's no chance. If your definite desire is to get a cell range shown permanently in any view of the sheet, that's simply impossible. How can you make a video showing the expected behaviour if you couldn't implement it? Trick studio?Īlso : Is "image pasting" meant to mean "pasted images"? The common background of both the mentioned features is also the reason for what they can't be combined.Įeigor and how was such a video recorded with the required behavior?is right. That's very similar to what you get using the vertical/horizontal splitters with the difference, that cells may be displayed then in more than one panel what can't occur based on freezing. If the first non-frozen cell is in first column or first row, two of these panels are empty. Respectively for left panels and right panels concerning columns. The two top panels are synchronized concerning rows, and so are the two bottom panels. Freezing always cuts the view into 4 logical panels: left-top, left-bottom, right top, right bottom. Going one step to the right from A7 (e.g.), you always arrive at B7 (if column B is visible at all, and no special protection stands against or causes a jump).įreezing only can make unfrozen parts hiding behind the frozen ones. If the intention is to freeze A1:A15, and to let "glide up" the columns to the right without frozen rows, this is impossible. It's unclear to me what the questioner actually wants to achieve.
0 kommentar(er)
