Re: Zoom Level Affects Shapes Positioning
ah, i didn't realise that the problem lie may lie in drawing objects being on a different layer of the sheet than the cells. So as Dave says, zoom doesn't affect offset value per se, but the position of shapes layers relative to cell layers.
yes only performing function on 50% or 100% is possible. but if anyone happens to discover a formula that can compensate for the 'zoom effect' on shape position, please share.