The Camera option creates a scaleable image that shows the values in a selected range in one sheet that is inserted and anchored to another cell defined by the user. It can be linked via DDE to the source range so that the image displays any changes made.
Can't say I see any compelling need for this UI, but before rejecting out of hand dev thoughts on ease of implementing similar in Calc?
Would the image of some selected range be sv meta/bmp or an external format, assume similar is done for rendering Chart over a sheet?
But, if too complicated to do reliably--don't.
Looks like Microsoft has also no idea about the use case and hides this feature by default. The result can be achieved with existing functions, references, or per copy/paste.
Anyway, the 'viewport' has to be resizable, rotatable, and scalable. That's what people talk about when referring to the camera thing.
@Heiko, @V Stuart,
should this enhancement be accepted or rejected then?
UI is out of line, questionable use case and not clear there'd be any dev interest in the effort.
That's fair enough if no dev are into this.
But not sure it's because MS has no idea about use case that's it's not there by default. It might simply be because use case are quite specific?
If it is possible to achieve same result with existing functions, I (and others) would love to know how? It is a pretty useful tool for layout and printing spreadsheets. For example how could you print two different sheets (with different column width etc.) on one page in calc (and maybe also having the two sheets on different scaling factor)?
At least I couldn't do it and when I looked it up on the camera tool came up and everyone said it is not possible to do in LO.
Seems like a few people would like this...